Question
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
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
- a)See below for the problem description.
- b)The assignment needs to be done with Microsoft Access Database software only.
- You may use any of the Office 2003/2007/2010/2013/2016 etc. versions of the
- Access software.
- c)You need a basic knowledge of Microsoft Access. From main page click on the link
- "Tutorials for Labs - Microsoft Excel and Access".
- d)Submitting Instructions: After you have completed the different parts of the
- 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.
- Retain Primary Key field'sname asID.
- 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.
- Open Microsoft Access.
- Create blank Access database in the MS Access folder and save as Computer Shop.
- 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
- CloseNotebooktable.
- Create form to insert new data intoNotebooktable.
- Save the insert form asNew Notebook Form.
- Enterdata for fournotebooks usingNew Notebook Form.
- Create query that is able to retrieve these items:Brand,Model,Price
- Save the query asQuick Notebook Info.
- Run the query.
- Create report that will show all fields/attributes and sort the records according to Brand.
- Save the report asNotebook Inventory.
- Adjust the columns in report design to ensurealldata are displayed in a proper manner.
- Close the report.
Exit MS Access.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started