Objectives
After completing the course, participants will be able
to:
-
Define
a default field value
-
Specify
and define field information
-
Resize
& reposition the Table window
-
Work
with multiple tables
-
Design
and use a custom form
-
Extract
information from tables
-
Create
different types of reports
-
Access
the Word Wide Web
-
Export
an Access object to HTML file
-
Back
up and Restore a database
What you will learn
Topics covered by this course include:
Modifying the Design of a Table
-
Displaying in
Design View
-
Specifying a
Required Field
-
Defining a
Default Field Value
-
Adding a Memo
Field
Working with Multiple Tables
- Displaying multiple Tables
- Resizing & Repositioning the Table Window
Relating Tables
- Creating a Relationship between two Tables
- Creating a Report of Database Relationships
|
Creating a Custom Form
- Designing a Custom Form
- Using a Custom Form to Enter Data
Intermediate Query Techniques
- Extracting Information from Multiple Tables
Intermediate Report Techniques
- Adding a Calculated control
- Creating a Report of Information in Multiple
Tables
- Adding a Cover Sheet to a Report
- Creating a Mailing Label Report
Using Access Internet Features
- Accessing the World Wide Web
- Linking an Access Object to a Web Page
- Exporting an Access Object to an HTML File
Additional Intermediate Access Features
- Using a Database Wizard
- Compacting and Repairing a Database
- Back Up and Restoring a Database
- Using the Office Clipboard
|
Access
2000