Thursday, January 10

 

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: Begin working on assignments below.
Instructional Strategies and Student Activity:
  • Complete Excel Project 5 - get handout from your instructor
  • This project creates 2 files - Silver Photography Accessories Sales Rep Table.xls and Silver Photography Accessories Sales Rep Table.csv
  • Do not print - when you have saved both files above, call the instructor over for a screen check so that you can get a grade for this assignment
Summarizing Strategy:

TOD: List and describe three new Access skills you acquired today.

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 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