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:

	Field Name			Data Type
ID			Autonumber
brand			Text
model			Text
processor			Text
memory			Text
harddisk			Text
price			Currency

Tip: Use Design View to create this table.

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

	Field Name			Data
brand			Compaq
model			CQ40
processor			Intel Code 2 Duo
memory			2GB
harddisk			120GB
price			899.00

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.