You are to develop a simple database that will store notebook specification incl

Question

You are to develop a simple database that will store notebook specification including price for each notebook using Microsoft Access 2003/2007. Follow the instructions below.
1. Open Microsoft Access 2003/2007. 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.
4. Retain Primary Key field%u2019s name as ID.
5. 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
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. Tip: Format the report using Flow style.
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.

Explanation / Answer

Do as said. Its not a problem.

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.