Reference no: EM131035567

MS Access 

You are to develop a simple database that will store notebook specification including price foreachnotebook using Microsoft Access 2003/2007/2010/2013.Followtheinstructions below.

1. Open Microsoft Access 2003/2007/2010/2013.
2. Create a blank Access database in the MS Access folder and save as Computer Shop.
3. Create a new table named Notebook that contains these fields/attributes:

Tip: Use Design View to create this table.

1. Retain Primary Key field's name as ID.
2. Enter these data into Notebook table:

1. Close Notebook table.
2. Create a form to insert new data into Notebook table.
3. Save the insert form as New Notebook Form.
4. Enter data for four notebooks using New Notebook Form. (Make up some reasonable figures.)

10. Create a query that is able to retrieve these items: Brand, Model, Price
11. Save the query as Quick Notebook Info.
12. Run the query.
13. Create a report that will show all fields/attributes and sort the records according to Brand.

14. Save the report as Notebook Inventory.
15. Adjust the columns in report design to ensure all data are displayed in a proper manner. 16. Close the report.
17. Exit MS Access 2003/2007/2010/2013.