Microsoft Access Advanced

This course is designed to give existing Access users additional skills on using the many features and functions of the software.

Format: Format: One Day: Max Capacity 6

Wireless Computer Accessories
Microsoft-logo-trans.png

Session Topics

 

Review of Access Database Principles
 

Performance & Database Design
• Designing a relational database
• Normalisation of data
• Primary and Secondary keys

 

Queries
• Calculating in queries
• Summary queries

 

Forms
• Advanced form features
• Forms and subforms
• Calculated fields
• Command buttons
• Bound and unbound controls


Reports
• Grouping data in reports
• Creating calculations


Macros
• Creating macros
• Adding macros to command buttons
• Event driven macros
• Attaching macros to a form or report event

 

Custom Ribbon Forms
• Creating custom menus
• Changing database menu settings

 

Creating a Menu Form
• Menu form properties
• Setting Start-up Defaults