Call us on 01732 870511
“Vue, Dedicated to
Developing Brighter Futures”
Developing Brighter Futures”
Thursday 20th November 2008
Microsoft Access Intermediate
Description
Delegates should have basic keyboard and mouse skills and be familiar with working in the Windows environment. Attendance of the Microsoft Access Introduction course or thorough equivalent experience is essential.
What will you learn?
- To understand relational database concepts and build a relational database
- To ask complex questions of your data
- To utilise Word and Excel when working with data
- To simplify tasks for other users of your database
Course content
Table Design
- What is an Index?
- Relationships explained
Creating a Multiple Table Database
- Setting Relationships
- Enforcing Referential Integrity
More on Queries
- Multiple Table Queries
- Finding Unmatched Records
- Parameter Queries
- Cross Tabulations
- Analysing/Integrating with Excel
- Creating Pivot Tables
Action Queries
- What are Action Queries?
- Update Queries
- Make Table Queries
- Append Queries
- Delete Queries
More on Forms
- Using the Form Wizards
- Main Forms with Sub Forms
- Linked Forms
- Placing Buttons on Forms (see An Introduction to Macros below)
More on Reports
- Grouped Reports
- Detail and Summary Reports
- Publishing a Report with Microsoft Word
- Creating a Mail Merge
- Creating Mailing Labels
An Introduction to Macros
- What is a Macro?
- Creating a simple Macro
- Attaching Macros to Buttons on Forms
Dates for this course
- Friday 17th October 2008
- Monday 1st December 2008
- Monday 19th January 2009
- Monday 16th March 2009
