Database_exam_practice_-_v3

Database_exam_practice_-_v3 - DatabasePractice Accounting...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Database Practice Accounting 307 PART I – ACCESS QUIZ PRACTICE Note: You should work through the entire Query Practice document BEFORE looking at this document. If you use this practice quiz as your primary source of studying, you will likely fail the quiz. Only use this document to become familiar with the format of the quiz.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
INVENTORY REQUISITION DATABASE – Partial Data NOTE: Primary keys are shaded INVENTORY Item# ItemName Price QOH ReorderQty 936 Machine Plates 39.50 1,500 950 1005 Gaskets 9.50 10,002 3,500 1006 Crank Shafts 115.00 952 500 1015 Manifolds 45.00 402 400 EMPLOYEES Emp# FirstName LastName SSAN Department B432 Carl Mast 125-87-8090 492-01 A491 Janet Kopp 127-93-3453 639-04 A632 Greg Bazie 350-97-9030 538-22 F395 Christy Kirman 123-78-0097 298-12 VENDORS Vend# Vend_Name Street City State ZIP Tel Vend_Contact Credit_Terms FOB_Terms 539 Ace Widget Co. 190 Shore Dr. Charleston SC 29915 803-995-3764 S. Emerson 2/10,n/30 Ship Pt 540 Babcock Supply Co. 22 Ribaut Rd. Beaufort SC 29902 803-552-4788 Frank Roy n/60 Destin 541 Webster Steel Corp. 49 Abercorn St. Savannah GA 30901 912-433-1750 Wilbur Cox 2/10,n/30 Ship Pt PURCHASE REQUISITIONS PR# PRDate Emp# PO# 53948 20071215 A491 4346 53949 20071215 C457 4346 53950 20071216 A632 4347 53951 20071216 F494 4352
Background image of page 2
PURCHASE ORDERS PO# PRDate Vend# Emp# PO_Status 4345 20071218 539 F395 Open 4346 20071220 541 C932 Open 4347 20071222 562 E049 Acknowledged PURCHASE RECEIPTS Rec# PRDate Emp# PO# Vend# 42944 20071216 B260 4322 555 42945 20071216 B260 4339 476 42946 20071216 B260 4345 489 42947 20071216 B260 4345 489 INVENTORY_REQUISITION PR# Item# Qty_Requested 53947 1005 200 53947 1006 50 53948 1005 25 INVENTORY_PURCHORDER PO# Item# Qty_Ordered 4345 1005 200 4345 1006 50 4346 1005 25 INVENTORY_RECEIPT Rec# Item# Qty_Received 42946 1005 180 42946 1006 50 42947 1005 15
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Questions 1 through 10 refer to the above database. These are similar to questions that will appear on the Access test. 1. Identify the primary keys. 2. Identify the foreign keys. What would the output be for the following queries? Note that the only fields shown in the diagrams are those fields that relate the necessary tables or queries and that are referenced in the current query. 3. INVENTORY Item# ItemName INVENTORY_ RECEIPT Item# Qty_Received 1 Field: ItemName Qty_Received Table: INVENTORY INVENTORY_RECEIPT Total: Group By Sum Sort: Show: Criteria: Gaskets or: Solution:
Background image of page 4
4. INVENTORY_ RECEIPT Rec# Item# PURCHASE_ RECEIPTS Rec# PRDate 1 INVENTORY Item# ItemName 1 Field: ItemName Rec# PRDate Table: INVENTORY PURCHASE_RECEIPTS PURCHASE_RECEIPTS Total: Group By Group By Group By Sort: Show: Criteria: Gaskets or: Solution:
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
For the following questions, you must complete the QBE and draw the relevant tables. The tables should include:
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 41

Database_exam_practice_-_v3 - DatabasePractice Accounting...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online