lesson plan - welcome to · web viewpublishers_books_and_authors_report homework handout for...
Post on 24-Mar-2018
216 Views
Preview:
TRANSCRIPT
Access Chapter 1 – Introduction to Access:Finding Your Way through a Database
Table of Contents
Lesson Plan............................................................................................. 2
Solution for Ch 1 Homework (Hands-On Exercises in Chapter)......... 4
Capstone Exercise for Ch 1 (End of Chapter Capstone Exercise)..... 8
Solution for Capstone Exercise............................................................. 9
Homework Handout for next class period (Ch 2).................................13
Access Chapter 1 – Introduction to Access: Finding Your Way through a Database
Materials NeededDescription of Document Name of Document Location of Files
Solution to Homework Hands-on Exercises for Access Chapter 1
chap1_ho1-3_traders_solution.accdbchap1_ho1_traders_solution.accdbchap1_ho2_traders_solution.accdbchap1_ho2_traders_solution.docxChap1_ho3_apricot_report Exploring Access 2007
Chapter 1 Folder onInstructor Resource Disk
orwww.prenhall.com/
exploring
Capstone Exercise for Access Chapter 1 ExplOffice2007_AccessCh1CE.docx
Solution forCapstone Exercise for Access Chapter 1
AccessCh1CE_solution.accdbPublishers_Books_and_Authors_Report
Homework Handout for Access Chapter 2 ExplOffice2007_AccessCh2HW.docx
Answer Key for MyITLab Access Chap 1
AnswerKey_MyITLab_Access_Chap_1
Class Run-Down1. Have students turn in Homework assignments.2. Talk about chapter using discussion questions listed below. 3. Demonstrate Access 2007.4. Direct students to the MyITLab site to complete the following:
a. Access Chapter 1 Pre-Testb. Study Planc. Access Chapter 1 Post-Test
5. Have students complete Capstone Exercise for Access Chapter 1.6. Give students Homework Handout for next class period.
Learning ObjectivesAt the end of this lesson students should be able to:
▪ Explore, describe, and navigate among the objects in an Access
database.
▪ Understand the differences between working in storage and memory.
▪ Practice good file management.
▪ Backup, compact, and repair Access files.
▪ Create filters.
▪ Sort table data on one or more fields.
▪ Work with different views in Access objects.
▪ Know when to use Access or Excel to manage data.
2
Access Chapter 1 – Introduction to Access: Finding Your Way through a Database
▪ Use the Relationship window.
▪ Understand relational power.
Discussion Questions ▪ What is a database? Why are databases important? Why is a database
useful? What are the advantages of a database?▪ What is the difference between working in storage and working in
memory? Which does Access primarily work from?▪ What are some good file management techniques and why is it important
to use them?▪ What are some factors you should considers when deciding whether to
use Access or Excel to manage data?▪ Where does the power of a relational database lie?
Additional Web ResourcesFrom Microsoft Office Online for Access 2007:
Database design basics File management Sorting and Filtering
Demonstrate how to:▪ Explore, describe, and navigate among the objects in an Access
database.▪ Backup, compact, and repair Access files.▪ Create filters.▪ Sort table data on one or more fields.▪ Work with different views in Access objects.▪ Use the Relationship window.
3
Access Chapter 1 – Introduction to Access: Finding Your Way through a Database
chap1_ho1-3_traders_solution.accdb
4
Access Chapter 1 – Introduction to Access: Finding Your Way through a Database
chap1_ho1_traders_solution.accdb
5
Access Chapter 1 – Introduction to Access: Finding Your Way through a Database
chap1_ho2_traders_solution.accdbchap1_ho2_traders_solution.docx
6
Access Chapter 1 – Introduction to Access: Finding Your Way through a Database
Chap1_ho3_apricot_report
7
Exploring Access 2007 Access Chapter 1 Capstone Exercise
Student Name: _________________ Section: ______
Due Date: _____________ 00 Points Possible Points Earned: ________
Objectives Given a database make modifications to records and a form. Verify that changes have
updated in other objects.
Preparation & Helpful Information Read Chapter 1 – “Introduction to Access: Finding Your Way through a Database” located
in the Microsoft Office 2007 Professional book. Check each step before continuing; it is easy to skip one when you hurry. If you are not familiar with Access, allow yourself extra time for the exercises. Read this assignment sheet first before you complete any assignments. Many times there
will be additional instructions not included in your book.
InstructionsDesignate one disk for your Access assignments, as these files take up a lot of space.
TASK 1: Read Access Chapter 1, pages 000-000.
TASK 2: Complete Capstone Exercise: Bookstore Inventory on page 00.
TASK 3: Print the report from Step C under View a Report
TASK 4: Print the table Step E under Filter a Table
When you complete your assignment, do the following:Turn in your printouts and disk to your instructor.
8
Access Chapter 1 – Introduction to Access: Finding Your Way through a Database
AccessCh1CE_solution.accdb
Modify Record and Open Author Form
9
Access Chapter 1 – Introduction to Access: Finding Your Way through a Database
Sort a Query and Apply a Filter
10
Access Chapter 1 – Introduction to Access: Finding Your Way through a Database
Publishers, Books and Authors Report
11
Access Chapter 1 – Introduction to Access: Finding Your Way through a Database
Filter a Table
12
Exploring Office 2007 Access Chapter 2 HOMEWORK
Student Name: _________________ Section: ______
Due Date: _____________ 00 Points Possible Points Earned: ________
Learning ObjectivesAt the end of this lesson students should be able to:
▪ Design data.
▪ Create tables.
▪ Understand table relationships.
▪ Share data with Excel.
▪ Establish table relationships.
▪ Create a query.
▪ Specify criteria for different data types.
▪ Copy and run a query.
▪ Use the Query Wizard.
▪ Understand large database differences.
Assignmento Read Chapter 2 – “Relational Databases and Multi-Table Queries” pages 000-
000. o Complete the three Hands-on Exercises in the chapter.
When your assignment is complete, do the following:
Turn in the following printouts and files to your instructor:□“Branch table printout” and “chap2_ho1-3_safebank_solution.accdb” file.
□“chap2_ho1_safebank_solution_backup.accdb” file. □“chap2_ho2_safebank_solution_backup.accdb”file.
13
top related