Monday, January 7


Essential Question: How do I use Access to manage and edit database files?
Key Questions: What is a Date field? What is a Memo field? What is an OLE (Object Linking and Embedding) field? What is a Hyperlink field? How do I use data, memo, OLE, and hyperlink fields? How do I use the Input Mask wizard? How do I update fields and enter data? How do I change row and column size? How do I create a form with a subform using the Form wizard? How do I modify a subform design? How do I modify a form design? How do I move and resize fields and labels? How do I change label alignment and size? How do I change the side mode of a picture? How do I change special effects and colors of labels? How do I add a form title and fine-tune the form? How do I change tab stops and tab order? How do I use the form to view data and Web pages? How do I use Date and Memo fields in a query? How do I view object dependencies?
Activating Strategy: Fact of the Day: In the White House, there are 13,092 knives, forks, and spoons.
Instructional Strategies and Student Activity:
  • Continue Daily Journal
  • Continue Daily Vocabulary; define terms 206-210
  • Students will complete Access Project 5 - page 260-302 (Ashton James College)
  • 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
    • Clients Form
    • Trainer Master 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, TOD, grade completed assignments
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