Microsoft Access
Advanced design
This 2 day course is for existing users of Access who wish to develop their skills further to include advanced table, query, form and report design tools.
Objectives
Tables
Selecting the right data type
Setting field properties
Advanced queries
Setting top values
Parameter queries
Crosstab queries
Action queries
Make table queries
Update queries
Append queries
Delete queries
Find duplicates query wizard
Unmatched query wizard
Advanced form design
Combo boxes
List boxes
Option groups
Dialog form
Command buttons
Advanced report design
Creating group headers
Including calculated controls & running summaries
Grouping data
Page breaks & margins
Macros
Creating & running a macro
Editing & deleting macros
Assigning a macro to a control
Customising applications
Designing switchboard forms
Changing startup options
Security
Database passwords
Previous knowledge of Access and the design environment is essential.
Prerequisities
Content
© PrimeraTraining 2020
Professionally insured through PolicyBee
We are GDPR compliant. For information on how we handle personal data, and your associated rights, please view our Privacy & Data Protection Notice.