Microsoft Access 2007
Part
1
Course Code: AD570

Learn how to use this database program to simplify record keeping.  This introductory course shows you how to build, edit, sort and query databases.

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

 [Back to MS Office Training Courses]