Level 17: The Indie Scene

1. Lessons

Click each one of the links.

Read the lessons and try the examples.

 

Independent Investigation Page 11

Advanced Guide to Microsoft Access

Create a Search Table Page 14
Use a Query for a List Form Page 19
Use the Datasheet View Page 23
AfterUpdate() Event Page 31
 

Search and Research Page 35

Advanced Guide to Microsoft Access

Synchronized Combos Page 37
Query Totals/Group By Page 39
The Expression Builder Page 41
Double Click Event Page 47
Filter by Form Page 52
 

The Producers Page 63

Advanced Guide to Microsoft Access

Mail Merge Data Source Page 69
Access Report Options Page 74
Export to Microsoft Word Page 83
Create a PivotChart Page 84
Attaching files to a record Page 89
The Label Wizard Page 93

The Performance Network  Page 103

Advanced Guide to Microsoft Access

Split the database Page 107
Linked Tables Page 115
Define Relationships Page 122
Document the Database Page 125
 

Rave Reviews Page 130

Advanced Guide to Microsoft Access

Strategies for archiving data Page 133
Memo and Multi-value fields Page 135
Export to Excel Page 150
Import from Excel Page 162
 

From the Director Page 168

 

2. Downloads

FrontRowVideoIntermediateComplete.zip

2007 Mail Merge Sample

 

Practice Activities

 

3. Assessment

Complete the Online Quiz for Level 17

Optional Skill Test: Download the instructions. You can use this practice to assess your progress.

Try it: Download these files.

1. Right-Click on the link.
2. Click on SAVE TARGET AS,

do not click Open
3. Go to the Documents folder
4. Click on SAVE

 

Sample Access Databases
These samples are Zipped (compressed) to improve your download. However, you will need to Unzip them before you can begin programming.