|
BASIC ACCESS
PARTICIPANTS
Introduction to Microsoft Access 2002 is designed for
those who need a basic introduction to Access 2002 database
management tools.
PREREQUISITES
Students must have completed Introduction to Microsoft
Windows 98 or XP. Those with significant experience using
Access or similar database managers should consider the
Intermediate or Advanced course.
OBJECTIVES
Students will learn the basics of the Access interface.
This introductory course will deal with single-table
examples only. The course teaches students sorting,
filtering, and querying, along with customizing forms and
reports. Specific objectives are listed at the beginning of
each chapter of the workbook. Hands-on exercises test the
students’ mastery of the topics at the end of each chapter.
STRUCTURE
The course is presented through a combination of
instructor-led lectures and hands-on exercises, aided by a
step-by-step workbook and an exercise disk. Sample data
files are provided on the exercise disk so students spend
less time typing and more time learning.
OUTLINE
Introduction to Databases
- Understanding Basic Database Concepts
- Elements of the Relational Database
- The Database Window and its Features
- Field Types and Functions
- Planning a New Database
Getting Started with Access
- Starting Windows and Access
- Features of the Access Application Window
- The Desktop Environment
- Using Menus, Commands, and Dialog Boxes
- Using Toolbars and Buttons
- Exiting Access
Working With Databases and Tables
- Understanding Naming Conventions
- Creating a Database File
- Creating a Table Using the Table Wizard
- Modifying Field Properties
- Creating a Table Manually
Working with Records
- Adding Records to a Table
- Understanding Record Selector Symbols
- Editing and Navigating Fields and Records
- Deleting Records from a Table
- Making a Backup Copy of a Table |
Working
with Forms
- Creating a Form Using AutoForm
- Working in Form View and Design View
- Using the Formatting and Form View Toolbars
- Modifying a Form in Design View
- Adding Graphics and Saving a Form
- Creating a Form Using the Form Wizard
Working with Data
- Finding Data in a Database
- Using Wildcards
- Filtering by Form
- Using Advanced Filtering
- Sorting the Dynaset
- Printing Your Data
Working with Queries
- Understanding Query Types
- Creating Select Queries
- Sorting a Dynaset
- Saving a Query
- Using Comparison Operators
Working with Reports
- Creating a Form Using the Report Wizard
- Customizing and Formatting a Report
- Adding and Formatting Graphics
- Previewing and Printing a Report
Finding and Using Help |
INTERMEDIATE ACCESS
PARTICIPANTS
Intermediate Microsoft Access 2002 is designed for those
who understand the basics of Access 2002 database management
and want to use the program more efficiently and
productively.
PREREQUISITES
Students must have completed Introduction to Microsoft
Access 2002.
OBJECTIVES
Students will learn how to use the Database Wizard and
Lookup functions, use controls on forms and reports, create
relationships among tables, and analyze tables. More
advanced queries, such as relational queries, will be
covered. Students will be shown how to create and use the
highly functional and interactive
Data Access Pages and use Access 2002 in conjunction with
the Internet and intranets. Specific objectives are listed
at the beginning of each chapter of the workbook. Hands-on
exercises test the students’ mastery of the topics at the
end of each chapter.
STRUCTURE
The course is presented through a combination of
instructor-led lectures and hands-on exercises, aided by a
step-by-step workbook and an exercise disk. Sample data
files are provided on the exercise disk so students spend
less time typing and more time learning.
OUTLINE
Working with Databases
- Using the Database Wizard
- Using and Modifying the Main Switchboard
- Examining and Creating Relationships
- Using a Contact Management Database
- Using the Performance Analyzer
Working with Tables
- Setting and Removing Primary Keys
- Indexing Fields
- Setting and Using Input Masks
- Using Default Fields and Required Fields
- Creating and Using Lookup Lists and Fields
Working with Forms
- Understanding Controls
- Creating a Navigational Control
- Creating a Combo Box Control
- Using Grouping to Modify a Form
- Creating Subforms on Forms
- Creating Multiple-Page Forms
- Creating Form Headers and Footers
Working with Queries
- Using Parameter Queries
- Using a Multiple Parameter Query
- Using Functions in Queries
- Using Calculated Fields in Queries
- Creating and Running Relational Queries |
Working
with Action Queries
- Using a Make Table Query
- Using an Update Query
- Using an Append Query
- Using a Delete Query
Working with Reports
- Creating Reports
- Grouping Records in a Report
- Formatting Reports Using AutoFormats
- Creating and Deleting an AutoFormat
- Creating and Using Calculated Controls
- Calculating Totals on Reports
- Creating Mailing Labels Using a Report
- Creating Subreports on Reports
Working with the Internet
- Understanding Internet Terms
- Navigating Using Hyperlinks
- Using Hyperlinks in Tables
- Using Hyperlinks on Forms
- Creating Hyperlinks to Web Sites
- Creating Hyperlinks to Documents
- Creating Web Pages
- Creating Data Access Pages |
ADVANCED ACCESS
PARTICIPANTS
Advanced Microsoft Access 2002 is designed for those who
have considerable experience with Access 2002 and want to
use Access’s advanced features.
PREREQUISITES
Students must have completed Intermediate Microsoft
Access 2002.
OBJECTIVES
Students will learn how to compact and repair databases,
import and link external tables and spreadsheet files,
examine relationships between tables, and create a form
using an AutoLookup query. Students will learn to create
crosstab queries and publish a pivot table and an Access
report as Web pages. Advanced query
techniques will be covered. Specific objectives are listed
at the beginning of each chapter of the workbook. Hands-on
exercises test the students’ mastery of the topics at the
end of each chapter.
STRUCTURE
The course is presented through a combination of
instructor-led lectures and hands-on exercises, aided by a
step-by-step workbook and an exercise disk. Sample data
files are provided on the exercise disk so students spend
less time typing and more time learning.
OUTLINE
Maintaining Databases
- Compacting and Repairing Databases
- Converting Databases to Different Access Formats
- Protecting a Database by Saving it as an MDE File
Importing and Linking to Data
- Importing and Linking to External Data Sources
- Importing Data from External Sources
- Linking to Data in External Sources
- Performing Calculations on Access Tables in
Microsoft Excel
Developing an Application
- Examining Relationships
- Using the Documenter
- Creating a Market Analysis Database Application
- Developing a Master Form
- Organizing with Groups
Developing Forms
- Creating a Customer Survey Form
- Designing a Master Form
- Creating a Query Listing
- Creating a Subform
- Linking the Master Form and Subform
- Modifying Controls on the Master Form |
A Case
Study of Product Sales
- Creating a Query that Lists Products Sold to
Customers
- Creating a Pivot Table
- Converting a Pivot Table to a Web Page
- Creating a Totals Query
- Creating a Totals Report
- Converting a Report to a Web Page
- Creating a CrossTab Query
- Creating a Report with Totals
- Understanding SQL
Developing a Project Using Advanced Access
Features
- Creating a Query Using AutoLookup
- Creating a Customer Form Using SQL Code
- Creating a Macro
- Creating a Command Button that Runs a Macro
- Creating a Totals Query that Counts Orders
- Creating a Macro Using the Expression Builder |
|
