|
Switchboards, PivotTables, and PivotCharts
|
Key
Concepts |
-
Create, add action to run, copy, and modify macros
-
Create a switchboard and switchboard pages
-
Modify switchboard pages
-
Use a switchboard
-
Import data and create a query
-
Create a PivotTable
-
Change properties in a PivotTable
|
-
Use a PivotTable
-
Create a PivotChart and add a legend
-
Change the chart type and organization or a PivotChart
-
Remove drop areas in a PivotChart
-
Assign axis titles and a chart title in a PivotChart
-
Use a PivotChart
|
What to do
1.
Create a copy of the
database used on the previous project.
|
Create copies of the databases as
follows: |
|
Ashton James College 5.mdb
-->
Ashton James College 6.mdb |
|
City Guide 5.mdb
-->
City Guide 6 .mdb |
3.
Complete SAM training
and exam for Access 6
4.
Pages AC - Ashton James College;
this assignment is not graded or submitted
5.
Part 1 Instructions:
A.
Create macro to open the
Advertiser Update Form
B.
Create a macro to open the Ad
Rep Master Form
C.
Create a macro to preview and to
print all the reports
in the City Guide database
D.
Create macros to open all the
tables in the database
E.
Create a switchboard
that uses all the macros created in the steps above
5.
Part 2 Instructions:
A.
Add a table named Active
Accounts to the database using the information below.
B.
Add a table named Category
to the database using the information below.
C.
Import the
Active Accounts
text file into the Active Accounts table.
D.
Import the
Ad Categories
text file into the Category table.
E.
Update the table relationships by relating the Category Code between the
Active Accounts and Ad Categories tables. Be sure to set the options to
Enforce Referential Integrity and Cascade Update Related Fields.
|
Structure of Active
Accounts Table |
|
Field Name |
Data Type |
Field Size
|
Primary Key? |
Description |
|
Advertiser Number |
Text |
4 |
Yes |
Advertiser Number (Portion of Primary Key) |
|
Ad Month |
Text |
3 |
Yes |
Month that Ad is to run (Portion of Primary Key) |
|
Category Code |
Text |
1 |
|
Ad Category |
|
Structure of Active
Category Table |
|
Field Name |
Data Type |
Field Size
|
Primary Key? |
Description |
|
Category Code |
Text |
1 |
Yes |
Ad Category |
|
Category Description |
Text |
50 |
|
Advertiser Number |
View Solutions
|
Grading Rubric |
|
Points |
Requirements |
|
2 |
Created macros to open the Advertiser Update Form |
|
2 |
Created macros to open the Ad Rep Master Form |
|
2 |
Created macro to preview and print all reports |
|
2 |
Created macros to open all tables in database |
|
2 |
Created Switchboard |
|
4 |
Added Active Accounts Table & Imported data |
|
4 |
Added Category Table & Imported data |
|
2 |
Updated table relationships |
|
20 |
Total possible for uploading City Guide 6.mdb
|
DropBox
- Upload
Your Assignments to the Digital Drop Box
|