I have a DB I use for training records at work.  The training records the
employees are trained on are called Standard Operating Procedures (SOPs).  
The SOPs are placed in categories.  There are 4 departments that perform SOP
training.  The table I enter the SOPs into is called ...

so I need to be on SQL server??

I have 1 main form with 2 subforms.  
1)Main form: has contract#(key), type (key)--this form displays info only.
2)Subform1: has contract#(key), type(key), line_item# (key)--this form
displays info only.

I have designed a few databases for my work.  I have been recently assigned a
new one that has me a little stumped.  I am looking for some suggestions as
to how to go about this.
Essentially, we have a training department that does training in the various

I am planning to move the data portion of a client's Access 2003 database
over to SQL Server 2005.  I realize that the client is going to need to
purchase the software (probably going with the workgroup edition).  My
question is this... I'd like to get the data and the front-end ...

I have a database setup to reference each of my clients, and would like to be
able to setup a field in my MDB that can contain a excel document to hold
dated information specific for each client.  I would want it to hold a varity
of numbers under each date.  that if possible ...

Is there a way to set a default format for new query fields in a database?  I
am fairly new to Access and recently completed a financial analysis project.  
Nearly every field I created was a calculated field and appeared without any
formatting.  It got to be REALLY tiresome to ...

I tried to import dbf file into MS Access and it looked good.  I notice that
the problem screw up my queries setting.  I notice that the field name has
few spaces (blank = xxxx).   See example:
example:

-- We would appreciate your suggestions for a tax database to track
preparation and filing of tax returns.
The basic account information is downloaded from our accounting system. That
would be one table. Then we would need a payment table and a filing

I have a form already called switchboard.  I imported it into my new
front-end database.  Access doesn't recognize it as a valid switchboard.  Is
there a way to set it as the default switchboard?  I hope I don't have to
start a new switchboard from scratch!  Thanks!

I am creating badges (name tags) and would like the status text box to have a
different background color depending on the registrants' status.  
something like:  =(IIF([Status]="C", ----------  set color to navy
-------------

I came across a problem in my application.  We wanted to be able to
sort Date/Time, whose entries included milliseconds.  However, MS
Access does not allow ms in Date/Time entry.  So this is what I did
(just thought somebody might find this handy)

I need to write a single SQL statement to alter the Required property of a
Long Integer Table Field (Column) from Yes to No.
I know how to do it in VBA, but this isn't an option in this case.
Thanx

Trucks deliver merchandise to our warehouse.  We need to track the date and
the boxes that were delivered by this truck.  The same truck makes several
deliveries so it's ID# cannot be used as a unique number.  The truck ID and
the date combined, however,  can be used as a unique ...

when I try to save an attachment from an email message there is no pulldown
menu for the save as file function.  How can I correct this