Description
The objective of our Microsoft Access Intermediate training course is for participants to acquire a more in-depth knowledge of Access, including relational databases, complex queries, macros, switchboards and integration with other Microsoft Office applications.
Full Day Course Price: €375 per person
Click here to view the upcoming Virtual Live Training 1.5 hour session schedule.
To book onto a Virtual Live Training 1.5 hour session, or series of sessions, please click here.
Dates
- Dates available on request, please call for details – 1 Day
TARGET AUDIENCE
Our Microsoft Access Intermediate training course is aimed at users who have a good working knowledge of Microsoft Access.
PREREQUISITES
Some knowledge of Microsoft Access would be of benefit. Ideally, participants should also have attended the Access Introduction training programme prior to this.
GOALS AND OBJECTIVES
Having completed this course, participants will have an in-depth knowledge of Access, including relational databases, complex queries, macros, switchboards and integration with other Microsoft Office applications.
Introduction and Review
Objectives
Programme Overview
Database Concepts
Flat vs Relational Databases
Planning and Design
Explore the Ribbon
What’s New in Access 2019
Discover New Features in Access 2019
Using the ‘Tell me what to do…’ function
Advanced Table Design
Field Data Types
Field Properties
Creating Input Masks
Validating and Restricting Data
Setting the Primary Key
Relational Databases
Creating a Relational Model
Different Types of Links
Key Fields and Indexes
Creating One-To-Many Relationships
Referential Integrity
Access Queries
Review Creating Basic Queries
Applying a Query to a Database
Complex Queries
Queries with Multiple Criteria
Sorting the Query Dynaset
Hiding Fields in a Query
Calculated Query
Total Query
Action Queries
Append Query
Make Table Query
Update Query
Delete Query
Other Queries
Creating Queries on Multiple Tables
Parameter Query
Parameter Query with Wildcards
Duplicate / Unmatched Queries
Access Forms
Review Creating Basic Forms
Layout View and Design View
Field Display Types
List Boxes and Combo Boxes
Option Groups
Calculated Controls
Using Expression Builder
Adding a Command Button
Creating Custom Help
Main Forms / Sub-Forms
Tabbed Forms
Access Reports
Review Creating Basic Reports
Modifying Controls in a Report
Grouping and Sorting Records in a Report
Calculations in Reports
Reports on Multiple Tables and Queries
Creating a Main / Sub-Report
Access Templates
Asset tracking
Contacts
Event management
Students
Task Management
Integration with Office Applications
Importing and Exporting Data
Hyperlink Fields
Publish and Merge in Word
Analyse in Excel
Course Summary and Review
Recap of Topics Covered
Question Time