I am in charge of some stores in my school and it is my responsibility to
make sure that all items are accountable at all times. Before now, we have
used a book which the user signs to acknowledge that they have taken the item
out, and then I have to sign when the item is ...

I am trying to create a training data base.  My tables include one for
employees, one for departments,  one for training subject.  I need to be able
to tell when each employee was last trained in a particular subject, What
subjects are required for employees in which departments, ...

I need to generate a lab booking scheme that will enable students and staff
to book bench space for their work in a variety of laboratories. Doe anyone
have such a planner as the Access reservations template does not allow people
to book the same room at the same time!!!

This appeared to be the best place for this question as it has to do with
wanting to represent my table layouts.
I am an access 97 guy, just upgraded to 2003 for a project, have created
some tables and now want to use "Documenter" to create docs on the details of

I have a system that allows reporting from imported data. I keep a track of
what has been imported via a table called tblImportLog. The data itself goes
into tblImportData - this table has no possible unique key.
When a report is requested, I look in the log to see if the needed ...

I am looking to combine multiple tables into one table that eliminates
duplicates.

I am creating a database which will be used as a backend to an internal
website.
One of the table will hold data that our customers will fill in. This is
more like a questionarrie and about 6-7 questions are multiple choice i.e.

Is there a way to determine a table relationship, gather information about
the relationship in order to recreate it later. I'm appending data to some
tables, so I would like to drop the existing relationships, do the append
and then re create the relationships after. Can anyone ...

I have a database to track all employee applicants. There are three tables.
tbl #1 "Employee Applicants" :
         fields:  (1) ApplicantID - Autonumber (2) Name - Text
tbl #2 "Job Skills Categories"

I'm trying to understand basic design tradeoffs when using combo boxes. Can
anyone please tell me the pros/cons of:
1) defining a combo box in a table as a Display Control, rather than as a
bound control during form design?

I posted this question earlier but it is not very well thought out.
I am trying to figure out a normalization problem with some table in my
database.
Then main table in my database is tblCase_File there is a unique ID for each

I have a Case File management db.  There can be multiple clients in each
case file.  Each case file has a primary contact.  Each client also can have
separate addresses and address history.  It is possible that the Primary
Contact is not a client.

I am looking for advice on table and form design as they relate to database
performance.
I have a Main table with 48 fields.  To organize my data better and to
reduce the number of fields in the Main table, I created a Provider table (16

Is it possible to create a Double outter join in Access? If so, what would be
the easiest way to do so and what version of Access would i have to be
running?
Thank you in advance,

I'm dealing with a problem and need the easiest solution as possible. I have
several tables which have one field in common, let's call it ProductCode,
which is set as "Text" since it use alphanumeric data. The data for the
tables is obtained and pasted from Excel, but, when a code ...