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