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.

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