Access

Overview:

This course assumes no previous experience of database design. However, delegates with some experience in database design will find this course beneficial if they do not know Access.

Introduction to Databases

• Database concepts

• Database Layout

• Launching Access.

• The Access Menu System

• Dialog Boxes

• Getting Help

• Creating A New Database

• Creating an Access Web App

• Closing A Database (Vs Exit Access)

• Opening A Database

Tables

• Database Design.

• Creating Tables Using The Table Wizard

• Creating Tables In The Datasheet View

• Creating Tables In The Design View

• Data Types

• Field Properties

• Data Display Format Vs Input Mask

• The Input Mask

• Data Entry Problems

• Moving And Copying Records

Working with Tables

• Pasting Records

• Sorting The Table

• Deleting A Table

• Table Layout Changes

• Find

• Replace

• Wildcards

Queries

• The Simple Query Wizard

• The Design View

• Modifying The Query

• Using Basic Criteria

• Additional Criteria

• Parameters

• Multiple Object Queries

• Custom Calculations In A Query

• Calculating Fields Continued

• Grouping Fields

Introduction to Reports

• Reports

• The Report Wizard