Microsoft Access Intermediate (Level 2) 2003 2007 2010
Sponsored links
INTERMEDIATE MICROSOFT ACCESS – from Base2
– 1 day
Upon completion of this course delegates will be able to design, produce and use the individual elements of Microsoft Access.
Attendance of our Introduction to Microsoft Access course is recommended for all attendees of this course.
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
1 Revision
• Topics from the Introduction day
• Revision Exercise
•
2 More about Datasheets
• Finding Information in a Datasheet
• Replacing Information
• Sorting in a Datasheet
• Filtering for Ad-hoc enquiries
3 Relationships between Tables
• The Northwind Sample Database
• Understanding Links
• Multi-Table Queries
• Creating the Relationships
4 Custom Forms
• Starting from Scratch
• Control Properties
• Using List / Combo Boxes
• Check Boxes / Option Buttons
• Calculations on a Form
5 Custom Reports
• Starting from Scratch
• Sorting and Grouping
• The Control Types to be Used
6 Action Queries
• Make Table Queries
• Append Queries
• Delete Queries
• Update Queries
7 Macro Design
• Creating a Macro
• The Macro Design Window
• Saving and Running the Macro
This Training Course is taught in classrooms in the following locations:
Newcastle
Sunderland
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
