Lab Assignment 2

Lab 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 modify query, form, and report: wizard
• -Print report based request
• Lab Assignment 2 - further instructions

1. a)See below for the problem description.
2. b)The assignment needs to be done with Microsoft Access Database software only.
3. You may use any of the Office 2003/2007/2010/2013/2016 etc. versions of the
4. Access software.
5. c)You need a basic knowledge of Microsoft Access. From main page click on the link
6. "Tutorials for Labs - Microsoft Excel and Access".
7. d)Submitting Instructions: After you have completed the different parts of the
8. assignment in Microsoft Access, you should have a single ".accdb" file (Access default file extension) which, when you open, would show the tables, queries etc. in answers to the different parts of the assignment as directed in the problem description. As usual, use the Blackboard assignment submission feature to submit Lab assignment 2.
9. Retain Primary Key field'sname asID.
10. Enter these data into Notebook table:

COSC 3325 Lab Assignment 2: "Notebook Database"*

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 blank Access database in the MS Access folder and save as Computer Shop.
3. Create new table namedNotebookthat contains these fields/attributes:

Field Name

Data Type

ID

Autonumber

brand

Text (or Short Text)

model

Text (or Short Text)

processor

Text (or Short Text)

memory

Text (or Short Text)

harddisk

Text (or Short Text)

price

Currency

Field Name

Data

brand

Compaq

model

CQ40

processor

Intel Code 2 Duo

memory

2GB

harddisk

120GB

price

899.00

1. CloseNotebooktable.
2. Create form to insert new data intoNotebooktable.
3. Save the insert form asNew Notebook Form.
4. Enterdata for fournotebooks usingNew Notebook Form.
5. Create query that is able to retrieve these items:Brand,Model,Price
6. Save the query asQuick Notebook Info.
7. Run the query.
8. Create report that will show all fields/attributes and sort the records according to Brand.
9. Save the report asNotebook Inventory.
10. Adjust the columns in report design to ensurealldata are displayed in a proper manner.
11. Close the report.

Exit MS Access.