Access Introduction:
Create a database, create tables and understand data types, create queries and reports.
Course Outline
Access Introduction 2 Days
Who is it for?
The course is suitable for those with little or no prior knowledge of Microsoft Access and focuses on the basics of creating databases including tables, forms, queries and reports with a basic introduction to relationships.
Prerequisites
Delegates should have a basic knowledge of computers. The course is aimed at delegates who are new to Access.
- Database Concepts
- A first look at Microsoft Access:
- Access Terminology
- Design Concepts
- Understanding Table Relationships
- Tables & Relationships
- Create Tables:
- Enter & Edit Data
- Table Relationships
- Sorting and Filtering Data
- Queries
- Query a database:
- Select Queries
- Query Criteria
- Calculated Fields
- Parameter Queries
- Forms & Reports
- Create user friendly forms & Reports:
- Design Concepts
- Altering the appearance
- Printing