Here is a screen shot of the design for a database used
to track patients who are enrolled in one or more studies:
http://members.cox.net/kheisler6/patient%20study%
20database.jpg

First, am I in the right forum? I am new here and have not worked with
Access for a few years. So this question might sound stupid to you but
bear with me, please...
My boss at work wants me to design something like this. Is this

Is it possible to put a descriptive text in a field
designated for OLE?  For example, all my entries in the
OLE field say "Adobe Acrobat Document" and i would like to
describe each document in that space.

I am attempting to create my first database for my job and
I have run into my first problem.  In the database there
should be a field that includes the client's account
number, however most clients have more than one account

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

I have a basic question but for some reason I cannot find
where to turn off the auto number feature, so that if I
am in a field in table and entering a number, and then go
to the next record (same field) sometimes the next may be

Is there some value in increased performance using a numeric key vs. a
text key?
I have an Employee ID key in a database that contained four digits and
was defined as Numeric (Integer).  We are about to add a new companies

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

Would appreciate easy way to join or combine 2 tables
created from query to create 1 table.
Each table has the same number and field names with some
different info within some fields. One table has primary

I am writing a database where the primary key is going to
be an internal system number such as ITS0000001. I am
trying to get the field to auto increment that field but
i can't figure out how to do it.

When I try and open my report it asks for me to enter
in 'Parameter Values' first.  I didn't create them.  Does
anyone know how to remove them?????

In a table, There are Numeric, date  and text fields,if I open table
using the UI and enter a new record leaving the
Numeric and date fields empty, It can insert records into a table.
But It can't insert a record into the table using INSERT INTO statement

I have a table that I use to reprint a 'form' (report).  I
have added columns in my table for each row, and the added
columns should contain the same info. over & over.  I
can't for the life of me remember what I did last year to

My formal database education (a graduate school course in an Information
Systems program) armed me with the wisdom to put a lot of effort into table
design and normalization before implementing the database, and I follow this
approach religiously.  Choosing proper key fields is an ...

I have text I need to repeat on every line of an 81,000
row table....
Copy & paste doesn't work.
I need to know where & how I can 'fill in'/append/update