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 if requested.
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.
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
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.
Review of Access Basics
Creating a new database
Understanding and modifying data types
Setting field properties
Assigning the primary key
Creating parameter queries
Calculating in queries
Using action queries: Make Table / Append / Delete / Update