Access Advanced 2010
Instructor-led Microsoft Access Advanced course outline
Duration: |
Intended audience: |
1 day |
Anyone who is comfortable and familiar with using Access at intermediate level and wants to expand their knowledge |
Aims: |
To enlarge on an Intermediate level of Microsoft Access knowledge by the use of worked examples |
Objectives: |
By the end of the session delegates will be able to:·
|
Prerequisites: |
A good knowledge of Access at Intermediate Level |
This Microsoft Access Advanced Tutorial is intended to build upon the knowledge gained in the Access Intermediate course by adding additional expertise. The delegate will complete exercises designed to include creating more complex joins, running reports on multiple tables, adding summary and calculated fields and recording macros. Building advanced user forms is also included in this course, and this will include sub-forms where necessary.
Review of Basic Skills
Database design objectives
Creating a relation model
Creating tables
Forms
Creating a linked form
Calculated fields in forms
Expression builder
List boxes and combo boxes
Option fields & groups
Buttons
Check boxes
Querying the Database
Using different table join-types
Action queries
Find duplicate
Find unmatched
Reports
Multiple table reports
Controlling Grouped reports
Calculated fields
Summary fields
Macros
Using command button wizard
Using a macro to open a form
Microsoft Access Advanced Courses
We have versions for Microsoft Office 2007, Microsoft Office 2010 and Microsoft Office 2013