Wednesday, March 13

 

Essential Question: How do I use Access to create and use switchboards, PivotTables, and PivotCharts in my database?
Key Questions:

What is a switchboard? What is a PivotTable? What is a PivotChart? How do I create, add actions to, run, copy, and modify macros? How do I create a switchboard and switchboard pages? How do I modify switchboard pages? How do I use a switchboard? How do I import data and create a query? How do I create a PivotTable? How do I change properties in a PivotTable? How do I use PivotTable? How do I create a PivotChart and add a legend? How do I change the chart type and organization of a PivotChart? How do I remove drop areas in a PivotChart? How do I assign axis titles and a chart title in a PivotChart? How do I use a PivotChart? What is a macro?

Activating Strategy: Begin reading over assignments below.
Instructional Strategies and Student Activity:
  • Continue Daily Journal
  • Continue Daily Vocabulary; define terms 331-335
  • Students will complete Access Project 6 (JSP Recruiters)
  • After completing this assignment, you should have the following items in your database:
    • Client Table Read Only Macro
    • Open Client Table Macro
    • Open Recruiter Table Macro
    • Open Client Form Macro
    • Open Recruiter Master Form Macro
    • Preview Client Address Report Macro
    • Preview Client Financial Report Macro
    • Preview Clients by City Report Macro
    • Preview Clients by Recruiter Report Macro
    • Print Client Address Report Macro
    • Print Client Financial Report Macro
    • Print Clients by City Report Macro
    • Print Clients by Recruiter Report Macro
    • Swithboard - must function properly
    • Seminar Table - with imported data
    • Seminar Offerings Table - with imported data
Summarizing Strategy:

TOD: Answer Key Questions above. Turn it in when you're finished.

Assessment: Observation, TOD,
Resources: MS Access, Office Textbook
GPS: BCS-CA2-1,4,6,8

Previous Lesson | Next Lesson
Back to Computer Applications Calendar | Back to Miss Rock's Homepage

 

 


Computer Applications 1 | Computer Applications 2 | Business Communication & Presentation

Computing in the Modern World | Fundamentals of Web Design | Advanced Web Design

Syllabi | Schedule | Georgia Performance Standards | FBLA | Contact

Updated August 2012

 

Computer Applications 1 Computer Applications 2 Business Communication & Presentation Computing in the Modern World Fundamentals of Web Design Advanced Web Design Animation & 3-D Design