Access 2003 Advanced
Course
In London
Description
-
Type
Course
-
Location
London
-
Duration
2 Days
The aim of this course is to increase delegates understanding of the advanced features available in Microsoft Access 2003. By the end of the course delegates will be able use structured querying language, automate procedures using macros, customise databases and understand the basic concepts of VBA. Suitable for: current users of Microsoft Access
Facilities
Location
Start date
Start date
About this course
Delegates must have good knowledge of Access and experience of creating databases through either attending the Access Intermediate Course or experience in the workplace.
Reviews
Course programme
Core Topics
Structured Query Language
· Writing SQL Commands
· Writing SQL Queries
· Writing SQL Subqueries
· Writing SQL Joins
· Inserting Data
· Updating Data
· Deleting Data
· Writing SQL Queries In Access 2003
Working with Macros
· Automating Tasks
· Introducing The Macro Design Toolbar
· Creating Macros
· Testing And Debugging Macros
· Modifying Macros
· Conditional Programming In Macros
· Adding Macros To Forms
· Adding Macros To Reports
· Filtering Data
· Documenting Macros
Using Visual Basic
· Using Macros Versus Visual Basic
· Understanding Visual Basic Concepts
· Using The Visual Basic Editor Window
· Getting Help With Visual Basic
Using Data Access Pages
· Creating Data Access Pages
· Modifying Data Access Pages
· Sorting Data In Data Access Pages
· Summarising Data In Data Access Pages
· Editing Data In Data Access Pages
· Protecting Data In Data Access Pages
Converting Access Databases
· Converting Databases To Access 2003
· Converting From Access 2003 To Access 97
· Converting From Access 2003 To Access 2000
Customising Access 2003
· Configuring Access 2003 Options
· Configuring Autocorrect Options
· Customising Menus And Toolbars
Managing and Maintaining Databases
· Optimising Databases With Table Analyzer
· Optimising Databases With Performance Analyzer
· Documenting Databases With Documenter Analyzer
· Avoiding Errors With The Object Dependencies Task Pane
Access 2003 Advanced