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