Question Details

Answered: - directions are in the two documents (create a Microsoft ac


directions are in the two documents (create a Microsoft access document)


MICROSOFT ACCESS CUSTOMERS ASSIGNMENT

 

Open Microsoft Office Access, click Blank Database, assign the filename

 

Customers_YourLastName in the bottom right hand corner of the screen (click

 

the folder following the file name box to choose where you want to save the file,

 

if necessary), and choose Create.

 

A table temporarily named Table 1 with a field named ID is created. Change to

 

design view to setup the structure of the table. When prompted, type

 

Customer_Info as the table name. Change the ID field name to Customer #,

 

change the data type to Text, and change the field size to 5 (notice that it has

 

been assigned as the primary key field). Add the following fields:

 

FirstName Text

 

LastName Text

 

Address

 

Text

 

City

 

Text

 

State

 

Text

 

Change field size to 2 characters

 

Zip

 

Text

 

Change field size to 5 characters

 

Change the view to Data Sheet View and enter in the following data:

 

88, John Doe, 1 Main Street, Fort Pierce, FL 34950

 

62, Mary Smith, 3 Main Street, Fort Pierce, FL 34950

 

45, Tom Brown, 100 Lake Lane, Jensen Beach, FL 34947

 

77, Ann Jones, 222 Second Street, Stuart, FL 34997

 

46, Jill Johnson, 5 Fifth Street, Fort Pierce, FL 34982

 

21, Bill Smith, 111 Lake Lane, Jensen Beach, FL 34947

 

34, May June, 55 Port Point, Port St. Lucie, FL 34983

 

89, April March, 45 Port Point, Port St. Lucie, FL 34983

 

Close the table (leave the database open).

 

Create a new table (in the same database) and change to design view, naming

 

the table Order_Info. Change the ID field name to Order #. Verify that it is the

 

primary key field and that its data type is AutoNumber. Add the following fields

 

with the data type and any other specifications listed:

 

Customer# Text

 

Change field size to 5 characters

 

Order_Date Date/Time

 

Short Date Format

 

Item

 

Text

 

Quantity

 

Number

 

Price

 

Currency

 

Close the table, saving the changes.

 

Go to the Database Tools tab, Show/Hide group and choose Relationships.

 

Show both tables and create a relationship between the two tables by pointing to

 

Customer # in the list of fields from the Customer_Info table and dragging until

 


 

you are pointing to Customer # in the Order_Info table. This opens up a

 

relationship dialog box, click Enforce Referential Integrity and click the create

 

button. Close this window. You will be prompted to save the changes; click yes.

 

Open Order_Info table and add the following data (the Order # field will be

 

automatically populated due to its data type of AutoNumber ? just tab past it):

 

62

 

11/1/2010

 

College-ruled paper

 

2

 

$2.00

 

46

 

11/1/2010

 

10 pack # 2 pencils

 

1

 

$1.25

 

77

 

11/2/2010

 

Mechanical Pencil

 

2

 

$.75

 

77

 

11/2/2010

 

Blue Medium Point Pen

 

3

 

$.50

 

62

 

11/5/2010

 

Scantrons

 

5

 

$.10

 

89

 

11/7/2010

 

Scantrons

 

10

 

$.10

 

77

 

11/7/2010

 

Scantrons

 

6

 

$.10

 

45

 

11/7/2010

 

10 pack # 2 pencils

 

1

 

$1.25

 

Close the table. Click once on the Customer_Info table in the Navigation Pane

 

on the left. On the Create tab click Form in the Forms group to create an

 

automatic form for that table. Save the form as Customer_Form and close. Click

 

once on the Customer_Info table in the Navigation Pane again if it is no longer

 

selected and click Report in the Reports group on the Create tab to create an

 

automatic report. Save the report as Customer_Report and close. Don?t be

 

concerned if the report doesn?t fit on one page.

 

Go to the Create tab and click Query Wizard in the Other group. Choose Simple

 

Query Wizard, then the Customer_Info table and add all of the fields. Accept the

 

remaining defaults in the wizard and change to design view when the query is

 

completed. In design view, type in Fort Pierce in the criteria row of the query grid

 

in the City column. Run the query and save as Fort_Pierce_Customers. Note:

 

the query without the criteria applied is already saved as Customer_Info_Query.

 

Create another query using the Simple Query Wizard ? choosing all of the fields

 

in both tables except for Customer #. Accept all other defaults, saving the query

 

as Orders_Query and change to design view. Click on the first empty column in

 

the design grid and type in Total_Order: [Quantity]*[Price] as the field name ?

 

this will create a calculated column in the query that figures the total of the order

 

by multiplying quantity by price. Run the query, saving the changes, and close.

 

Create an automatic form and an automatic report based on the Orders_Query

 

naming them Orders_Query_Form and Orders_Query_Report. Close the

 

database and submit in the Access Customers Assignment drop-box.

 


 

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001185444.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now