Byron Employment

Byron Employment. Over 71,576 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $880.00

Course Outline: Access 2002 - Level 2

Learning Method: Instructor Led

Duration: 2 Days

Overview:
Students will learn how to use complex query techniques, create efficient forms and reports, and create macros to automate their forms.

Outline:
Lesson 1: Structuring Existing Data
- Use the Table Analyzer 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

Lesson 2: Summarizing Data
- Group and Summarize Records in Different Ways
- Summarize with a Crosstab Query
- Pivot Query Results
- Display a Graphical Summary on a Form

Lesson 3: Simplifying Tasks with Macros
- Create a Macro
- Attach a Macro to a Command Button
- Restrict Records

Lesson 4: Adding Interaction and Automation with Macros
- Require Data Entry with a Macro
- Display a Message Box with a Macro
- Automate Data Entry

Lesson 5: Making Forms More Usable
- Change the Display of Data Under Certain Conditions
- Display a Calendar on a Form
- Organize Information with Tab Pages

Lesson 6: Making Reports More Powerful
- Cancel Printing of a Blank Report
- Include a Chart
- Arrange Data in Columns
- Distribute Reports as a Snapshot

Lesson 7: Expanding the Reach of Your Data
- Merge Access Data with a Word Document
- Publish Access Data as a Word Document
- Analyze Access Data in Excel

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (02) 8263 5906
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (02) 8263 5906 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search