|
|
|
|
|
|
|
|
|
|
TechnicalAdobeMacromediaMicrosoftQuark
|
|
|
|
|
|
AccessExcelFrontPageInternet ExplorerOutlookPowerPointProjectPublisherVisio ProfessionalVisio StandardVisio TechnicalWindowsWord |
|
|
| |
Access Introduction
|
|
A Tour of the Screen |
|
Windows Elements |
|
Definition of a Database |
|
Database Terminology |
|
The Help Facilities |
| |
Relational Databases
|
|
What is a Relational Database? |
|
The Database Window |
|
Access Database Objects |
|
Database “Design” Concepts |
| |
Creating a Table
|
|
Designing a Table |
|
Working with Tables |
|
Data Sheet View |
|
Setting the Primary Key |
|
Saving the Table |
|
Suggested Naming Conventions |
|
“Relationships” |
| |
Modifying a Table
|
|
Table Design View |
|
Adding New Fields |
|
Field Data Types |
|
Setting Field Properties |
|
Validating Data Entry |
|
Indexes |
|
Printing a Table |
|
Deleting Tables |
| |
Working with Data
|
|
Entering Records |
|
Modifying Records |
|
Moving between Records |
|
Searching |
|
| |
Creating Simple Queries
|
|
Creating a Select Query (QBE) |
|
Sorting |
|
Setting Criteria |
|
Querying Multiple Tables |
|
Calculation Queries |
|
SQL Window |
| |
Creating Forms
|
|
Form Design |
|
AutoForm |
|
Using Form Wizards |
|
Viewing Records |
|
Inputting Records |
|
Editing the Form Design |
|
Setting Form Properties |
|
Displaying Values in Lists |
|
Viewing the Result Set |
| |
Creating Simple Reports
|
|
Using the Report Wizard |
|
Design View |
|
Print Preview Reports |
|
Exporting Reports to Word |
|
Saving Reports |
| |
Importing \ Exporting Data
|
|
Import Filters |
|
Importing from Excel |
|
Exporting to Excel |
| |
Mail Merge
|
|
Creating Mail Merge in Word 2000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
courselevel: |
|
|
courseversion: |
|
|
duration: 2 days
|
price: click here
|
|
|