Microsoft Access Advanced Level

Training Course Outline:

1). WORKING WITH THE NORTHWIND SAMPLE DATABASE
INSTALLING THE NORTHWIND DATABASE
About Northwind
Checking for Northwind
Installing Northwind

2). INTRODUCING STRUCTURED QUERY LANGUAGE
WRITING SQL COMMANDS
Structured Query Language (SQL) Bases
Understanding SQL Statements
Understanding SQL Conventions
Understanding SQL Syntax
WRITING SQL QUERIES
Using SELECT Statement
Selecting All Data
Selecting Specific Data
Selecting Conditional Data
Using ORDER BY Statement
Sorting Data
Using Aggregate Functions
Calculating Data
Using GROUP BY Statement
Grouping Data
WRITING SQL SUBQUERIES
Creating a Subquery with Equality
Creating a Subquery with an Aggregate Function
Using ANY and ALL Statements
WRITING SQL JOINS
Understanding SQL Joins
Creating a Simple Join
Sorting a Join
Creating Outer Joins
Creating Left Outer Joins
Creating Right Outer Joins
Creating Full Outer Joins

INSERTING DATA
Using INSERT Statement
Understanding INSERT Statement Rules
Inserting Data using VALUES
Inserting Data using Defaults
Inserting Data using SELECT
UPDATING DATA
Using UPDATE Statement
Updating All Rows
Updating Specific Rows
Updating Multiple Columns
DELETING DATA
Using DELETE FROM Statement
Deleting Specific Rows
Deleting All Rows
WRITING SQL QUERIES IN ACCESS
Viewing SQL in Access
Understanding SQL in Access
Writing SQL Specific Queries
Finding Help on SQL Queries

3). WORKING WITH MACROS
AUTOMATING TASKS
Understanding Macros
INTRODUCING THE MACRO WINDOW TOOLBAR
Using the Macro Window Toolbar
CREATING MACROS
Creating New Macros
TESTING AND DEBUGGING MACROS
Running a Macro
Stepping Through a Macro
MODIFYING MACROS
CONDITIONAL PROGRAMMING IN MACROS
Adding Conditions to Macros
Using the Expression Builder to create Conditions
Running Macros with Conditions

ADDING MACROS TO FORMS
Attaching Macros to a Form
ADDING MACROS TO REPORTS
Attaching Macros to a Report
FILTERING DATA
Filtering Records
DOCUMENTING MACROS
Commenting Macros
Printing Macro Definitions
Viewing Macro Definitions

4). PROGRAMMING ACCESS USING VISUAL BASIC
USING MACROS VERSUS VISUAL BASIC
Using Visual Basic Modules
Converting Macros to Visual Basic Code
UNDERSTANDING VISUAL BASIC CONCEPTS
Understanding Modules
Creating Modules
Understanding Module Declarations
Understanding Procedures
Using Naming Rules
Declaring Variables
Setting Variable Scope
Declaring Constants
Using Methods
Using Arguments
USING THE VISUAL BASIC EDITOR WINDOW
Customizing the Visual Basic Editor Window
Setting the Visual Basic Editor Options
GETTING HELP WITH VISUAL BASIC
Using Microsoft Visual Basic Help
Getting Visual Basic Syntax Help

5). USING DATA ACCESS PAGES
CREATING DATA ACCESS PAGES
Using Data Access Pages
Creating pages using the AutoPage
Creating pages using the Page Wizard
Creating pages using an Existing HTML Document
Creating pages using the Design View

MODIFYING DATA ACCESS PAGES
Choosing a Theme
Adding Text
Adding Controls
Formatting Text and Labels
Aligning Content
Sizing Content
Adding Images
Adding Backgrounds
SORTING DATA IN DATA ACCESS PAGES
Sorting Data
SUMMARIZING DATA IN DATA ACCESS PAGES
Summarizing Data
EDITING DATA IN DATA ACCESS PAGES
Adding a New Record
Deleting a Record
PROTECTING DATA IN DATA ACCESS PAGES
Customizing Navigation Bar
Protecting Fields

6). CONVERTING ACCESS DATABASES
CONVERTING DATABASES TO ACCESS
Converting Databases
Converting Database Objects
Enabling Databases
Sharing Databases across various Access versions
CONVERTING FROM ACCESS TO ACCESS 97
Converting an Access database to an Access 97 database
CONVERTING FROM ACCESS TO ACCESS 2000
Converting an Access database to an Access 2000 database

7). CUSTOMIZING ACCESS

CONFIGURING ACCESS OPTIONS
Setting Access Options
Setting View Options
Setting General Options
Setting Edit/Find Options
Setting Keyboard Options
Setting Datasheet Options
Setting Forms/Reports Options
Setting Pages Options
Setting Advanced Options
Setting International Options
Setting Spelling Options
Setting Tables/Queries Options
CONFIGURING AUTOCORRECT OPTIONS
Setting AutoCorrect Options
Excluding AutoCorrect Rules
Removing AutoCorrect Rules
Adding Replace AutoCorrect Rules
Removing Replace AutoCorrect Rules
CUSTOMIZING MENUS AND TOOLBARS
Opening Customize Dialog Box
Customizing Toolbars
Creating Custom Toolbars
Removing Toolbars
Customizing Commands
Adding Buttons to Toolbars
Removing Buttons from Toolbars
Customizing Options

8). ANALYZING ACCESS DATABASES
OPTIMIZING DATABASES WITH TABLE ANALYZER
Using the Table Analyzer
Renaming Tables
Adding Key Fields
OPTIMIZING DATABASES WITH PERFORMANCE ANALYZER
Using the Performance Analyzer
DOCUMENTING DATABASES WITH DOCUMENTER ANALYZER
Using the Documenter Analyzer
Printing Documentation
Exporting Documentation