I want to create a table to hold Department,Division,Bank, Service, and
ServiceDetail fields.  There will be one Department for multiple Divisions,
Multiple Banks for each Division, Multiple Services for each Bank and so on.
Is there a way to organize this so I'm not entering the ...

In the middle of database design and need some advice - I am unsure if I
went down the right path...
In my DB, each customer has lots of information - fields.
Each customer has  contact info, Billing contact info, Device configuration

Hi I am starting to design a quotation / invoice system for a friend with
access and need a bit of direction on the way i should create the tables
with effect to the grouping and relationships
The guy is a plumber.

I have imported several fields from a 1000 record spreadsheet into an Access
table.  All of the fields but one have been  imported perfectly.  The
problem is with a column of serial numbers.  They are formatted as text in
Excel, and many of them appear correctly when imported, ...

I need  a way to prevent gaps caused by data entry errors.  Example:  I have
a control on my form where a contract number is entered.  The same contract
number may be identical on numerous records.  If one record has a gap in the
contract number caused by data entry errors, the ...

At present I have a database for my art works (in-house brewed myself).  In
it is a table with details of CG and drawn art works with linked thumbnails.  
(Still need to add entries per photo prints groups yet).  It also has
numerous queries ie keyword searches, folder contents ...

I want to run this thought by somebody if you don't mind since I am new and
I'd rather spend time planning than fixing.
I work for a nonprofit org and I am trying to transfer my donor database to
Access.  Many of my donors will give to more than one fund at a time.  So

I built a table use several fields with similar date; ex name 1, name 2; I
have lots of records in each field; how do I move the data from field Name 2
to Name 1 Field

(Sorry if this is a duplicate. Not sure if my first message posted...)
I am trying to design a multi-tabbed form that uses one selected field to
pull information into the various tab pages. I read that the field should  be
cut (Cntl X) from the sub-form of the first tab page and ...

Good Morning! I'm having trouble trying to get my mind around a database I
have to design for my boss, hopefully you guys can help... the structure is
stumping me as I haven't used Access in years. Here's my issue:
We have projects, and for each project we send a bid to multiple ...

I'm not quite sure how or why, but when I create a new table with a number
field it automatically rounds to the neareast whole number.
How do I disable the autorounding feature?

I have set up a database for service management. I have sent a copy of the
databases to all my regions and need to connect these databases at one place.
Can you please let me know whether this can be done and if so how do i do it.
Thanks

I have the perenial student marks database problem which I'm trying to solve
for the third time in a simple way.
In a nutshell, one table of students, one of student-classes, one of class
assignments and one of students-class-assignment marks

I have a table in use, that I am restricting to one record, which is used as
the total number of items (call them apples), to be considered for
calculations elsewhere on Forms and Reports.  I guess this is looked at as
an unbound field that remains constant for all calculations, ...

Does anyone know of a way of creating an auto generated/increasing in value
field (key) that uses chars instead of (or in addition to) Autonum e.g. GLAA,
GLAB, GLAC, GLAD...etc.?
Any ideas, views, comments or help would be very welcome.