WHAT IS THE AIM OF THE COURSE?
Access Training - Level 1
This course is for the new user of Access and assumes no experience with relational databases. The topics cover creating databases in Access and working with the data by using tables, queries, forms, and reports.
Access Training - Level 2
Students will learn how to use complex query techniques, create efficient forms and reports, and create macros to automate their forms.
Access Training - Level 3
In this course, student will extend their Access skills to create and implement switchboard forms, develop data access pages that include advanced controls, protect that information using security protocols, and make the data more accessible and portable.
WHO WILL BENEFIT?
This course is designed for students who wish to learn the operations of the Microsoft Access Database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes.
WHAT ARE THE TRAINING OPTIONS AVAILABLE?
- You can come to us for Instructor Led Training,
- You could even do it Part Time with MyChoice!
- We can come to you for Onsite Training
- Distance Learning with Online ANYTIME
- Day or evening training provided
EXAMINATIONS AND ASSESSMENTS
This interesting and informative Excel training course and certification is supported by a range of reinforcement tools, all aimed at assisting in remembering course material with ease, and helping learners integrate their new skills into their daily working lives.
Learners have the option of writing the International Microsoft examinations at New Horizons' Authorised Prometric Testing Centre. However, the costs for international exams are not included in the course fees.
LEARNING MATERIALS
All standard learning materials(like manuals) are included in the course fee!
WHAT DOES THE COURSE CONSIST OF?
MICROSOFT Access 2010
Access 2010 - Level 1
- Getting Started with Access 2010
- Building The Structure of a Database
- Managing Data in a Table
- Querying a Database
- Designing Forms
- Generating Reports
- Controlling Data Entry
- Joining Tables
- Creating Flexible Queries
- Improving Forms
- Customizing Reports
- Sharing Data Across Applications
Access 2010 - Level 2
- Structuring Existing Data
- Writing Advanced Queries
- Simplifying Tasks with Macros
- Creating Effective Reports
- Maintaining an Access Database
MICROSOFT Access 2007
Access 2007 - Level 1
- Exploring the Microsoft® Office Access™ 2007 Environment
- Designing a Database
- Building a Database
- Managing Data in a Table
- Querying a Database
- Designing Forms
- Generating Reports
- Controlling Data Entry
- Joining Tables
- Creating Flexible Queries
- Improving Forms
- Customizing Reports
- Sharing Data Across Applications
Access 2007 - Level 2
- Structuring Existing Data
- Writing Advanced Queries
- Simplifying Tasks with Macros
- Making Effective Use of Forms
- Making Reports More Effective
- Maintaining an Access Database
Access 2007 - Level 3
- Integrating Access into Your Business
- Automating a Business Process with VBA
- Managing Switchboards
- Distributing and Securing Databases
- Sharing a Database Using a SharePoint Site
|