While I am not new to Access, I haven't used it extensively on a regular
basis.   I have received great help through this site, but was wondering if
any of you have recommendations of database design books.
I am about to embark on a new database, and am looking for a book that

Would like to eventually create a flowchart of my tables and their
relationships.
Any suggestions as to which program to use?  Tables in Word with arrows
pointing out the relationships?  

Am in the planning phase... should I use Word in outline view to create a
"blueprint" of what I would like to achieve?
Any suggetions would be greatly appreciated!

Is there a way to restrict entry of data to a field on one table
depending on what is in a column from another table..
So, my tables are:
table1

I am rewriting a database I started incorrectly and I'm stuck on trying to
move it to a "date driven" DB.  Basically I am creating a DB to track
projects (maintenance items), actual revenue (invoiced), forecasted revenue
(sales target - which is everchanging based on purchase ...

In trying to set up a new normalized table I need some help with this set of
data.
There are six fields to consider.
Item, description, and four dates that can occur with this item.  There is

I am currently using a lookup table to populate the values in a
listbox.
columns:
item_id        number

We have a combo box picking data from one table for input into another by
means of a form.  We would like another field to self-populate with
corresponding data in the table which is the source for the drop-down list,
depending on what is picked from the drop down list.

Hey guys,
I have a toughie here.
I'm creating a database for my Accounting Department.  The reporting system
that they use now is all done manually and I would like to lighten the load

I have created a database of training courses and trainees.
Table 1 = Course Data (course name, date, venue, trainer, invoice no. etc.)
Table 2 = Trainee Data (trainee ID, first name, last name)
I created a Course Data Form using Table 1 and included a sub form for

Access 2003
I have a 2 column Excel speadsheet, no row duplicates that I would like to
use as a lookup table in an Access db. I was able to import the spreadsheet
without problem and named it as one would expect. The first field is a

I have a datasheet subform that shows field names as headers of the
datasheet. I've tried opening the subform and making these not visible and
have also tried just deleting them but they still show up. Is there any way
to supress or delete these field name headers?

I want to put a control onto a form that will tell me if a record has a
matching record in another table.  I know I can use a query, the unmatched
query wizard (to see which records don't), and the find duplicates query
wizard (will tell me which records are duplicated in a table ...

have you got any pictures of squralls

I have a table that is already populated and I need to ensure the field does
not have duplicates. When changing the field to be Indexed with no
duplicates, it comes back with an error:
"would create duplicate values in index, primary key or relationship"