Project #63964 - Microsoft Access Customer Assignment

Details are in attachments.

 

Attachment notes:

 

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.

Subject Business
Due By (Pacific Time) 04/06/2015 12:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy