Access Overview

Who should attend: Those people who are new to Access and who require an overview of this database application.
Please note that bespoke courses may be created using topics of the client's choice, free of charge.


Topics Include

Day 1


Introduction to Access
- database concepts, uses & benefits
- understanding terminology
Opening a Database
Screen Layout
- understanding the Ribbon
Using a Sample Database
- displaying data in a table
- using a form to view data
- selecting data from the database using a query
Creating a New Table in a Database
- defining fields
- setting field properties
- understanding keys and indexes
Modifying the Structure of a Table
- inserting a new field
Working in Datasheet View
- finding & replacing data
Creating Forms
- using the Form tool
- applying a Theme
Using the Form Wizard
- modifying the form layout
- adding objects to the form
Filtering Data in a Form
Setting Conditional Formats in a Form
Querying the Database
- understanding the QBE grid
Creating Select Queries
- entering criteria expressions
- using Parameters in queries
- applying a total row

Day 2

Creating Update Queries
- updating groups of rows
- updating multiple fields
Creating a New Table
- using a Make Table query
Creating Append Queries
- inserting data from another table
Creating Delete Queries
- deleting groups of rows
- deleting inactive data
Report Writing
Using the Report Tool
Using the Report Wizard
- grouping data in a report
- summarising data in a report
Modifying a Report
- understanding sections
- sorting data within a report
Linking Multiple Tables
Understanding Referential Integrity
- one to one relationships
- one to many relationships
Adding Tables to the Relationship Window
Creating Relationships
- linking fields
Using a Query to Display Linked Records
Handling Multiple Tables in a Form
- what are Subforms?
Using the Form Wizard to Create a Main/Subform
- specifying the Main table
- specifying the Subform table
- adding a total row to the subform
- filtering the subform