I need help with a my database design setup.  
I was hoping someone can recommend a book or a website
that has a lot of examples of different database designs.
I'm hoping one of those examples can be applied to my case.

I need help with a problem that I have.  My database holds information about items that are for hire.  I want to make items that are selected from my combo box unavailable until they are returned from hire.  My question is : - How do you make an item appear greyed out when it has ...

I currently have a table with nothing but checkboxes which
correspond to different field names
ie.  Letter sent
     yes/no

I'm in the very beginning stages of developing a database that will
develop serial numbers for a company.  I've used Access in the past,
but have never had to use modules before and so have never had to
program in vba, although I do have some programming experience.

I'm building my first useful data base and need some help auto filling
my table based on the Lookup function.  Please help me with this
example.
I have a table with customers "Customer Info"; columns are: cust ID,

I am trying to record time data related to the number of
hours,minutes and seconds it takes for various events.
Are there ways to format time data other then the Time of
Day?

I have two tables in a database. One table with about 3000 names, another
one with 500 names. I want to create a third table with 2500 names, being
the 3000 from the one table, minus the 500 names from the other table, how
can you do this?

Using MS Access 2000 how do I retain boolean values
following changes to those values at a later date? ie if I
link a checkbox control in a form linked to the value in
another form and subsequently change the parent boolean

I am designing a database and I want the primary key of the main table to be
the primary key of the other table to allow for tracking information between
the tables.  Can this be done and if how?  I appreciate any information in
the answer of my problem.  Thank you in advance

If dbs is a database, what does the value of  
dbs.properties("build") mean?

I have this Access database comprised of books.
Authors and Titles tables, with an author/title linking table in
between. All good.
As it currently stands, the authors of the books are the actual

What is the maximum no of records allowed in an access
database table? I'm sorry if this is rather basic question
but I have been unable to find the answer anywhere.
Thanks, Phil

I have two tables. One is SalesByMonth and the other contains CreditsByDate. The sales table does not use a full date only the month. The CreditsByDate has a full date (i.e. 1/21/04.) I can't  build a query using both tables unless I first establish a relationship. How do I link ...

Please excuse the basic question....I'm not entirely new to Access, jus
fairly new to doing calulations or default values within Access. In th
past, I've done all my coding work in a web page that accesses Acces
DB's. So I'm green when it comes to Forms & Reports. I've mostly jus

Hi Group,
I have set up a table with organizational data.  I wish to represent the relationship of the organizations as they exist in a hierarchy.  I have placed a such information in other fields such as the Level that the organziation is at in the hierarchy as well as the parent ...