A TOUR OF ACCESS

• Microsoft Access Interface
• Starting Access
• The Backstage View
• Opening An Existing Database File
• Understanding The Access Screen
• Working With The Navigation Pane
• Working With Database Objects

DESIGNING A LOOKUP DATABASE

• How Access Stores Data
• Access Data Types
• Identifying Table Problems
• Refining Table Structures
• Finalising The Design
• Creating A Lookup Database
• Creating A New Database File
• Creating The Lookup Table
• Defining The Primary Key
• Relationships
• Connecting To A Lookup Table
• Viewing Table Relationships

MODIFYING TABLE STRUCTURES

• Adding Fields To An Existing Table
• Understanding Field Properties
• Changing Field Size
• Changing Field Names
• Changing Decimal Places
• Changing Date Formats
• Indexing Fields
• Deleting Fields From A Table

FORMS

• Creating A Basic Form
• Creating A Split Form
• Binding A Form To A Query
• Using The Form Wizard
• Working With Existing Forms
• Adding / Editing Records In A Form
• Deleting Records Through A Form
• Deleting An Unwanted Form

WORKING WITH RECORDS

• Navigating To A Specific Record
• Editing A Record
• Deleting Record Data
• Undoing A Change
• Deleting A Record
• Deleting Several Records
• Searching In A Table
• Searching In A Field
• Finding And Replacing
• Printing Records From A Table
• Compacting A Database

SORTING AND FILTERING

• Simple Sorting
• Sorting On Several Fields
• Simple Filtering
• Working With Filters
• Filtering Between Dates

QUERIES

• Understanding Queries
• Creating A Query Design
• Working With A Query
•  Changing A Query Design
• Applying Record Criteria
• Clearing Selection Criteria
• Saving A Query
• Running Queries From The Navigation Pane
• Deleting A Query
• Creating Queries

REPORTS

• Reporting In Access
• Creating A Basic Report
• Working With Existing Reports
• Previewing And Printing A Report
• Changing The Report Layout
• Using The Report Wizard
• Creating A Grouped Report
•  Creating A Statistical Report