Microsoft Access 2007 -Intermediate

Course content:

Microsoft Office Access is a relational database management system that enables everyday office-based IT users to interface with the complex Microsoft Jet Database Engine. Microsoft Office Access is extremely versatile and has the ability to link directly to data stored in other applications and databases. Microsoft Access is part of the Microsoft Office suite of software applications and has become one of the leading database software applications in the UK.

The first version of Microsoft Access was released in 1992 and since then several new versions have been released. Aspyra Training currently offers the following versions for the PC:

• Microsoft Access 2003
• Microsoft Access 2007
• Microsoft Access 2010
• Microsoft Access 2013

Microsoft estimates that more than 500 million people worldwide use the Microsoft Office suite every day, this makes it an essential tool for those who want to excel in an increasingly technological society. Participants attending Aspyra’s Microsoft Office training courses will all receive the following training benefits:

• Microsoft Certified Training Courseware
• Certificate of Attendance
• Professional and Qualified Trainers
• Small Class Sizes
• Excellent IT Infrastructure
• Post Course Support
• Buffet Lunch

Microsoft Access for Intermediate Users provides you with a comprehensive review of Microsoft Access 2007 basics and provides learners with details on the progressive features within Microsoft Access 2007. You will learn how to create relationships between tables and create forms and reports to capture, display and analyse data.

Upon completion the delegate will be able to:

• Work with Queries
• Create Calculated Fields
• Change Field Properties
• Create Auto Forms
• Use Form Wizard
• Create Reports
• Modify Reports
• Print Forms and Reports
• Create a Data Access Page