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 calculating totals |
· Creating a Switchboard |
| · Crosstab Queries |
|
| · Action Queries |
Import |
|
· Data from Access, Excel or Text Files |
| Advanced Forms |
· Import or Link to an ODBC Database |
| · Form Controls |
· Import or Link to Outlook Folder |
| · Form Buttons |
· Save Imports |
| · Multi-Table Forms |
|
|
Export |
| Advanced Reports |
· Export to Excel, Word, PDF or XPS |
| · Report Bands |
· Snapshots |
| · Report Controls |
|
| · Grouping Data |
Collect Data with Outlook 2007 |
| · Adding Sub Reports |
· When to use Data Collection |
| · Using Functions in Reports |
· Create Email using the Wizard |
|
· Manage Replies |
| Graphing |
|
| · Creating Graphs |
|
| · Embedding Graphs |
|
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: