|
|
|
Microsoft Office Access Advanced Level |
Microsoft Access Course Contents
Microsoft Office Access Advanced Level
Structuring Existing Data
Decide on Your Own Design i.e. one-to-many relationships
Create a Junction Table: Why?
Modify the Original Tables and Completing the Design
Compact and Repair a Database
Summarizing Data
Group and Summarize Records in Different Waysusing Control Fields
Summarise with a Crosstab Query
Pivot Query Results
Display a Graphical Summary on a Form
Simplifying Tasks with Macros
Create a Macro
Attach a Macro to a Command Button
Restrict Records
Require Data Entry with a Macro: i.e. validating data with macros
Display a Message Box with Macro
Making Forms More Usable
Change the Display of Data Using Conditional Formatting
Display a Calendar on a Form
Organize Information Layout
Making Reports More Powerful
Include a Chart
Using Chart & Label Wizards
Control Fields
Distribute Reports as a Snapshot
Expanding the Reach of Your Data
Merge Access Data with a Word Document
Publish Access Data as a Word Document
Analyze Access Data in E
 
|
|
|
