can someone tell me how to create subcatagories/subfields/drop fields in access

Hello -
Access 2003, vista
I've an application that runs tests report. each test is a different report
with its own info, and some times different report (3 different reports

I am creating a database and I would like to create a unique primary
key by combining part of one field with another.  For example, in the
last name field is the name SAUNDERS and in the last four field are
the numbers 1234.  I would like to take the first two letters of my

Hoi Math
Nieuwe moyennes voor Verroest worden als volgt:
     A. de Beer **) 2,89 86 3,17 95
     H. Mathijsen **) 2,00 60 2,20 66

I have developed an Access Database application system for processing claims
for my company. I then split the database and replicated the data portion of
the split-database.  I am the owner of the master (located on the network),
plus I have a replica on my notebook.  I also ...

I am new to access and want to build what I think should be relatively
simple.   My customer wants a training database that contains  Employee ID,
Name, Position, Date Hired, and Courses taken.    He wants to be able to do
two things.

I’m working on a db and I’m stumped on how to design.  There are approx 1800
structure numbers that are inspected at least every other year.  Each
structure has varying levels; one structure can have 3 levels, the next 18
and the next can have 122 etc.  During the inspection, ...

I have 3 tables linked together.  Customer, Fillers & Service.  All three are
one to many.
I'm trying to change the name of two or three fields in the Service table,
but it causes a pop up when I open the database.  I tried to delete the field

I am setting up a series of look up tables.  Users will be restricted to the
lookup table list via a combo box in a form.
the data being listed is text.  On my lookup tables is it better to have an
auto generated primary key and the text in a 2nd column or is it ok to make

I'm setting up an inventory movement table to track parts. Within the table
are fields for (among others)  part number, transaction type and quantity. I
need to show a quantity on hand. Can I have a QOH field based on quantities
added or subtracted in the quantity field in this ...

I am trying to set up a database for employee training records.  So far I
have set up the tables I will need:
Work Instructions : Lists all (200+) work instructions, which serve as our
main training tool, the document# serves as the primary key and 3 fields to

Would it be possible to drag and drop an Outlook email (as object or link)
directly from Outlook into a field (of some kind) in an Access Database?
Thanks in advance and regards

Good Morning all
I’m developing a db for optician’s patient records.  Part of the db is to
select and print letters to remind patients that an eye test is due and book
an appointment when they respond or if they fail to respond, to send a 2nd

Ok, here goes…..
Working in Access 2003, I made a database for all of the invoices that come
into my department.
For a Primary Key, I used a field called ID, with AutoNumber for the data

I need add a few fields in my table.
For some reson that I can not have all my users log off the systems.
I just wonder to create a one to one relationship table to add fields
and use same primary key and use join when I need the fields.