Is there any set order for creating tables, I want to create the following
tables
Labour, Products, Customers, Orders, Confirmation, Deposits, Invoice,
Payments and Container import, what would be the best order to set these up

i have two tables
  table 1 bank transaction
  field Deposit (currency)
    "    withdraw (currency)

I am importing to a table a large text file containing names.  This table is
then amended and the names exported to another text file
Many of the names are of European origin and have accent marks. as examples
(if they view correctly) á, ð, é, í

My current client has assigned an architect to design the data model for our
application. Our app requires a list of resources (people assigned to
projects). Our app also requires a list of users (people who use the
application). In the past, I've always created two separate ...

I have a database with the following tables.
Customers, Inventory, Price, order entry(order details), orders, and colors.
On order to reduce data entry errors, when the CustomerID is entered into
the order entry form, I wolud like for the business name, contact first name

I have two tables.  They have a one to many relationship.  When I use a form
to enter data into the main table, I need to also create at least on record
even if blank in the other table, otherwise I will not be able to edit or add
a new record to the smaller table.

I use information that I obtain from a working file from a different system.
I am interested in updating the infomation on a regular basis, but I am being
told that a Make-Table Query will not work because I have relationships built
onto the parent table.

I have a form when ever it is reopened form showing the first record
but insted i want the form to set for new record as it opened
how to do this please
balu

I'm working on setting up a BMP database for our town office, and I'm
trying to figure out the best way to construct the table. The gist of
it is as follows:
Each business owns multiple properties.

i have an Unbound form with two text boxes and many command buttons on form
 header
 i would like the following ones
 (1)as soon as the form opens an small diolog box (or an bound form )

How do you guys go about with your table design... how do you make
sure that it's right before proceding with the implementation/coding?
Any pointers for a beginner?  I've taken a class, but it's still a
painful process... Just wondering what you all think about this...

I just starting to use Access 2003 and will try to create some applications
for our office. I would like to know what the best way would be to open a
table using a switchboard button where it prompts a user for which field they
would want to look in and the value that they would ...

i have a two column combo box with one column for employee number and second
column for employee name. On the form both columns appear but i want to have
the employee number selected and the associated name appear in another text
box.How is this done?

can you hide relationships so they don't show?

First, this is a handful of question's I'm asking and I'm just asking for
suggestions.  I understand this is my puppy but some of these issues are
troubling me.
I'm updating an Access 97 database.  I'm working with a "contribution"