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.
Delegates on this course should have a good working knowledge of the topics covered in the Introduction and Intermediate course..
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
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.
Course Duration |
1 Day |
Private Course Price and dates |
This course is only available as individual 1:1 on a bespoke
Please call centre on 0208 443 2888 for a quote and to arrange dates |
Course Times |
10:00 till 16:00 |