|
CREATING
DATABASES
|
 top
|
Access 2000 MOUS: Creating Databases shows users how
to plan and create a database in Access 2000.
TOPICS
COVERED
Understanding Relational
Databases
Planning
a Database
Creating a Database
Selecting and Printing Database Objects
|
BUILDING TABLES
|
top
|
Access 2000 MOUS: Building Tables shows users how to
create and populate database tables in Access 2000.
TOPICS
COVERED
Understanding Table Structure
Creating
Tables
Entering Records
|
MODIFYING TABLES |
top
|
Access 2000 MOUS: Modifying Tables shows users how
to edit table data, table structure, and field properties in Access 2000.
TOPICS
COVERED
Modifying Data
Modifying Tables
Modifying Field Properties
Modifying Tables Using the Wizards
|
SORTING AND FILTERING |
top
|
Access 2000 MOUS: Sorting and Filtering shows users
how to find, filter, and sort records in Access 2000.
TOPICS
COVERED
Sorting Records
Using Advanced Sorts
Finding Records
Applying and Removing Filters
|
RELATIONSHIPS AND QUERIES |
top
|
Access 2000 MOUS: Relationships & Queries shows
users how to establish table relationships, perform join operations, and define
and execute queries in Access 2000.
TOPICS
COVERED
Establishing Table Relationships
Managing Table Relationships
Displaying Related Records
Specifying Query Criteria
Creating Calculated Fields
Using Multi-Table Queries
|
BUILDING FORMS |
top
|
Access 2000 MOUS: Building Forms shows users how to
create forms in Access 2000, to change the appearance of reports, and to add
bound and unbound controls to reports.
TOPICS
COVERED
Creating a Form
Working in Form Design View
Using Controls
Using Calculated Controls
|
PRODUCING REPORTS |
top
|
Access 2000 MOUS: Producing Reports shows users how
to create reports with the Report wizard, arrange and organize reports, and add
bound and unbound controls to the report.
TOPICS
COVERED
Creating a Report
Using the Report Wizard
Working with Reports in Design View
Using Controls in Reports
Using Calculated Controls in Reports
|
ADVANCED TASKS |
top
|
Access 2000 MOUS: Advanced Tasks shows users how to
import data into Access databases, create Web hypertext pages based on Access
objects, incorporate hyperlinks into Access objects, and perform administrative
tasks such as backing up the database.
TOPICS
COVERED
Importing Data
Saving Access Objects as Web Pages
Adding Hyperlinks
Performing Administrative Tasks
only £50.00
(approx $88 USD)
|
