|
 | Read
NJ.Com article that discusses the value of having a list (with photos)
when filing insurance claims for loss due to fire or theft of your property
|
|
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
|
|
Create a Form
 |
2007: Create Ribbon
 Form,
then click on upper left to switch to form data entry view
|
|
2003: 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:
|
|
load the Access file, which has all of the above contained within it, and
whose name is something.accdb 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 (2nd) 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
|
|
YouTube and other Video Tutorials
Access 2007 Help and How-to
(9082 votes)
(1705 votes) 
Florida Gulf Coast has a Access 2000 tutorial 
Bay City Public
BrainBell has 12 detailed Access 2003 lesson
