Computer 1

Chapter 13 Study Guide
This is to help you study for your quiz over Chapter 13.
Do not only memorize this guide word for word, you should be prepared to show that you understand the terms and ideas listed below.
- A report presents data from a database in an organized manner with a descriptive title, headings and summaries.
- The report wizard is a easy and fast way to create a report
- Data Grouping organizes data by a selected filed and indents the data in the report, which makes the report easier to understand.
- A report summary provides statistics on a number field, such as an average or minimum value.
- A report can be modified in design view to change the layout, colors and add graphics.
- A report can be distributed in two ways: as an HTML document, or a report snapshot (which will have an extension of .snp)
- A calculated field displays the result of a mathematical expression and is defined in a select query. Examples of a calculated field would be Profit (Price-Cost).
- Information in Access can be exported to Excel, and data in Excel can easily be imported into Access.
- Access, like most Office Applications, offers linked data, which means data will be automatically updated when linked in another Office application.

A great way to study for the quiz would be to have a study partner ask you to explain the underlined terms above in your own words.

Here's Chapter 13

Here's exactly what you'll turn in for the chapter packet of chapter 13.
Practices:
**Remember, you'll be working off of the gadget depot database you've been using from the previous chapter with your changes from the last chapter already completed.**
pg. 473 gadget depot part 4, print report
pg. 475 gadget depot part 5, print summary report
pg. 478 gadget depot part 6, print designed report
pg. 481 gadget depot part 8, print the select query with 2 calculated fields
pg. 483 Garden Sale, print excel workbook
pg. 487 print the report
Review Questions:
1-14
Exercises:
1 - Museum Exhibits
2 - Library
3 - Pizza Payroll
4 - Boat Storage
5 - Messages

Chapter 12 Study Guide
This is to help you study for your quiz over Chapter 12.
Do not only memorize this guide word for word, you should be prepared to show that you understand the terms and ideas listed below.
- Tables are related when a field in one table corresponds to a field in another table.
- Table relationships can be viewed, created and deleted in the Relationships window (Tools-->Relationships)
- Sudatasheets show the records from another table that are related to the current table.
- Queries
--Select Query - selects data that matches a specified criteria.
--Range Query - matches a range of values. Uses relational operators ( < > <= >= <>)
--Complex Queries - a select query with multiple criteria. Uses AND and/or OR
--Wildcards * matches any number of characters, ? matches any one character
--Update query modifies or updates records.
-Mail merge integrates data from a database into a "form letter". This drastically reduces the time needed to create large mailings.
-Mail merge can also be used with mailing labels.

"

Here is the digital file of chapter 12

Here's exactly what you'll turn in for the chapter packet of chapter 12.
Practices:
**Remember, you'll be working off of the widget database you've been using from the previous chapter with your changes from the last chapter already completed.**
pg. 433 widget part 8, print select query
pg. 435 widget part 9, print new select query based off of existing query
pg. 450 June sales mail merge, print 2 letters from June Sale mail merge
pg. 453 June Sales Labels, print labels on standard paper
Review Questions:
1-18
Exercises:
1 - Museum Exhibits
2 - Library
3 - Pizza Payroll
4 - Boat Storage
5 - Messages

Your exam will consist of exercises from past chapters. You will need to complete the exercises without any outside assistance. You will choose 3 out of the four exercises, with the database exercise being required. The exercises will focus on the following topics:

Spreadsheets:
1
    Creating an workbook, entering data, and applying formatting such as shading, borders and text style (bold, italics, etc...)
    Using a formula to do a basic calculation, such as net income.
    Creating a header and adding gridlines, displaying formulas when printing.
2
    Creating a workbook, entering data, and using multiple sheets
    Using formulas that use data from multiple sheets to calculate totals using cell references
    Creating a header and adding gridlines, displaying formulas when printing.
3
    Use an existing spreadsheet, and sort items by alphabetical order
    Use a choose function to determine a value based on a criterion (1=60%, 2=50%, etc...)
    Create and use a VLOOKUP function
    Create header, display formulas

Databases:
4*(Required)
    Create a relational database with three tables, and use the lookup wizard to link the tables
    Create three forms and use them to enter data into the tables
    Print the tables
    

This gives you 4 class times to finish up on the chapter. Some work time may be shortened due to exam review time.

Here's exactly what you'll turn in for the chapter packet of chapter 11.
Practices:
pg. 381 - Widget 1 - Done on pencil and paper (or in word)
pg. 396 - Print the Retailers form as instructed
pg. 397- Print the Product Table as instructed
pg. 397 - Print the Orders Table as instructed
pg. 397 - Print the Orders Records as instructed
pg. 404 - Print Production Memo
Review Questions:
1-16, 19-25
Exercises:
1 - Museum Exhibits
2 - Library
3 - Pizza Payroll
4 - Boat Storage
5 - Messages
9 - Summer Camp
10 -Travel
11- Video Store

In all the quiz commotion I forgot to hand back your graded chapter 10 packets. The grades are online at edline and you'll get them back Tuesday.