If I have a normalized db which needs to be updated with flat files from
Excel, what's the best way to update?
The Excel flat files are obviously not normalized, so it's not a simple
matter of doing a paste append or import to an existing table.

Which object takes up more memory form, report, or table.  I have a database
that is 2GB which I am looking to split.  I am wondering what is the most
efficient, in terms of memory, to break it into at least 2 other DBs.  Any
help would be appreciated.

I am a software trainer who is relatively new to Access 2003. I met with a
department head who’s very concerned about her people, who are not proficient
with Access, browsing through records and inadvertently changing data. She
wants to set up Access 2003 so they must make an ...

i want a front page that will take me elsewhere on the document

I have three tables from a Purchase Order database:
tblComponents
ComponentID (PK)
tblPODetails

I am trying to set up a database where users can enter a classification and
size and have access calculate a total cost. There are multiple
classifications such as 7.50A, 7.50G, 7.50F, etc. There are also size ranges
for each classification and an associated cost for each range. ...

I copied my database to a test area and during some table renaming in the
test database I lost all the links between the tables in the relationships
diagram. The renaming was only temporary and all the original tables exist
again but the links are still missing.

I have recorded a print macro but now need to assign it to a button. How do I
create the button to assign the macro to?
Thanks

Something just dawned on me and I was wondering if anyone could help
me.  I am designing a work breakdown structure database.  I have a
table with several optional fields.  If these fields are null, I know
that that the record is just an element.  If they are not null I know

I have four tables: one is tlbPurchaseOrder, one is tlbLineItem, one is
tlbAttribute and one is tblComponent.
tblPurchaseOrder has a one to many relationship with tblLineItem.
tlLlineItem has a one to many relationship with tblAttribute and

I think I'm really breaking the rules here.  I asked a related question
a couple of weeks ago, and was told that it was ok, but this may tip
things over the edge.
I have a table that is filled with nulls and includes calculation

I have a form set up much like the Northwinds invoice form with a subform
linked dispayed and modified in table view to a main form. What I have been
asked to do is to set up the form so that individual words can be
highlight/bolded/etc. Is there a way to design the text fields ...

I'm creating a form that has user options to generate a report.  One text box
has Incoming, outgoing and TD options.  The other box has Open, Closed, No
Requirement, and All.  I developed reports for whatever option the user
chooses.  Depending upon which options the user chooses ...

I am working on a Data base for Travel Unit where I work.
I have designed a  Five Tables,Quaries and Forms .
Now I want to desing a switch board to hold all these forms, which should be
open with a command bottons.

Can a value in one field be determined & populated as a result of a
certain value in another field?
Table = Facility Information
1. Field Name = Building Status