Course Contents
Introduction
Getting started
·
What is Access?
·
Starting Access
·
The Access Application Window
·
Using the access menu system, using the Microsoft
Office button
·
Using the quick access toolbar, basic Access
terminology
·
Examining Access Objects
·
Resetting the database folder, displaying help
information
·
Exiting from Access
Setting Up a New Database
·
Designing a New Database
·
Creating a New Database
·
Creating a New Table
·
Entering Records in Datasheet View
·
Printing the Datasheet of a Table
·
Navigating Through Records in Datasheet View
·
Closing a Table/ Closing a Database
Creating a Form/ Modifying and
Manipulating Data
·
Reopening a Database/Reopening a Table
·
Creating a Form
·
Navigating Through Records in Form View/ Closing
a Form
·
Reopening a From
·
Switching Between Form View and Datasheet View
·
Entering Records in Form View
·
Editing Records in Datasheet View and in Form
View/ Using the Find Feature
·
Deleting Records in Datasheet View of a Table
·
Sorting Records in a Table
Displaying Selected Data
·
Filtering the Records in a Table
·
Creating a Simple Query
·
Creating a Query in Design View
·
Modifying a Query
·
Including a Numeric Condition in a Query
·
Including a Calculated Field in Query
Creating a Report
·
Creating a Simple Tabular Report
·
Creating a Grouped Tabular Report
·
Modifying a Report
Additional Access Features
·
Copying, Renaming and Deleting Database Objects
·
Compacting and repairing a database, backing up a
database
·
Importing Spreadsheet Data into an Access Table
·
Importing text into an Access table
Final Case Study