 |
|
|
|
|
|
|
|
|
|
|
|
|
 |
|
|||||||||||
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
||
 |
 |
 |
|
|||||||||
Students will use advanced capabilities of Access to work with improperly structured data, perform summary operations on data, create macros to automate tasks, enhance forms and reports, and use Access data in other Office applications.
Students will learn advanced Access 2002 skills, including how to structure existing data, summarise data, simplify tasks with macros, add interaction and automation with macros, make forms more usable, make reports more powerful, and expand the reach of data beyond Access.
Prerequisites:
Access 2002 Introduction and Access 2002 Intermediate, or equivalent knowledge.
Unit 1 : Structuring Existing Data
Use the Table Analyser Wizard for Help
Decide on Your Own Design
Create a Junction Table
Modify the Original Tables and Completing the Design
Compact and Repair a Database
Unit 2 : Summarising Data
Group and Summarise Records in Different Ways
Summarise with a Crosstab Query
Pivot Query Results
Display a Graphical Summary on a Form
Unit 3 : Simplifying Tasks with Macros
Create a Macro
Attach a Macro to a Command Button
Restrict Records
Unit 4 : Adding Interaction and Automation with Macros
Require Data Entry with a Macro
Display a Message Box with a Macro
Automate Data Entry
Unit 5 : Making Forms More Usable
Change the Display of Data Under Certain Conditions
Display a Calendar on a Form
Organise Information with Tab Pages
Unit 6 : Making Reports More Powerful
Cancel Printing of a Blank Report
Include a Chart
Arrange Data in Columns
Distribute Reports as a Snapshot
Unit 7 : Expanding the Reach of Your Data
Merge Access Data with a Word Document
Publish Access Data as a Word Document
Analyse Access Data in Excel
Unit 8 : Accessing Object Names