Objectives
After completing the course, participants will be able
to:
-
Open,
close and print Access files
-
Create
a new database file, table & form
-
Enter
records in Form view
-
Edit
records in Datasheet view and Form view & modify Datasheet view
-
Sort
the records in a table and create and apply a filter
-
Create,
run and modify a query
-
Create
and modify tabular and grouped reports
-
Use
the Spelling Checker
-
Copy,
rename and delete database objects
-
Import
spreadsheet data into an Access tab
What you will learn
Topics covered by this course include:
Getting Started
-
The Access
Application Window
-
Basic Access
Terminology
-
Examining
Access Objects
-
Resetting the
Database Folder
-
Displaying
Help Information
Setting up a New Database
-
Creating and
Designing a New Database
-
Creating a New
Table
-
Entering
Records in Datasheet View
-
Printing the
Datasheet of a Table
|
Creating a Form/
Modifying and Manipulating Data
-
Creating a
Form
-
Switching
Between Form View and
Datasheet View
-
Entering
Records in Form View
-
Editing and
Deleting Records in Datasheet View and in Form View
-
Modifying the
Datasheet View of a Table
-
Sorting the
Records in a Table
Displaying Selected Records
-
Creating and
Applying a Filter
-
Creating,
Running and Modifying a Query
-
Numeric
Conditions and Calculated Fields
Creating a Report
- Simple Tabular Reports and
Grouped Reports
Additional Access Features
|
Access
2000