Microsoft Access Intermediate

Delegates should have first undertaken the corresponding Introduction course and should be familiar with the prerequisites of that course. On completion of the course, delegates should feel confident in their ability to create and edit databases, design and use forms, perform queries and produce reports.

Wireless Computer Accessories
Microsoft-logo-trans.png

Session Topics

 

Tables 
Tables refresher 
Importing/Exporting data 
Relationships & referential integrity 
Primary & foreign keys

 

Queries
Queries refresher 
Multi-table queries 
Action queries 
Group by queries 
Modifying query output 
Using calculations & expressions

 

Reports
Using reports wizard
Tailoring design of reports Basing reports on a query Mailing labels

 

Forms
Using form wizard Tailoring design of forms Controls 
Object properties Changing tab order 
Sub forms