Microsoft Access Intermediate
Training
In Norwich
Description
-
Type
Training
-
Location
Norwich
-
Duration
1 Day
This course is designed to provide delegates with the knowledge and skills needed to handle the intermediate features of Access. In particular, delegates will learn how to work with relational tables and how to manipulate the advanced features of forms, reports and queries. Suitable for: Those with a basic grounding in Access who are keen to learn more
Facilities
Location
Start date
Start date
Reviews
Course programme
Microsoft Access Intermediate
One Day Course
Course Aims:
This course is designed to provide delegates with the knowledge and skills needed to handle the intermediate features of Access.
In particular, delegates will learn how to work with relational tables and how to manipulate the advanced features of forms, reports and queries.
Assumed Knowledge:
Delegates must have a good working knowledge of Access. They must be regular users who have built Access databases. They must be able to create and maintain basic tables, forms, queries and reports. It is an advantage to have attended the Jarrold Training Access Introduction course.
Course Outline:
Course Introduction
· Revision exercise
Advanced Table Design
· Advanced field properties including Input Masks
· Multiple field primary keys
· Multiple field indexes
· Documenting indexes
· Using the Access Documenter
Relational Concepts
· Relational concepts & rules
· Data structure principles
· Types of relationship
· Referential integrity
· Relating tables
Multiple Tables and Forms
· Using a combo box in forms
· Combo box properties
· LookUp fields in tables
· LookUp properties
· Creating forms with subforms
· Editing subforms
· Embedding subforms using drag & drop
Advanced Select Queries
· Working with multiple tables
· Calculations in queries
· Using wildcards & parameters
· Understanding query join types
Advanced Reports
· Working with multiple tables
· Concatenating fields
· Date & time functions
· String functions(
)Follow on course:
Access Advanced
Microsoft Access Intermediate