MS Access download named Home Contents Inventory Database

G

Guest

Can anyone download the above file from MS Online (I did a search under
TEMPLATES and then typed in INVENTORY)? It's the first MS Access file listed
that I downloaded and it's named above (in this subject line).

I am having a heck of a time trying to edit this file. What I want to do is
the following:

Add a TABLE called Mom's Beneficiaries
Either edit or add a TABLE called Mom's Categories
Either edit or add a TABLE called Mom's Rooms
Add a FORM called Mom's Beneficiaries
Either edit or add a FORM called Mom's Categories, Mom's Rooms and Mom's
Household Inventory
Either edit or add a REPORT called Mom's Inventory by Category, Mom's
Inventory by Rooms and Mom's Inventory Details

Obviously the FORMS and REPORTS need to reflect my Mom's TABLE items.

I've tried to copy the TABLES, FORMS and REPORTS that were already there and
alter them. I've also tried creating NEW ones. I don't know which way is
the best route. In the end, the only major problem I'm having is having the
FORMS and REPORTS reflect the new TABLE item I added called BENEFICIARIES. I
cannot get this TABLE item to show as a source in either the FORMS or
REPORTS. I need step by step directions.

Also, how do I add a checkmark box (like the one under FORMS called
Household Inventory for Insured)? I added it under the Design View, but when
I check it for one line item it automatically checks it for ALL line items
(same with the Beneficiary info I tried to add).

Thanks.
 
T

Tanis

personally, I would create tables, forms and reports from scratch
There is always the danger of changing the name of a field that wil
give problems further down the line with the forms and reports.
will assume you have created your tables with the fields you require
The simplest way to create forms and reports, is with the wizards
They will take you step by step through the creation process
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top