Course Subjects

Contact Us

Need Help

 
Microsoft Access: Intermediate (Level 2)   

This intensive, hands-on one-day training course has been designed to delegates a solid understanding of advanced Access tools and concepts in order to increase their knowledge and productivity in the shortest possible time.

Scheduled Course Dates and Prices

Duration: 1 Day

Public Course Price: £99
1-to-1 price: £199

Scheduled Dates: spacer TBC

If you can't come to us we can come to you! All courses are available as individual 1:1 tuition or small groups at your office as well as at our centre. Please click here for more information.

Who Should Attend  

Proficient users of Microsoft Access 2003 who want to consolidate and expand on their knowledge in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Prerequisites 

Delegates on this course should have a good working knowledge of the topics covered in the Introduction and Intermediate course.

Performance-Based objective  

Course Outline

Customizing Menus and Toolbars:
Customizing Menus 
Creating Menus 
Showing and Hiding Toolbars 
Customizing Toolbars 
Creating Toolbars 

Setting Access Options, Part 1:
Setting General and View Options 
Setting Editing and Keyboard Options 
Setting Datasheet, Form, and Report Options 
Setting Page and Tables/Queries Options 
Setting Error Checking Options 
Setting Advanced Options 

Setting Access Options, Part 2:
Setting International Options 
Setting Spelling Options 
Setting AutoCorrect Options 
Setting Start-Up Options 
Setting Macro Security Options 

Creating Macros:
The Macro Design Toolbar 
Creating a Macro 
Running a Macro 
About Macro Groups 

Advanced Macro Uses:
Editing a Macro With the Visual Basic Editor 
Assigning a Macro to a Keystroke 
Assigning a Macro to a Toolbar 
Viewing and Printing Macro Definitions 

Switchboards:
Using a Switchboard 
The Switchboard Manager 
Creating a Switchboard 
Editing a Switchboard 
Deleting a Switchboard 

Creating Data Access Pages:
The Data Access Page Wizard 
Using Design View to Create a Data Access Page 
Using an Existing HTML Page 

Modifying Data Access Pages:
Adding a Theme 
Adding Text and Controls 
Formatting Text and Controls 
Aligning and Sizing Content 
Adding Images 

Data Access Pages:
Basics of Using Data Access Pages 
Viewing Data Entered Via a Data Access Page 
Protecting Data 

Table Relationships:
Normalizing Your Data 
Establishing Referential Integrity 
Using Cascade Update and Cascade Delete 
Setting Fields for Indexing 
Using Indexing 

CrossTab Queries:
Understanding CrossTab Queries 
Creating a CrossTab Query Using the Wizard 
Creating a CrossTab Query Manually 

Using Parameter Queries:
Setting Up Parameter Queries 
Using a Parameter Query 

Advanced Reporting Features:
Using AutoFormat 
Aligning and Formatting Controls 
Adding Pictures and Lines 

Creating a PivotTable:
Creating a PivotTable Using the Wizard 
Continuing Where the Wizard Left Off 
More About Fields 
Completing Your PivotTable 

Using AutoForm and Creating PivotCharts:
Creating a PivotTable Using AutoForm 
Creating a PivotChart Using AutoForm 
About PivotChart Fields 
Completing A PivotChart 

PivotTables and PivotCharts:
Using a PivotTable 
Using a PivotChart 
Editing a PivotTable or PivotChart 
Common PivotChart Editing Features 
Turning a PivotTable Into a PivotChart and Vice-Versa 

Course Times

Class time is 10:00 a.m.- 4:30/5:00 p.m. Breaks are scheduled throughout the day and lunch is typically scheduled between 1-2 pm. We provide you with Tea, Coffee, Biscuits and other refreshments on the house. We also have a fridge and a microwave available for you to store/warm up any food you wish to bring along for your lunch.

Related Courses

We recommend the following courses that relate to this class: Microsoft Excel Introduction

Back to top

 

Microsoft Excel

PHP & MySQL

Our Location