Wednesday, September 26

 

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 Birds2U 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 81-85
  • If necessary, students will complete yesterday's assignment. See yesterday's assignment for details.
  • Students will complete In the Lab 1 - page 250-251 (Birds2U - 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 Birds2U database:
    • Item Table
    • Supplier Table
    • Supplier and Items Query
    • Item Update Form
    • Supplier Form
    • Inventory Report
    • On Hand Value Report
    • Supplier/Item 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: What is a bound control? What is an unbound control?

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