Friday, January 11

 

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:
  • Continue Daily Journal
  • Students will complete Access Problem 5 (JSP Recruiters Database)
  • After completing this assignment, you should have the following items in your database:
    • Client Table
    • Recruiter Table
    • Recruiter Master Form
    • Clients of Recruiter Subform
    • Comment and Start Date Query
    • Recruiter Form
    • Client and Recruiter Form
  • When you have completed the assignment above, call the instructor over for a screen check. Do not print!
  • Due tomorrow at the end of class
Summarizing Strategy:

TOD: Answer Key Questions above. Turn in when completed.

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