Friday, November 30

 

Essential Question:
Why should you use MS Access to create a database?
Key Questions:
What is a query? How do you run a query? How do you enter criteria? What is a wild card? How do you create a parameter query? What is compound criteria and how do you use it? What are comparison operators? How do you sort data in a query? How do you create a calculated field? What is a database? What is a table? What is a form? What is a report? What is query? How do you filter? How do you create a calculated field in a query?
Activating Strategy:
Have you ever had to look something up on the Internet?
Instructional Strategies and Student Activity:
  • Continue Daily Journal
  • Continue Daily Vocabulary; define terms 171-175
  • Complete Access Project 2 - page 68-106. Student will need Ashton James College database completed earlier in Project 1.
  • The database file will have the following objects in it:
    • Client Table
    • Trainer Table
    • City-Trainer Crosstab
    • Client-City Query
    • Client-Trainer Query
    • Client Form
    • Client Amount Report
  • File submission and grading: all work for Project 2 will be graded from Z drives
Summarizing Strategy:

TOD: How do you filter and sort? How do you create a report?

Assessment:
Observation, TOD
Resources:
MS Access, Textbook
GPS:
BCS-CA1-1,2,5,7,10

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