Microsoft Access Intermediate
Intermediate Microsoft Access Training Course Information
1 Day Access Intermediate Course | 1 delegate £225.00 plus VAT
*Book 2 or more delegates and receive significant discounts. Click here for information
Scheduled public courses are held at Preston, Liverpool, Manchester & London.
Closed tailored courses are available on your site for £645.00 plus vat (up to 8 attendees).
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
his 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
Database Design
- Creating a new database
- Understanding and modifying data types
- Setting field properties
- Assigning the primary key
- Creating relationships
- Importing data
Query Design
- Creating parameter queries
- Calculating in queries
- Using action queries: Make Table / Append / Delete / Update
Form Creation
- Creating forms with subforms
- Customising forms
- Using the forms control toolbox
Report Design
- Using calculations in reports
- Grouping and sorting data
- Creating and formatting labels
- Modifying field properties
- Adding a graphic to a report