My database is going to contain information of around 70 counties.  The
county data will consist of 4 or 5 fields and I will use other tables and
queries to interact with the county data.
My key question is this:  should I keep all of the county data in one huge

So I have a list of agents that cover different areas and I want to track
what areas they cover by city and by zip code.  I've got 3 tables right now,
the list of agents and their info (phone number, etc.) a list of zip codes,
and a list of cities.  I want to link them together ...

What are the advantages and disadvantages of making the fields of a table
indexed?
Is there any difference when making a yes/no field indexed?
Thank you

I see a lot of threads out there about how to split a database, or installing
user-level security....
What I'd like to do is the following -
There's a functional area that keeps contact information up to date for a

I am trying to build a database to calculate and track employee bonuses
throughout the year. Bonus data is calculated weekly. My question is: How do
I track weekly information in the database? Is there a good way to use a
calendar object to automate the tracking of week1 through ...

Okay, so I come back from my first design Access class where I'm told it's
best to standardize the way to name my fields, tables and other objects,
i.e., fields should be "WithoutSpaces", tables should be 'tblLikeThis', etc.
I want to get my existing table to conform with this ...

I've got a report that runs billing info on all customers (using a query, not
a table).  I want a button on my customer form that will open the report in
preview mode, but with only that customer's info.
I did something similar years ago with an openform, but I'm not sure how I

Hi there, can anyone help?
I have created a few tables with fields called...
Table: Country
Field: idCountry (Auto Number)

windows 2000
Office 2000 with all service packs
Split database
I have a table that I want to keep hidden.  However when I make

Is there any code that has previously been written that quits the current
access program application after some set time of non usage by the operator.  
Ie. If the operator fails to use the program for say 20 minutes the access
application shuts down!!   Is there such a program ...

Good Morning,
    The information below is from an older post and I was wondering if
someone could help me figure out exactly how to perform this task. My
questions are:

Can someone please tell me if this is this a six of one situation or
not?
A db is now set up with one main table housing ID numbers, names, and
grade numbers.

Does anyone know if this is possible:
I want to create a form that will add a new record to a table that has only
one field, eg category; and I want these to be listed alpahabetical.  
However, there are four categories that I always want to be at the bottom of

in a table i have a descrition code and a description
i.e.
1-a long chain of char
2-a second long chain of char

I am working on a database that will be tracking customer payments.  The
customer will be charged simple daily interest.  I need to have a way to
calculate the number of days between payments in order to determine the
amount of interest to pull out of each payment.