Can anyone sugest a good desing tool for Modeling Access database
development?

Hi, I do not really have a good knowledge of reading and understandin
codes. Therefore, I seriously need some help here!!
First of all, I have this access database which consists of 6 differen
tables. The fields in these 6 tables do not consist of any primary key

I need to create a student/program relationship, based on the age of a
student.
If the student is over 13 then they are enlisted the a teen program.
If the student is under 13 then they are enlisted in the children program.

One question, has anyone come across such a case where the autonumber field
starts by issuing 2 as the initial number? This has been going on for quite
a while. I know that once you delete all (or even one) records from a table
with an autonumber primary index and do a "compact & ...

I have a client mail list. Recently a large portion
of it were assigned new zip codes.
I was able to seperarte them,but do not know how to
change them globaly.

I'm developing a db to track investment subscriptions for my company's
various offerings.  Subscriptions may be made either (1) by individuals or
(2) by entities, where an entity is simply a group of individuals.  It's
important to note that in the second case, the entity (not each ...

Thanks for all the help so far.
I have another snag.....
On a subform I have a field called txDate, with the following control
source.... =[Forms]![frmPersonnel]![txDateMain]

hi wondered if anyone could help?
I have an Access database in which I use 4 linked tables
(which are linked to Excel spreadsheets).  I have a query
pointing to two of the spreadsheets and a normal table.  

My database is for UK Census transcriptions.  I use a form with all the unchanging data on and a subform with the household data.  The census page is made up of twenty five lines of data with nineteen fields.  I enter this line data in Single Form View. When I start entering data ...

I really need help on this, and will be appreciate if some inputs can be
provided:
I have a student record database with the followings:
- Fields: student_name, math_score, math grade, english_score,

Just b4 I re-invent another wheel, I wonder of there are any Access 2000 (or later) templates developed for small clubs s, charities etc??

I'm trying to develop a db whose primary purpose will be saving values for a report to be printed.
In the vein of being a relational devotee I have a Report Table, an Agency Table, an Agent Table.  The Agent table saves the primary key of the Agency Table.  On the Report form, I ...

Access 97
I have a table that has one field that does not always need to contain a
value, but when it does contain a value I would like to have a validation
rule to make sure the value is appropriate for the field.  I tried putting a

I need to design a database for services request
I have designed a table which contain two date date columns and time columns
and two forms
One for recording the user request date and time automatically

I have a DB that I need to cascade the changes on as follows
Company
Contact
Job