ACCESS INTERMEDIATE COURSE

More Tables, Import/Export, Queries, Forms, Reports, Applications


Designing Tables 
* General Table Design 
* Field Properties 
* Using Field Properties for Protection 
* Using Field Properties to Improve Performance 
* Table Relationships 
* Relationship Types 
* Using Lookups for Referential Integrity 

Queries
* Simple Query Syntax 
* Viewing The SQL Syntax of a Query 
* Joins; Calculated Fields 
* Adding a Calculated Field to a Query 
* Calculating Summary Information 
* Crosstab Queries 
* General Query Properties 
* Checking Referential Integrity 

Data Import/Export 
* Importing Data from Another Data Source 
* To Import an Object from Another Access Database 
* Linking To an External Data Source

Forms 
* What Is a Form?
* Using Form Wizards as the Basis for Form Design

Form Sections
* Form Controls
* Form Control Layout
* Using Form Controls
* Control Properties
* An Introduction to Multiple Table Forms

Reports
* Using Report Wizards as the Basis for Reports
* Report Sections
* Report Controls
* Report Control Layout
* Using Specific Controls
* Links with Other Office 

Applications
* Databases, Intranets and the Internet
* Hyperlinks
* Publishing Datasheet Views On The Internet
* Publishing On The Internet - Data Access Pages

[Home]