Assignment 2 is on database development using Microsoft Access. It involves the following features of Microsoft Access to be used in solving a business problem:

- Create database

- Data entry: tables, fields, records, and primary key

Add, change, delete in database -

Create relationship, sort and retrieve data -

Create and modify query, form, and report: wizard - Print report based request

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

1. Open Microsoft Access.

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

4. Retain primary key fields name as Id

5.Enter these data into Notebook table :

Field Name	Data
brand	compaq
model	CQ40
processor	inte; Code 2 Duo
memory	2GB
Harddisk	120GB
price	899.00

6. Close Notebook table

7. Create a form to insert new data into Notebook table

8. Save the insert form as New Notebook Form.

9. Enter data for four notebooks using New Notebook Form.

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.