Question: 3 . Open the Companies table in Design View and complete the following: a . Use the Lookup Wizard to lookup values for the Industry

3. Open the Companies table in Design View and complete the following:
a. Use the Lookup Wizard to lookup values for the Industry field.
b. The lookup field should get its values from the Industries table.
c. Select the Industry field and sort the records in ascending order by the Industry field.
d. Widen the Industry field to get the best fit for all of the values in the list.
e. Enable data integrity on the relationship and use Industry as the label for the lookup field.
f. Save the table if prompted.
g. Switch to Datasheet View then choose Investment Banking & Asset Management for the Industry field for CompanyID 2(Des Moines Financial Group).
Close the Companies table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

Recording Depreciation with a Change in Depreciation Method Pier Exports purchases equipment on January 1 at a cost of $135,000. The company estimates that there will be no salvage value and that the...

Q:

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Q:

Bacteria and other microbes can be used to "clean up" an oil spill by breaking down oil into carbon dioxide and water. Two samples isolated from the Deepwater Horizon leak in the Gulf of Mexico were...

Q:

Open the start file AC2019-Capstone-Level3 . NOTE: If necessary, enable active content by clicking the Enable Content button in the Message Bar. The file will be renamed automatically to include your...

Q:

You work in the Admissions Office at Ridgedale College to help track grants awarded to professors as well as teaching assistant assignments by class. You have created an Access database to organize...

Q:

Because you are a regional manager for Personal Insurance, Inc., it is useful to know in which regions of the country each customer resides. Open the Customers table in Design View and perform the...

Q:

Because you are a regional manager for Personal Insurance, Inc., it is useful to know in which regions of the country each customer resides. Open the Customers table in Design View and perform the...

Q:

Because you are a regional manager for Personal Insurance, Inc., it is useful to know in which regions of the country each customer resides. Open the Customers table in Design View and perform the...

Q:

I need help specifically with steps 7,8, and 9 but would prefer for the entire problem to be worked to double-check the answers. Project Description: You are the general manager of a large hotel...

Q:

module 3- please help!! not great with Access so I would greatly appreicate the steps being broken down! thanks in advance SO much! I have the getting started part down so you skip that part. - Open...

Q:

number and account type must be entered. To do this you will set the PhoneNumber and AccountTxpe fields as required fields. Open the Customers table in Design view. Set the PhoneNumber and...

Q:

Name this molecule. C-C=C-C-

Q:

At 298 K a cell reaction has a standard cell potential of +0.17 V. The equilibrium constant for the reaction is 5.5 105. What is the value of n for the reaction?

Q:

During the last 6 weeks, the actual costs of labor for Solsana Company were as follows: Week 1 $38,500 Week 4 $45,600 Week 2 $40,000 Week 5 $48,000 Week 3 $42,000 Week 6 $51,000 The standard...

Q:

Bond X is noncallable and has 20 years to maturity, a 9% annual coupon, and a $1,000 par value. Your required return on Bond X is 12%; if you buy it, you plan to hold it for 5 years. You (and the...