Contents:
| Planning Access Applications |
Object linking and embedding |
| · System Analysis |
· Understanding OLE Objects |
| · The Database Design |
· Embedding OLE Objects |
| · System Updates |
· Bound and Unbound Objects |
|
|
| Advanced Queries |
Switchboards and Dialogue Boxes |
| · Calculations in Queries |
· Creating Pop-up Forms and Dialog Boxes |
| · Specifying Criteria in Formula Fields |
· Creating a Switchboard |
| · Crosstab Queries |
|
| · Action Queries |
Custom Toolbars |
|
· Creating |
| Advanced Forms |
· Modifying |
| · Form Controls and Buttons |
· Attaching to Forms |
| · Multi-Table Forms |
|
| · Sub Forms |
Custom Menus |
|
· Create Custom Menus |
| Advanced Reports |
· Add Macros to Menus |
| · Report Bands |
|
| · Report Controls |
Administration and Security |
| · Grouping Data |
· Security Overview |
| · Adding Sub Reports |
· Networking |
| · Using Functions in Reports |
· Record Locking |
|
· Assign Permissions |
| Charts |
· Apply Password Security |
| · Selecting the Chart Data |
|
| · Insert Charts to Forms and Reports |
|
| · Changing a Charts Properties |
|
Target Audience: Individuals with an intermediate knowledge of database design who wish to build and administrate sophisticated database applications.
Assumed Knowledge: Access Essentials and Access Specifics.
Duration:
1 Day - Click here to see our course calendar.
Suggested follow-up course: