title>MS Access Advanced Training| Futuretrend Technologies
Dreamweaver course in north London

Microsoft Access: Advanced (Level 3)

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.

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.

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

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