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:
Change field size to 2 characters
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:
Change field size to 5 characters
Short Date Format
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):
10 pack # 2 pencils
Blue Medium Point Pen
10 pack # 2 pencils
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.
This question was answered on: Sep 18, 2020
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 .
About this QuestionSTATUS
Sep 18, 2020EXPERT
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).
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.