Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

LINK: https://www.dropbox.com/s/tcp8zxdqiao1ibd/file.accdb?dl=0 EX16_AC_CH06_GRADER_ML1_HW - Northwind Traders Project Description: Northwind Traders is a small international specialty foods distribution firm. Management has decided to close the North

LINK: https://www.dropbox.com/s/tcp8zxdqiao1ibd/file.accdb?dl=0

EX16_AC_CH06_GRADER_ML1_HW - Northwind Traders

Project Description:

Northwind Traders is a small international specialty foods distribution firm. Management has decided to close the North and South American operations and concentrate on European markets. They asked you to update certain customer records and to move all deactivated customers to another table. Once you move the records, you will delete them from the original table.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Start Access. Open the downloaded Access database named exploring_a06_Grader_h2. Save the database as exploring_a06_Grader_h2_LastFirst.

0

2

Create a select query based on all of the fields from the Customers table. Add criteria to show only customers in the USA. Run the query.

15

3

Change the query to an update query that replaces all instances of USA with United States. Run the query and save it as Update US Customers. Close the query.

12

4

Create a make table query that is based on all of the fields in the Customers table. Name the new table Deactivated Customers. Add criteria to select only United States customers.

14

5

Run the query and save it as Make Table Query. Close the query.

11

6

Make a copy of the Make Table Query in the Navigation Pane, and name the copy Append Query. Right-click the new Append Query, and from the shortcut menu, select Design View. Change the query type to Append. Append records to the Deactivated Customers table. Change the criteria of the Country field to Venezuela. Run the query. Save and close the query.

24

7

Make a copy of the Append Query in the Navigation Pane, and name the copy Delete Query. Right-click the new Delete Query, and from the shortcut menu, select Design View. Change the query type to Delete.

14

8

Change the Country criteria to United States Or Venezuela. Delete all the columns in the query design grid except the Country column. Run the query and click Yes in the message box. Save and close the query. Open the Deactivated Customers table to view the records added by the make table and append queries. Close the tables.

10

9

Save the database. Close the database, and then exit Access. Submit the database as directed.

0

Total Points

100

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

C++ Database Development

Authors: Al Stevens

1st Edition

1558283579, 978-1558283572

More Books

Students also viewed these Databases questions