Course Introduction

• Starting & exiting Access
• The Access screen
• The database control window
• Accessing help

Creating a Database

• Database concepts & planning
• Designing & creating a database
• Different database components

Creating Tables

• Field names & data types
• Setting the field properties
• Building indexes
• Setting the primary key
• Saving a table
• Changing the table design

Datasheet View

• Using datasheet view
• Changing datasheet view

Creating Forms

• Creating an AutoForm
• Using Form Wizard
• Working with records:
  adding, finding, editing, deleting and sorting

Enhancing a Form

• Selecting controls
• Moving controls
• Resizing controls
• Inserting controls
• Deleting controls
• Changing the tab order
• Changing the control label text
• Formatting controls

Using the Toolbox

• Adding calculations to forms
• Inserting text onto the form
• Adding rectangles & lines
• Inserting pictures
• Using Option groups
• Using Combo boxes
• Using List boxes

Relating Tables

• Relational concepts & rules
• Relating tables
• Setting referential integrity
• Using forms with linked tables
• Using a Combo box on a form to lookup data from another table

Select Queries

• Select the fields
• Setting the criteria
• Sorting the records
• Hiding fields
• Using queries with linked tables
• Using calculated fields in queries
• Creating a parameter query

Reports

• Using Report Wizard
• Creating a tabular report
• Print preview
• Printing a report

Enhancing a Report

• Report sections
• Applying enhancements
• Controls & calculations

Other Reports

• Grouping & summary reports
• Using reports with linked tables
• Using reports with queries
• Producing mailing labels
• Merging with Word
• Analysing to Excel