New Logo
White mail

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.



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



Creating & running a macro

Editing & deleting macros

Assigning a macro to a control


Customising applications

Designing switchboard forms

Changing startup options


Database passwords

Previous knowledge of Access and the design environment is essential.



© 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.