I have never used this package and now need to create a database of hundreds
of addresses etc.
I have been asked to update one that has been provided to me using Excel.
Which is the better package to use Access or Excel?

My library database includes a form (frmBooks) that contains a field
which indicates the location of the books. If locationID =1, books are
in the Main Library; if locationID =2, they are in the Resource Center.
I've used an option group to filter frmBooks so that the librarians ...

Hi.  I hope I am in the right place!  I am new to Access, so bear with me.
I had a programmer design a db for me, with forms, and queries.  He is not
available now.  I have a form where one field on the form will not allow me
to enter information into it, nor will it display any ...

B4 I start I want to thank all of you that spend time answering all the
questions we New useres come up with. I have several dates in a table in a
field called "Date".  I have an expression on another field that will tell me
what the date will be 90 days from that date. ...

Just starting to use access and this intriges me already:
Is it possible to sum a date/time field in a querie to a number greater then
23:59 ? In excel I use brackets  [hh]
And in access ?

When I create REPORTS pulling data for a certain field, the unassigned data
doesn't print on the report.
For example, I have a Household Inventory database and I created a REPORT
that lists the inventory by BENEFICIARY.  If there are items in inventory

All of my calculated fields are working properly, however I need to keep
these values in the table for analysis later on. I can't figure out a way of
doing this.

Is there a way of storing a global variable, suach as a month/year so that i
can use that in reports and queries without having to declare/change it in
every instance
Cheers

i have this table that has approx 1000 records in it. the trouble is in one
of the fields (called Fault) there has been data imported into this field
(memo type)
the problem is this data has carriage returns in it. and it is all a big mess.

I have two tables one is called Questions the other is called ansers the
primary key for each table is an ID field generated by AutoNumber.  The
question ID and answer ID are linked in the relationships section.  
On a form I want to display all the questions a total of 170 in ...

I am using combo boxes (4) to populate the criteria for a query. Users can
select by Industry (legal, medical, computer, etc) Occupation (programmer,
doctor, attorney ...)  Type (corp, individual, partnership...) and City.  The
users now want to use the first three, and have City ...

I have been unsuccessful in creating a "data entry" form for a database I
have been working on.  Is it incorrect to use the same Field as your Foreign
Key in several tables.
Ex. 3 tables - Company, Company Locations, Company Contacts.  Both the

How do I go about creating a database where so that when a student wants to
register for a class, a list of dates offered for the class can be shown and
selected.  Also, what is the easiest way of recording the classes, so that if
the dates needs to be changed or cancel, it can ...

Is there anyway to run a query from a text box?

Hello to all.
What I need is this. I have a field (F1) in a table (T1) in which data as
sentences are entered. I need to change some words in these sentences for
example, in any entry that has the words "European Union" I want to change