Tuesday, September 25

 

Essential Question:
How do I use Access to create, manage, edit, and publish industry appropriate database files?
Key Questions:
How do I create a report using the Report Wizard? How do I use sorting and grouping in a report? How do I move controls? How do I change properties? How do I add totals and subtotals to a report? How do I align and format controls? How do I change labels and column headings? How do I use multiple tables in a report? How do I remove unwanted controls? How do I use the Form Wizard to create a form? How do I add a calculated field, combo box, and title to a form? Why should I understand form design considerations?
Activating Strategy:
Review of Access. Copy the Ashton James database from the N drive to student Z drives. Q&A if needed.
Instructional Strategies and Student Activity:
  • Continue Daily Journal
  • Continue Daily Vocabulary; define terms 76-80
  • Students will complete Access Project 4 - page 197-246 (Ashton James College - this file should be copied from the N drive to your Z drive and opened from your Z drive. Do not open it from the N drive)
  • After completing this assignment, you should have the following items in your Ashton James College database:
    • Client Table
    • Trainer Table
    • City-Trainer Crosstab
    • Client-City Query
    • Client-Trainer Query
    • Client Form
    • Client Update Form
    • Client Account Summary Report
    • Client Amount Report
    • Trainer/Client Report
  • Grading and submission of assignment:
  • Ignore all printing instructions from the book. Make sure your database has all the files listed above. This assignment will be graded from your Z drive.
Summarizing Strategy:

TOD: Answer key questions above. Turn them in when you're finished.

Assessment:
Observation; grade completed work
Resources:
MS Access, Office textbook
GPS:
BCS-CA2-1,4,6,8

Previous Lesson | Next Lesson
Back to Computer Applications II 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