IEOR 115: Quiz 1
Introduction to MS Access
Prof. Ken Goldberg, Fall 2013
Due on Sept 13, 2013
Student Name: ___________________
Student ID: ______________________
Submitted on: ____________________
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community
Ask the community for help and clear up your study doubts
University Rankings
Discover the best universities in your country according to Docsity users
Free resources
Our save-the-student-ebooks!
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Introduction to MS Access Quiz 1 Review, Quizzes of Database Management Systems (DBMS)
Quiz Short Answer Questions Unsolved.
Typology: Quizzes
2021/2022
1 / 5
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Introduction to MS Access Quiz 1 Review and more Quizzes Database Management Systems (DBMS) in PDF only on Docsity!
IEOR 115: Quiz 1
Introduction to MS Access
Prof. Ken Goldberg, Fall 2013
Due on Sept 13, 2013
Student Name: ___________________
Student ID: ______________________
Submitted on: ____________________
Please write your answers only in assigned regions only. 1 Choose one of the following two ways to open the Northwind 2007 database:
- Open MS Access; click Sample under the category listed in the left task pane on the Getting Started with Office Access page; then click on the Northwind 2007 icon, enter the name and location on the right task pane and click the Download button. OR
- Go to directory *C:\Program Files\Microsoft Office\Templates\ 1033 \Access* and double click Northwind.accdb. After the Northwind 2007 is launched, please answer the following questions ( Note: the Northwind sample database in an older version of MS Access is very different from the one in MS Access 2007):
- What version of Access do you have?
- Choose Object Type on the Navigation Pane. Please list different objects or components available in the Northwind Database window? Describe two of them in simple words in terms of their functions.
Please write your answers only in assigned regions only. 3
- Find the order with the most expensive Shipping Fee, and list the Order ID and Shipping Fee.
- What are the Quick Links available in the FORM Home?
- What is the dollar amount of products ordered by Company BB during the 2nd Quarter of 2006? What is the TOTAL dollar amount ordered by Company BB in 2006? (Hint: find the relevant form or report first)
Please write your answers only in assigned regions only. 4
- What are the 10 biggest orders? What is the 3rd biggest order? (Hint: find the relevant report first)