Question: Open Access and create a new database having a name of your choosing. Create the CUSTOMER and CONTACT tables. Assume the foliowing data types: Add

Open Access and create a new database having a name of your choosing. Create the CUSTOMER and CONTACT tables.

Assume the foliowing data types:

Attribute (Field) CustomerID (in CUSTOMER) Name Data Type AutoNumber Text (50) Email

Add Description entries to the Field definitions that you think are appropriate.

Attribute (Field) CustomerID (in CUSTOMER) Name Data Type AutoNumber Text (50) Email CustomerID (in CONTACT) Date Subject Text (75) Number (long integer) Date Text (200)

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 Experiencing MIS Questions!

IfyouhaveplayedaSimulationcalledProBankerIneedhelpansweringthesequestionsassoonaspossible from the pro bankerassignment attachment..please use spreadsheet and players manual for reference. Need...

A creative engineer suggests structuring the TLB so that not all the bits of the presented address need match to result in a hit. Suggest how this might be achieved, and what might be the costs and...

Please complete the attached worksheet thank you and highlight the answer in yellow see attachment Question 1 of 15 1. A small consulting company wants to make the switch to QuickBooks Online. All of...

HOW DO YOU CREATE TABLES? Open Access and create a new database having a name of your choosing. Create the CUSTOMER and CONTACT tables. Assume the following data types: Attribute ( Field ) Data Type...

Open Access and create a new database having a name of your choosing. Create the CUSTOMER and CONTACT tables. Assume the following data types: \ table [ [ Attribute ( Field ) , Data Type ] , [...

In this e - project, you will construct a database of customer purchases for a small concession stand near Four Corners, the point in the United States where the Utah, Colorado, Arizona, and New...

Overview This assignment requires you to convert a UML class diagram into a relational model, physically create tables in Microsoft Access, and enter data into the tables. The main purpose of this...

home / study / business / accounting / accounting questions and answers / ex16_ac_ch02_grader_ml1_hw - my game collection project description: you have cataloged your ... Question:...

Marc has an income of $20 per week. Root beer costs $5 a can and CDs cost $10 each. The figure, below, illustrates his preferences. a. What are the quantities of root beer and CDs that Marc buys? b....

Suppose an antique clock is expected to be worth $325 after 2 years and $550 after 5 years. What will the clock be worth after 7 years?

how to create a clear plan to raise substantial capital through public investors enables me to generate additional revenue and finance the business by selling stocks and shares."

Which of the following is not a part of the internal control structure? a. The control environment. b. The accounting system. c. The control procedures. d. The control risk.

The following two tables could be used to store the data in Figure 5-15 in a database. ChoirMember (LastName, FirstName, Email, Phone, Part) MusicalWork (NameOfWork, Composer, Part, CopyNumber) This...

A three table database design for the data in the spreadsheet in Figure 5-15 is as follows: ChoirMember (LastName, FirstName, Email, Phone, Part) MusicalWork (NameOfWork, Composer) CheckOut...

1. How serious a problem is duplicate information to the financial services industry? Is it more serious for some industries than others? (Hint: How much of an issue is it for the health industry?)...

Which of the Following are not finance activities? a. Planning and budgeting b. Revenue cycle management c. Financial reporting d. Financial risk management e. Facilities management

Suppose the risk-free return is 4.4% and the market portfolio has an expected return of 11.8% and a standard deviation of 16%. Johnson & Johnson Corporation stock has a beta of 0.33. What is the...

You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the companys financial statements,...