1 / 12

Spring 2014

Spring 2014. Business Information Management Sandra Parker. Business Information Management January 7, 2014. Lesson Target: Understand how to manage relationship between Tables in Access. Key Question:

hinto
Download Presentation

Spring 2014

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Spring 2014 Business Information Management Sandra Parker

  2. Business Information ManagementJanuary 7, 2014 • Lesson Target: • Understand how to manage relationship between Tables in Access. • Key Question: • What does “Integrity” mean and how could this term apply to relationships between tables in Access? • Activity: • Create a File for Access Chapter 2 Terms in a Word Document. • Key the terms on page 643 • Complete A Try 08, p. 644 – 952 (together, practice) • Complete A Proj 17, p. 652 (formative) • Complete A Proj 18, p. 654 (formative)

  3. Business Information ManagementJanuary 8, 2014 • Lesson Target: • Learn how to use “find/replace/sort” to data mine. • Key Question: • How is using the “find” tool like using a flashlight? • Activity: • Key Access Lesson 9 terms, p. 656 (formative) • A Try 09, p. 657-661 (together, practice) • A Proj 19, p. 661 (formative) • A Proj 20, p. 662 (formative)

  4. Business Information ManagementJanuary 9, 2014 • Lesson Target: • Learn how to “Filter Data”. • Key Question: • How does a filter of any type work? • Activity: • Key Access Lesson 10 terms, p. 663 (formative) • A Try10, p. 664 (practice) • A Proj 21, p. 667 (formative) • A Proj 22, p. 668 (formative)

  5. Business Information ManagementJanuary 10, 2014 • Lesson Target: • Learn how to create a “Query”. • Key Question: • What word also has the prefix in “query” that means the same thing? • Activity: • Key Access Lesson 11 terms, p. 669 • A Try 11, p. 670-675 • A Proj 23, p. 675 • A Proj 24, p. 676

  6. Business Information ManagementJanuary 13, 2014 • Lesson Target: • Learn how to create a query that will search through many tables. • Key Question: • How does using a query help you quickly find information? (data mining) • Activity: • Key Lesson 12 terms, p. 677 • A Try 12, p. 679 (together) (practice) • A Proj 25, p. 682 (formative) • A Proj 26, p. 683 (formative)

  7. Business Information ManagementJanuary 14, 2014 • Lesson Target: • How to specify criteria in a query. • Key Question: • How is a query like a filter? • Activity: • Key the terms for Lesson 13, p. 684 (formative) • Atry 13, p. 685-687 (practice) • Aproj 27, p. 687 (formative) • Aproj 28, p. 688 (formative)

  8. Business Information ManagementJanuary 15, 2014 • Lesson Target: • How to use comparison and wildcard operators in a query. • Key Question: • When should you use the “Between…And” operator in a query? • Activity: • Key the terms for Lesson14, p. 689 (formative) • A Try 14, p. 690-693 (practice) • A Proj 29, p. 693 (formative) • A Proj 30, p. (formative)

  9. Business Information ManagementJanuary 16, 2014 • Lesson Target: • Understand how to use a “calculated field” • Key Question: • When would it be useful to have a calculated field in a table? • Activity: • Key terms for Lesson 15, p. 695 (formative) • Atry 15, p. 697-698 (practice) • Aproj 31 (formative) • Aproj 32 (formative)

  10. Business Information ManagementJanuary 17, 2014 • Lesson Target: • Understand how to summarize information in a query. • Key Question: • Which function would help you find the highest number in a table? • Activity: • Key the terms for lesson 16,p. 701 • Print all of the terms for Access, Chapter 2 and turn in. (formative) • Atry 16, p. 702-704 (practice) • Aproj 33, p. 705 (formative) • aProj 34, p. 706 (formative)

  11. Business Information ManagementJanuary 21, 2014 • Lesson Target: • Apply what you have learned in Chapter 2 • Key Question: • What do you remember from the lessons in Chapter 2? • Activity: • Project 35, p. 707 (formative) • Project 36, p. 708 (formative)

  12. Business Information ManagementJanuary 22, 2014 • Lesson Target: • Apply what you have learned in Chapter 2 • Key Question: • What do you remember from the lessons in Chapter 2? • Activity: • Chapter 2 Test (summative)

More Related