ACCESS

 

Information on Microsoft Computer Training Courses in South Africa for MS Access

 

MS Access

Training Course Outline:  ACCESS Basic XP 2002

1). INTRODUCTION TO MICROSOFT ACCESS 2002

WHAT IS ACCESS?>
Access 2002
Content
Delivery

CREATING FILES
About Access 2002 Files
Creating a new database file

OPENING AND CLOSING A DATABASE FILE
Opening a database file
Closing a database file

ACCESS 2002 INTERFACE

ACCESS 2002 WORKSPACE
Using the Menu bar
Using the Database toolbar
Using the Task Pane
Using the Status bar
Using the Office Assistant
Customizing the toolbars

2). THE DATABASE TOOLBAR

USING THE DATABASE TOOLBAR
Using the New button
Using the Open button
Using the Save button
Using the Search button
Using the Print button
Using the Print Preview button
Using the Spelling button
Using the Cut button
Using the Copy button
Using the Paste button
Using the Undo button
Using the OfficeLinks button
Using the Analyze button
Using the Code button
Using the Microsoft Script Editor button
Using the Properties button
Using the Relationships button
Using the New Object: <Object Type> button
Using the Microsoft Access Help button

3). THE TASK PANE

USING THE OPEN A FILE AREA OF THE NEW FILE TASK PANE
Opening the New File task pane
Viewing and opening recent files

USING THE NEW AREA OF THE NEW FILE TASK PANE
Using the Blank Database option
Using the Blank Data Access Page option
Using the Project (Existing Data) option
Using the Project (New Data) option

USING THE NEW FROM EXISTING FILE AREA OF THE NEW FILE TASK PANE
Using the Choose File option

USING THE NEW FROM TEMPLATE AREA OF THE NEW FILE TASK PANE
Using the General Templates option
Using the Templates On Microsoft.com option

USING THE CLIPBOARD TASK PANE
About the Office Clipboard feature
Opening the Clipboard task pane
Using the Office Clipboard feature

USING THE SEARCH TASK PANES
About the Search feature
Opening the Search task pane
Using the Search feature

4). THE DATABASE WINDOW

THE DATABASE MENU BAR
Using the Database Menu Bar
Using the Open button
Using the Design button
Using the New button
Using the Delete button
Using the Icon buttons
Using the List button
Using the Details button

THE DATABASE WINDOW TOOLBAR
About the Groups feature
Using Groups in the Toolbar
Using the Favorites button
Using the Tables button
Using the Queries button
Using the Forms button
Using the Reports button
Using the Pages button
Using the Macros button
Using the Modules button

5). TABLES

CREATE A TABLE
About creating a table in Design view
Creating a Table in Design View
About using the Table Wizard to create a table
Using the Table Wizard to create a table

WORKING WITH TABLES
About changing a table design
Changing a table design
Adding records
Finding Records
Editing records
About filtering records
Filtering records
About sorting records
Sorting records

6). QUERIES

CREATE A QUERY
About queries
About creating a new query in Design view
Requirements for a query in Design view
Creating a new query in Design view
About creating a new query using a wizard
Creating a numerical query using the wizard
Creating a non-numerical query using the wizard
Saving queries
Opening an existing query's result window
Open an existing query in Design view
Refining the results of a query
About adding calculations to a query in Design view
Adding calculations in Design view

7). FORMS

USING AND CREATING FORMS
Using Forms
Creating forms with the wizard
Creating a simple form from scratch in Design view
Modifying a form in Design view
Using a form to locate information
Using a form to organize information effectively

DISPLAYING AND LINKING IMAGES
About inserting images
Inserting the same background image for all records
Inserting an image that does not change from record to record
Inserting an image that is particular just to one record
Replacing an image

8). REPORTS

CREATING AND USING REPORTS
Using Reports
Creating a report using AutoReport
Creating a report using a wizard
Creating a report from scratch in Design view
About totals or averages in a report
Creating a report with totals or averages

SAVING, MAINTAINING, AND PRINTING REPORTS
Saving a report
Setting report properties
Previewing a report (before you print it)
Printing a report

Training Course Outline: ACCESS 2002 XP INTERMEDIATE

1). WORKING WITH THE NORTHWIND SAMPLE DATABASE

INSTALLING THE NORTHWIND DATABASE
About Northwind
Checking for Northwind
Installing Northwind

2). DESIGNING TABLES IN ACCESS 2002

NORMALIZING DATA
Setting a Primary Key
Removing Non-related Data
Removing Redundant Data
Removing Repeating Data
Setting Required Values in Columns

ESTABLISHING RELATIONSHIPS
Using the Relationship Tool
Identifying a Related Table
Creating Join Types
Enforcing Referential Integrity
Working with Cascading Updates and Deletes

WORKING WITH INDEXES
Creating a Single-Field Index
Creating a Multiple-Field Index
Setting the Index Sort Order
Setting Index Properties
Deleting Indexes

WORKING WITH DATA TYPES
Choosing Appropriate Data Types
Setting Column Data Types
Formatting Data Types
Converting Between Data Types

3). DESIGNING QUERIES IN ACCESS 2002

CREATING ACTION QUERIES
Creating Update Queries
Creating Delete Queries
Creating Append Queries
Creating Make-Table Queries

CREATING PARAMETER QUERIES
Creating a One-Parameter Query
Creating a Two-Parameter Query
Using Wildcards as Parameters

CREATING CALCULATED COLUMNS IN QUERIES
Creating Calculated Fields
Using Common Functions in Calculated Fields

JOINING TABLES
Creating a Two-Table Join
Adding Fields from Different Tables to the Query Grid
Removing Tables from the Query Builder

4). DESIGNING FORMS IN ACCESS 2002

CREATING DATA ENTRY FORMS
About Forms
Choosing an Appropriate Control
Placing Controls on a Form
Moving a Control
Resizing a Control
Setting Control Properties
Creating Page Headers and Footers
Creating Form Headers and Footers
Setting Form Properties
Working with Identifiers

WORKING WITH SUBFORMS
Creating a Subform
Creating a Form with Two Subforms
Creating Nested Subforms
Deleting a Subform

CREATING POP-UP FORMS
Creating a Modal Pop-up Form
Creating a Modeless Pop-up Form

WORKING WITH SWITCHBOARDS
Creating a Switchboard
Editing a Switchboard Item
Deleting a Switchboard

5). DESIGNING REPORTS IN ACCESS 2002

WORKING WITH STANDARD REPORTS
About Reports
Placing Controls on a Report
Moving a Control
Resizing a Control
Setting Control Properties
Creating Page Headers and Footers
Creating Report Headers and Footers
Sorting Records on a Report
Grouping Records on a Report
Setting Report Properties

WORKING WITH POP-UP REPORTS
Creating a Modal Pop-up Report
Creating a Modeless Pop-up Report

WORKING WITH SUBREPORTS
Creating a Subreport
Creating a Report with Two Subreports
Deleting a Subreport

WORKING WITH REPORT SNAPSHOTS
Creating Report Snapshots
Distributing Report Snapshots

DEVELOPING DATA ACCESS PAGES
Using the New Data Access Page Wizard
Defining a Data Source for a Stand-Alone Data Access Page
Creating Stand-Alone Data Access Pages

6). WORKING WITH PIVOTTABLES AND PIVOTCHARTS

CREATING PIVOTTABLES AND PIVOTCHARTS
Creating PivotTables
Creating PivotCharts
Selecting Elements of a PivotTable
Selecting Elements of a PivotChart

CREATING PIVOTTABLE FORMS
Using the PivotTable AutoForm Wizard
Deleting Items from a PivotTable
Filtering Items in the PivotTable List
Using the AutoCalc Feature
Displaying Subtotals

CREATING PIVOTCHART FORMS
Using the PivotChart AutoForm Wizard
Deleting Items from a PivotChart
Filtering Items in the PivotChart List
Changing PivotChart Types

7). IMPORTING AND EXPORTING

LINKING TO EXTERNAL DATA SOURCES
Linking to Text Files
Linking to Microsoft Excel Spreadsheets
Linking to HTML Files
Linking to Other Access Databases
Linking to a SQL Server ODBC Data Source

IMPORTING DATA INTO ACCESS
Importing from Excel Files
Importing from Other Access Databases
Importing from ODBC Data Sources

EXPORTING DATA FROM ACCESS
Exporting to Files
Exporting to Access Databases
Exporting to ODBC Data Sources

8). BUILDING EXPRESSIONS

USING THE EXPRESSION BUILDER
Using the Expression Builder in Queries
Using the Expression Builder in Forms
Using the Expression Builder in Reports

USING COMMON BUILT-IN FUNCTIONS
Using Date/Time Functions
Using Financial Functions
Using Math Functions
Using Text Functions

Training Course Outline:  ACCESS 2003 XP ADVANCED

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 2002
Viewing SQL in Access 2002
Understanding SQL in Access 2002
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 2002
Converting Databases
Converting Database Objects
Enabling Databases
Sharing Databases across various Access versions

CONVERTING FROM ACCESS 2002 TO ACCESS 97
Converting an Access 2002 database to an Access 97 database
CONVERTING FROM ACCESS 2002 TO ACCESS 2000
Converting an Access 2002 database to an Access 2000 database

7). CUSTOMIZING ACCESS 2002

CONFIGURING ACCESS 2002 OPTIONS
Setting Access 2002 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

 
 
Home Training Courses MS Specialist MS Training Companies Links Contact