-
PC Essentials -
Accounting/Databases -
Microsoft Access -
Microsoft Excel -
Microsoft Outlook -
Microsoft Office 2007/2010 -
Microsoft PowerPoint -
Microsoft Project -
Microsoft Publisher -
Microsoft SharePoint -
Microsoft Visio -
Microsoft Word -
Adobe Acrobat -
Adobe InDesign -
Adobe Photoshop
Microsoft Access Advanced
1 Day
This course is designed to provide attendees with an understanding of the data analysis and reporting functionality with Access. It will benefit individuals who wish to create queries, build forms reports and macros.
Attendees need to have attended the Access Foundation course or have equivalent knowledge.
TBC
Course Outline
Relationships and Specialist Queries
- Relational database design
- Creating many to many relationships
- Creating a query from related tables
- Inner and outer joins
- Parameter queries
- Summary queries
- Calculated queries
Download
PDF (87kb) 
Print
Course Outline
Enquire
About Course 