Call us on 01732 897511
01732 897511
Thursday 9th September 2010
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
Please contact the team for dates of this course
