MS Access - Intermediate
Introduction
This one-day instructor led course is designed for existing users of Microsoft Access who need to be able to create databases and manage data more effectively. By the end of the course delegates will be able to design a new database with attractive forms for data entry and functional reports for printed management information.
Course Objectives
- Design a multi table relational database
- Create parameter queries and action queries
- Perform calculations in queries
- Create forms and sub forms
- Incorporate a graphic in a form
- Design reports with calculations
Pre-requisites
This course is designed for delegates who have completed the Access Introduction course or have equivalent knowledge. Delegates should already be familiar with the different Access objects (tables, queries, forms and reports) and should be looking to develop their knowledge of database design and data manipulation.
Course Content
|
Review of Access Basics
|
Form Creation
|
|
|
- Creating forms with subforms
|
|
Database Design
|
- Customising forms
|
|
- Creating a new database
|
- Using the forms control toolbox
|
|
- Understanding and modifying data types
|
|
|
- Setting field properties
|
Report Design
|
|
- Assigning the primary key
|
- Using calculations in reports
|
|
- Creating relationships
|
- Grouping and sorting data
|
|
- Importing data
|
- Creating and formatting labels
|
|
|
- Modifying field properties
|
|
Query Design
|
- Adding a graphic to a report
|
|
- Creating parameter queries
|
|
|
- Calculating in queries
|
|
|
- Using action queries:
Make Table / Append / Delete / Update |
|