Objectives
After completing the course, participants will be able to:

• Navigating Records in Tables and Forms

• Create a new database file, table & form

• Enter records in Form view

• Edit records in Datasheet view and Form view & modify Datasheet view

• Create a Simple Query

• Create, run and modify a query

• Create and modify tabular and grouped reports

• Compact and Repair a Database

• Copy, rename and delete database objects

• Import spreadsheet data into an Access table

What you will learn
Topics covered by this course include:

Getting Started

• The Access Application Window

• Using the Microsoft Office Button and Quick Access Toolbar

• 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

• Navigating Through Records in Datasheet View

Creating a Form/Modifying and Manipulating Data

• Creating a Form

• Switching Between Form 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

• Navigating through Records in a Form

Displaying Selected Data

• Creating and Applying a Filter

• Creating a Simple Query

• Creating, Running and Modifying a Query

• Numeric Conditions and Calculated Fields

Creating a Report

• Simple Tabular Reports and Grouped Reports

• Modifying a Report

Additional Access Features

• Compacting and Repairing a Database

• Copying, Renaming and Deleting Database Objects

• Importing Spreadsheet Data

Prerequisites
Basic computer skills are recommended for this course.

Dates and times
Please refer to your Fourth R centre for dates and times.

© Copyright The Fourth R^®