2-2 Activity: Creating a Table in MS Access Create the table that you described

Question

2-2 Activity: Creating a Table in MS Access

Create the table that you described for the company you chose for the Discussion 2-1. Be sure to appropriately identify the data types and give appropriate titles to the metadata. Input two data records into the table. Submit the completed MS Access file. In addition to this, also submit a Word document that contains a description of the completed table.

The company used in the Discussion 2-1 was Verizon, who had a direct mail CRM system in 2003 for sending advertising through USPS, which were used for retention purpose (both existing, and win-back customer type.) The data field suggested for this collection, and response feedback result were "Lead Source," "Customer," Mobile Phone," "Company Name," "Last Name," "Subject," "Lead Source," "Reference I.D.," and "Contact Number."

Explanation / Answer

Create a make table query

You create a make table query by first creating a select query, and then converting it to a make table query. Your select query can use calculated fields and expressions to help return the data that you need. The following steps explain how to create and convert the query. If you already have a select query that fits your needs, you can skip ahead to the steps for converting the select query and running the make table query.

Enable the database

Note   Follow these steps only when your database does not reside in a trusted location or is not signed. Access displays the Message Bar whenever you open an untrusted or unsigned database.

If you don't see the Message Bar

Create the select query

Note   If you already have a select query that produces the data that you need, go to the next steps.

Convert the select query

The Make Table dialog box appears.

-or-

Click the down-arrow and select an existing table name.

Note   If you are replacing an existing table, Access first deletes that table and asks you to confirm the deletion. Click Yes, and then click Yes again to create the new table.

-or-

Click Browse, use the new Make Table dialog box to locate the other database, and click OK.

Note   If you replace an existing table, Access first deletes that table and asks you to confirm the deletion. Click Yes, and then click Yes again to create the new table.

Fields:

"Lead Source," "Customer," Mobile Phone," "Company Name," "Last Name," "Subject," "Lead Source," "Reference I.D.," and "Contact Number."

CREATE TABLE company
(
Company Name CHAR(255),

Last Name CHAR(255),

Customer CHAR(255),

Mobile Phone INTEGER,

Subject CHAR(255),

Lead Source CHAR(255),

Reference I.D. CHAR(255),

Contact Number INTEGER);

QUERIES:

CREATE TABLE company(CompanyName CHAR(255),LastName CHAR(255),Customer CHAR(255),MobilePhone INTEGER,Subject CHAR(255),LeadSource CHAR(255),ReferenceID CHAR(255),ContactNumber INTEGER);

insert into company values('BPO','BP','ravi',1234567899,'funds','noone','123we433',1234554321);

insert into company values('CPO','cP','ravi',1234567899,'funds','noone','123we433',1234554321);

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.