On-line training course catalogue
Access 2007 – Microsoft Certified Application Specialist in a Box
Type of course: Classroom
| Fee | £395 |
|---|---|
| Days | 2 |
| Course code | MSACMCAS |
We currently do not have public dates scheduled for this course.
If you have a requirement for this course, please contact us for the latest course information.
Print this page | Download as Word document |
Overview
This certification course provides a complete training solution to fully prepare students to achieve MCAS Accreditation
Included are
- 2-days Instructor Led Training using MCAS Official Courseware
- MCAS Practice Exam Voucher
- MCAS Exam Voucher + FREE Retake
- MCAS A4 Pad
- MCAS Pen
- MCAS Mouse Mat
- Branded MCAS Carry Case
Prerequisities
Delegates should have a good working knowledge of Microsoft Office Access 2007 before taking this certification course.
Course outline
During the 2 day course you will cover the following topics to prepare you for exam 77-605 Using Microsoft Office Access 2007
Structuring a Database
- Define data needs and types
- Define and print table relationships
- Add, set, change, or remove primary keys
- Split databases
Creating and Formatting Database Elements
- Create databases
- Create tables
- Modify tables
- Create fields and modify field properties
- Create forms
- Create reports
- Modify the design of reports and forms
Entering and Modifying Data
- Enter, edit, and delete records
- Navigate among records
- Find and replace data
- Attach documents to and detach from records
- Import data
Creating and modifying queries
- Create queries
- Modify queries
Presenting and Sharing Data
- Sort data
- Filter data
- Create and modify charts
- Export data
- Save database objects as other file types
- Print database objects
Managing and Maintaining Databases
- Perform routine database operations
- Manage Databases
During the course, you will have the opportunity to test your knowledge and complete a full practice exam before taking the final exam at the end of day 2.
Link to this page: http://www.xpertise.co.uk/MSACMCAS
Xpertise – Access 2007 – Microsoft Certified Application Specialist in a Box training courses
Xpertise provides Access 2007 – Microsoft Certified Application Specialist in a Box training courses from 22 UK locations: in Aberdeen Scotland, Altrincham Manchester, Birmingham West Midlands, Bristol South West, Edinburgh Scotland, Glasgow Scotland, Hinckley East Midlands, Leeds Yorkshire, Leeds Yorkshire (Ring Road), London King William Street, London Middlesex Street, London Rosebery Avenue, London Tabernacle Street, Maidenhead Berkshire, Malmesbury Wiltshire, Manchester (Exchange Quay), Milton Keynes Buckinghamshire, Newcastle Tyne and Wear, Reading Berkshire, Stockport Manchester, Swindon Wiltshire and Washington Tyne and Wear – and at 44 partner locations nationwide.
Xpertise Training reserves the right to improve the specification and format of its courses for the benefit of its customers without notice to the customer.