Project #11222 - business access database

Basic access database with detailed instructions attached and in the body of this detail section.


Turn in one database named Lab7_yourlastname.accdb to the Dropbox. When submitting the database, provide a comment in the Dropbox comments area explaining what you learned from completing this lab activity.

Category Points %
Create a Table  10  20%
Create a Form for Data Entry  15  30%
Create a Query  10  20%
Create a Report  15  30%
Total  50 100%

L A B  S T E P S

STEP 1: Create a Table (10 points)

Back to top

Download the Lab 7, Step 1 Instructions.

NOTE: For this lab, you will not have a starter file. You will create a database from scratch.

In this step, you will create a blank database and add one table to the database. The table should contain at least the following fields:

  • ID: Autonumber field to provide a unique identifier for each item in your table
  • Item: Text field to store the Item name
  • Description: Memo field to store a description of the item
  • Condition: Lookup field to store the condition the item is in (Good, great, etc.)
  • Acquired Date: Date field stored in "Short Date" format (M/DD/YYYY)
  • Purchase Price: Currency Field to store the price you paid for the item
  • Location: Lookup field to store the names of the rooms in your house
  • Manufacturer: Text field 
  • Model: Text field to store information about the model of the item
  • Comments: Memo field to store any comments you might wish to add
  • SerialNumber: Text field to store the serial number of the item (where applicable)
  • Warranty: Boolean field (Yes/No) that will record whether the item has a warranty
  • ManufacturerURL: Hyperlink field with the support website for the item (optional)

You may add other fields if you wish.



STEP 2: Create a Form for data entry and add at least 10 records (15 points)

Back to top

Download the Lab 7, Step 2 Instructions

Entering data in Datasheet View requires a large amount of scrolling. It also exposes the table design to users, which means that users can make changes to the database design that you don't wish them to make. Create a form to enable easy entry of data. Use the form to enter at least 10 records. 

A. Create the form. Select an AutoFormat and modify the form to make it more user friendly by adding a descriptive title and making minor modifications to the form layout.

B. Enter 10 records. For at least one of these records, select Office as the Location. 



STEP 3: Create a Query to Select Records (10 points)

Back to top

Download the Lab 7, Step 3 Instructions.

Once data have been entered into a database, you will want to be able to select and retrieve data. The Query object allows you to select data from your database tables that will answer questions you might have. For example, suppose you had a small fire in your office and you wish to make an insurance claim. Using a query, you will be able to select only those records in the database that have the Location equal to "Office." Write a query that will allow you to select records based on a room you select.

A.  Use the Create Tab and select Query Wizard. Create a Simple query that selects Item, manufacturer, Model, Serial Number, Purchase Price, Acquired Date, and Location.

B.  In Design View, add the Condition field to the query. Add a Selection Criteria to the Location field so that only those records with the Location equal to Office are displayed.

C. Save the query as qryItemsbyRoom.



STEP 4: Create a Report Showing All Items Grouped by Room (15 points)

Back to top

Download the Lab 7, Step 4 Instructions

Reports allow us to create "printable" documents based on the data in our database. Create a report of your entire Inventory, grouped by room. Show only the Item, Manufacturer, Model, and Purchase Price.

A.  Use the Report Wizard to create the report.

B.  Modify the design so that the title is "Inventory by Room Report" and all data and labels are sized appropriately.

C.  Add totals by room and a grand total to the report. Add Labels to the totals.

Your final report should look something like the following (the Style may differ):

Inventory by Room Report with columns Location, Item, Manufacturer, Model, and Purchase Price, with Items grouped by Location and Purchase Price subtotalled by Location.



 Submit your completed database to the Dropbox. Make sure you post a comment about what you learned when submitting the file.

Subject Business
Due By (Pacific Time) 08/25/2013 08:00 am
Report DMCA

Chat Now!

out of 1971 reviews

Chat Now!

out of 766 reviews

Chat Now!

out of 1164 reviews

Chat Now!

out of 721 reviews

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews

Chat Now!

out of 766 reviews

Chat Now!

out of 680 reviews
All Rights Reserved. Copyright by - Copyright Policy