Power Session Outlines
Microsoft Access 2000
All courses below
are 90 Minute Workouts®. Click a course title for a complete
outline. (Note: Access 97 and 2002 courses are also available.)
Objective:
Learn the fundamentals of Access 2000, including a general introduction to
databases, tables, queries, and reports.
Prerequisite
Skills:
Comfortable with the Windows environment.
Course
Description:
If you're in charge of managing a process that has you scrambling to find
and update information from a variety of places, Access could make your job
easier. In Access, you can create a database to collect a wide range of
information related to a particular subject or purpose, such as planning an
event, managing expenses, or tracking inventory. You can then manage all of the
information from a single file so that you have to update it in only one place.
This course
provides a general overview of how you can use Access to organize, analyze, and
present your data.
Attend this
course if you want to:
- Become
familiar with the Access screen.
- Understand
database terminology.
- Open existing
databases.
- Create a new
database.
- View data in
tables or forms.
- Create a new
table to store data.
- Add, edit, and
save records in a table.
- Use a query to
find specific data.
- Create reports
to present your data a particular way.
Access 2000 Getting Started with Databases and
Tables
Objective:
Learn to create an Access database and design and modify the table
component.
Prerequisite
Skills:
Comfortable with the Windows environment.
Course
Description:
Do you need to learn how to plan a database, determine what information to
include in the database, and decide how that information should be organized? Do
you know what you need to include in your database but aren't sure how to create
it?
Attend this
course if you want to:
- Plan a
database.
- Create a new
database.
- Create a new
table to store your data.
- Add records to
a table.
- Modify, save,
and delete records in a table.
- Open existing
tables.
- Modify and
save tables.
- Use wizards to
create a database or table.
- Use the
switchboard to move to different components of a database.
Access 2000 Making the Most of Tables
Objective:
Learn to create more advanced tables and apply various functions such as
searching, customizing data properties, defining relationships, enforcing
referential integrity, working with subdatasheets, importing, and linking.
Prerequisite
Skills:
Comfortable creating Access databases and simple tables.
(Suggested Course: Access 2000 Getting Started with
Databases and Tables)
Course
Description:
Do you want to manipulate and customize your tables to make them more
effective? Do you want to learn to use more advanced functions such as
searching, customizing data properties, defining relationships, importing, and
linking?
Attend this
course if you want to:
- Create
hyperlink and lookup fields.
- Define data
type properties.
- Create,
define, and modify table relationships.
- Enforce
referential integrity to ensure records in related tables are updated
properly.
- Work with
subdatasheets to view related information in a nested table.
- Import data
into a table.
- Link a table
to another file.
- Search for
records in a table.
Access 2000 Queries I: Creating Select Queries
Objective:
Learn to sort and filter records, create simple queries, modify queries,
create multiple-table queries, and apply simple calculations to queries.
Prerequisite
Skills:
Comfortable creating and working with Access databases and tables.
(Suggested Courses: Access 2000 Getting Started with
Databases and Tables and Access 2000 Making the Most of
Tables)
Course
Description:
Have you created a database, but now want to view, change, or analyze only
certain data within it? Do you want to sort or filter your data to work with it
more effectively? Do you want to select specific data for inclusion in a form or
report?
Attend this
course if you want to:
- Learn about
different types of queries.
- Sort and
filter records in a table.
- Save a filter
as a query.
- Use a wizard
to create a simple query.
- Create a query
using the Design view.
- Print a query.
- Modify and
save a query.
- Set properties
for a query.
- Build multiple
table queries.
- Define
criteria in a query.
- Apply simple
calculations to a query.
Access 2000 Queries II: Creating Total, Crosstab,
Parameter, and Action Queries
Objective:
Learn to create more advanced queries by defining calculations, creating
total queries, defining crosstab queries, creating parameter queries, and
creating different action queries.
Prerequisite
Skills:
Course
Description:
Do you want to learn more advanced methods for filtering your data? Do you
want to learn how Total, Crosstab, Parameter, and Action queries can help you
view, select, and analyze your data at a higher level?
Attend this
course if you want to:
- Understand
advanced queries.
- Build
calculations in a query.
- Use Total
queries to apply calculations to selected data.
- Create a
Crosstab query to summarize data in a compact format.
- Use the
Crosstab Query Wizard to create a Crosstab query.
- Create a
Parameter query to prompt users to enter criteria for selecting records.
- Create an
Action query to change selected data within a table.
Access 2000 Creating Forms
Objective:
Learn to create and modify forms using AutoForm, the Form Wizard, and Design
View.
Prerequisite
Skills:
Course
Description:
Do you want to make a data entry in Access easier? Do you want to learn
about the different types of forms you can create and the different methods for
creating them?
Attend this
course if you want to:
- Understand
forms and form types.
- Understand the
controls you can use to enter data or view information in a form.
- Navigate
through existing forms in Form view, Datasheet view, and Design view.
- Sort and
filter data.
- Add, modify,
delete, and save records.
- Create a form
using AutoForm.
- Create a form
using the Design view.
- Define the
form display size to match the size of your monitor.
- Add fields to
a form.
- Modify forms.
- Work with
control properties and form properties.
- Delete a form.
Objective:
Learn to customize forms by adding basic and advanced controls, enhancing
form controls, creating multi-page forms or adding tabs to a form, adding
pictures, and working with subforms.
Prerequisite
Skills:
Course
Description:
Do you want to make your forms more visually appealing and user friendly? Do
you want to learn to use more advanced form controls and to add tabs, pictures,
and multiple pages to a form?
Attend this
course if you want to:
- Understand and
use the controls from the Toolbox.
- Insert basic
controls.
- Apply
formatting options such as colors, borders, and backgrounds to form
controls.
- Add an image
to a form.
- Create a
multi-page form.
- Add tabs to a
multi-page form.
- Add advanced
and data validation controls.
- Create a
header or footer for a form.
- Add your
company logo or other graphics to the background of the form.
- Modify field
properties.
- Work with
subforms.
Access 2000 Working with Reports
Objective:
Learn the basics of viewing and generating reports using the Report Wizard.
Also learn to modify, enhance, sort, and group report data.
Prerequisite
Skills:
Course
Description:
Do you want to summarize data from your database in a report you can print?
Do you want to learn some of the different ways to view and generate Access
reports and to modify, enhance, and sort the data you capture in a report?
Attend this
course if you want to:
- Understand the
difference between forms and reports.
- View existing
reports using the different views.
- Create reports
using AutoReport or the Report Wizard.
- Save a report
you created.
- Format a
report with AutoFormat.
- Work with a
report in Design view.
- Add dates and
page numbers to a report.
- Add graphics
to a report.
- Print a
report.
- Create mailing
labels.
- Save a report
as a Word document or Excel file.
Objective:
Learn to create a report from the Design view, use subreports, create
calculations, and define multi-column reports. Also learn to create reports
using charts and crosstab reports.
Prerequisite
Skills:
Course
Description:
Do you want to create a more customized report to meet more specific needs?
Do you want to use subreports, create calculations in a report, or group and
sort the information in a report?
Attend this
course if you want to:
- Learn to
create reports using the Design view.
- Bind a report
to a table or query.
- Use the grid
to place, move, align, and resize controls with precision.
- Sort or group
the information in a report to control how it displays.
- Create
subreports and subforms (reports within a report).
- Use
expressions to display a date, page number, or calculation in a report.
- Add a chart to
a report.
- Create a
crosstab report.
- Print a report
on a pre-printed form.
- Print multiple
report columns on a page.
- Expand the
report header to create a title page.
- Add page
breaks to a report.
- Create report
snapshots so that users without Access can view your report.
- Work with
report details.
| 