Computer Shop DB

You are to develop a simple database that will store notebook specification including price for each notebook using Microsoft Access 2003/2007/2010/2013. Follow the instructions below.

• Open Microsoft Access 2003/2007/2010/2013.
• Create a blank Access database in the MS Access folder and save as Computer Shop.
• 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.
• Retain Primary Key fields name as ID.
• 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

• Close Notebook table.
• Create a form to insert new data into Notebook table.
• Save the insert form as New Notebook Form.
• Enter data for four notebooks using New Notebook Form. (Make up some reasonable figures.)
• Create a query that is able to retrieve these items: Brand, Model, Price
• Save the query as Quick Notebook Info.
• Run the query.
• Create a report that will show all fields/attributes and sort the records according to Brand.
• Save the report as Notebook Inventory.
• Adjust the columns in report design to ensure all data are displayed in a proper manner.
• Close the report.
• Exit MS Access 2003/2007/2010/2013.