Merehall Training Getting People on Course

Microsoft Access 2003 Advanced Level

USING THE NORTHWIND DATABASE

• Installing The Northwind Database

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 & 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