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 2002
Access 2002 - Level 1
- Working with a Relational Database
- Planning a Database
- Working with Tables
- Building the Basic Structure
- Working with Tables
- Creating and Working with Select Queries
- Creating and Using Forms
- Creating and Using Reports
- Managing a Database and Data
- Controlling Data Entry
- Finding and Joining Data
- Creating Flexible Queries
- Improving Your Forms
- Customizing Your Reports
- Making Your Data Available on the Web
Access 2002 - Level 2
- Structuring Existing Data
- Summarizing Data
- Simplifying Tasks with Macros
- Adding Interaction and Automation with Macros
- Making Forms More Usable
- Making Reports More Powerful
- Expanding the Reach of Your Data
Access 2002 - Level 3
- Creating a Switchboard and Setting the Startup Options
- Developing a Data Access Page and Including a PivotTable and PivotChart
- Distributing and Securing the Database
- Integrating Access into Your Business
- Automating a Business Process with VBA
MICROSOFT Access 2003
Access 2003 - Level 1
- An Overview of Microsoft Access
- Managing Data
- Establishing Table Relationships
- Querying the Database
- Designing Forms
- Producing Reports
- Planning a Database
- Building the Structure of a Database
- Controlling Data Entry
- Finding and Joining Data
- Creating Flexible Queries
- Improving Your Forms
- Customizing Your Reports
- Expanding the Reach of Your Data
Access 2003 - Level 2
- Structuring Existing Data
- Writing Advanced Queries
- Simplifying Tasks with Macros
- Adding Interaction and Automation with Macros
- Making Forms more Effective
- Making Reports More Effective
- Maintaining an Access Database
Access 2003 - Level 3
- Making Your Data Available on the Web
- Developing a Data Access Page in Design View
- Integrating Access into Your Business
- Automating a Business Process with VBA
- Creating a Switchboard and Setting the Startup Options
- Distributing and Securing the 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
|