Access DB- Home Inventory

Procedure:

create a table using the table wizard and the Home Inventory from the personal database templates.

select at a minimum "Item Name", "Item Type", "Insured", "Room", "Date Purchased", "Price Paid", "Description".

modify the design so that the "Room" is a text field and

"Insured" can hold numbers

change field names and lengths

enter one item (the rest will be entered in form view

in datasheet view use the Autoform wizard icon to create a form

switch between form design view and form data entry view

while in design view make some changes to field Properties to demonstrate your ability to do so

change field sizes (some wider, some taller, some narrower, etc

change label and field appearance

colors, borders and effects, fonts (type faces), italics, font sizes

enter a minimum of 10 real or fictional items. Make sure several are in the same room and several has exactly the same item type (jewelry or electronics)

using the Report wizard create two reports:

grouped by "Room" with sums, averages and/or mins and maxes

	the report wizard
	select all the fields and then remove some, but include Room, so you have about 6 or 7 fields in the report
	on 2nd screen click on Room and > to select it
	on 3rd screen choose summary Options and select some
	choose a report style and finish
	preview the report
	go to Design and modify the report column heading so that no words are cut off and you are relatively happy with the appearance

grouped by "Item Type" with sums, averages and/or mins and maxes following above procedure except grouping by Item Type

load the Access file, which has all of the above contained within it, and whose name is something.mdb onto your briefcase and notify me via email to look at it.

print:

	the entire table in datasheet view (file Page Setup for Landscape)
	one form
	both reports

put above 3 pages in your portfolio

Example- a DVD database

Basically you will Design the DB
Create and customize a form
Enter data
Create a report, Preview it, change as needed and Print

Step-by-step

Start Access – mauve key

New Blank Database

Meaningful name on the right

Click Create

Click upper left above word View on architects pencil and t-square

Type meaningful name in Save As box

Leave ID alone

Type a Field name

Choose a big but reasonable field size below

Repeat till all fields defined

For example, a DVD table:

ID	Autonumber
DVD name	Text	Field size 100 (or whatever you think is reasonable)
Genre	Text	Field size 20 (for example comedy, drama, thriller ..etc )
When Purchase	Date
Price Paid	Currency	No decimals (who remembers!
Length in minutes	Number	Integer

Save using blue disk on quick access toolbar (icon menu) on top

Close table design view

Click Create (2^nd) ribbon

Click on table name in left column

Click on Form in Create ribbon

Click on the form icon above the word view in the upper left hand corner of the screen

Start to fill in data

To get to next record click on next or new on the bottom of the screen

Anytime while form on screen, click triangle below word View on upper left and then
click Design View from drop down

Screen now has dot

Change name names you want in dotted area ONLY

Click Property Sheet on ribbon or double click any box and then change any property (attribute) such as color. Border width, weight, italics etc on the Format tab

You can change several fields simultaneously why shift clicking them then choosing a property

On Create ribbon choose Report Wizard

Using >> select All fields

Highlight ID and send back to left using the <

Next screen ,click on a field that several records have the same value by which you want them grouped and sent to right of screen with >

Next screen, If you have any numeric fields you will be able to click Summary Options

Choose all Sum, Average, Min and Max (it will be easy to delete later)

Next screen Choose any format but make sure you click landscape

Next Screen select report style but remember that in school it’s a black and white printer and most will look less attractive some stuff may be hard to read and need to be fixed

Put you name in the title and preview the report

Switch to Design View

and make changes to Field sizes (remove ####) or Labels or color or font, etc. as required or desired

Print it

Use Tutorials to learn more

Access (click anywhere on this line to expand & contract list)

	See YouTube and other Video Tutorials
	Access 2007 Help and How-to

Overview of the Ribbon

Up to speed with Access 2007 Length: 40 min Rating: (9082 votes)

Security I: How the 2007 Office system helps you to stay safer Length: 20 min Rating: (1705 votes)

Keyboard shortcuts in the 2007 Office system Length: 30 min Rating: (3896 votes)

Up to speed with the 2007 Office system Length: 30 min Rating: (4899 votes)

Florida Gulf Coast has a Access 2000 tutorial that is very comprehensive - It includes making Web Pages, Macros, Styles and Tables of Contents. Older tutorials are fine since changes with newer versions seem to be mostly in the super fancy features which CIS100 does not cover.

Zicklin School of Business - Baruch College, City of New York
Microsoft Access Tutorial

Bay City Public covers the basics of Access with lots of screen images School

Training Tools has a fine 8 chapter Introduction with lots and lots of screen shots

BrainBell has 12 detailed Access 2003 lessons - the first few cover the basics like

Creating and Working with a Database

Finding, Filtering, and Formatting Data

Working with Forms

Working with Reports

Learnthat has 21 tutorials for Access

Learnthat.com free tutorials and online courses, business, computer, certification

En Espanol from (click anywhere on this line to expand & contract list)

Access 2000

Search this site or the web powered by FreeFind

Site search Web search

Student Learning Outcomes: