|
|
|
Increasingly, business users require better tools for
finding and managing data. Microsoft Access 2000 can help
organizations meet these demands by focusing on three key
areas. First, Access 2000 simplifies the skill set needed to
create simple, useful databases—the improved interface
offers more consistency with other Office applications, plus
new features that increase productivity. Second, Access 2000
adds Data Access Pages—Web pages that let users interact
with data over the Web and maintain live links to a
database. Finally, Access 2000, through its support of OLE
DB, can act as a front end to high-end database engines such
as Microsoft SQL Server™, making Access 2000 databases more
scalable than ever before. [Part 1]
[Part 2] [Part 3]
|
Prerequisites
A knowledge of personal computer fundamentals,
experience in working within the Microsoft Windows
environment, a reasonable degree of keyboard
proficiency and experience in using a mouse.
Objectives
- After completing this course, students will be able
to:
-
Start Access.
-
Display Help
information.
-
Create a new
database and new table.
-
Enter records
in Datasheet view.
-
Print the
datasheet of a table.
-
Create a form.
-
Enter records
in Form view.
-
Edit records in
Datasheet view and Form view.
-
Use the Find
feature.
-
Delete records
in Datasheet view and Form view.
-
Modify the
Datasheet view of a table.
-
Sort the
records in a table.
-
Create and
apply a filter.
-
Create and run
a query.
-
Modify a query.
-
Create a simple
tabular report.
-
Create a
grouped tabular report.
-
Modify a
report.
-
Use the
Spelling Checker.
-
Copy, rename
and delete database objects.
-
Import
spreadsheet data into an Access table.
Course Materials
The student kit includes a comprehensive workbook and
other necessary materials for this class. [Part 1]
[Part 2] [Part 3]
Top of
Page
|
Prerequisites
Part 1 or equivalent
knowledge.
Objectives
- After completing this course, students will be able
to:
-
Specify a
required field
-
Define a
default field value
-
Add a Memo
field to a table
-
Display
multiple tables on the desktop
-
Resize and
reposition the Table window
-
Create a
relationship between two tables
-
Design and use a subdatasheet
-
Design a custom
form
-
Use a custom form to enter data
-
Extract information from multiple tables
-
Create a report of information in multiple
tables
-
Create a mailing label report
-
Access the World Wide Web from the Access
Application window
-
Link an Access object to a Web page
-
Export an Access object to an HTML file
-
Use a database wizard
-
Compact and repair a database
-
Back up and
restore a database
Course Materials
The student kit includes a comprehensive workbook and
other necessary materials for this class. [Part 1]
[Part 2] [Part 3]
Top of
Page
|
Prerequisites
Part 2 or equivalent
knowledge.
Objectives
- After completing this course, students will be able
to:
-
Validate field
entries
-
Create a Lookup
field
-
Create a
master-detail form
-
Add a picture
to a form
-
Display the
current date on a form
-
Create and
modify a chart
-
Include
multiple conditions in a query
-
Create a
parameter query
-
Create a query
to generate summary information
-
Create an
action query
-
Create a
master-detail report
-
Create a data
access page
-
Add a hyperlink
to a data access page
-
Export an
Access datasheet to Microsoft Excel
-
Create and run
a database macro
-
Create and run
a command button macro
-
Use the Table
Analyzer Wizard and the Performance Analyzer
-
Use the
Database Splitter Wizard and the Linked Table
Manager
-
Set a database
password
-
Create a
many-to-many relationship and a one-to-one
relationship between tables
-
Create a
switchboard
Course Materials
The student kit includes a comprehensive workbook and
other necessary materials for this class. [Part 1]
[Part 2] [Part 3]
Top of
Page |
|
|
