Questions about access

[michael]

Hi I just have a few questions. All of which are about access;

-Can many people enter data into the database? Or can it only be done by one
user?
-Are query results automatically stored in the database?
-Do all the field names need to be unique within a database?
-Does the lookup wizard allow field values such as photographs or video
images?
-Does access provide query capabilities that allow updating of field
properties of the tables in a database?
-If I check the show box for a field, does it display in the results window?
can multiple fields be used as sort keys using the sort buttons no matter
where they are in relation to each other?
-Does the aggregate function preform arithmetic and statistical operations
on records I select?
-If I click the active sheets option buton in the print dialog box, are only
the active sheets printed?

 

[Douglas J. Steele]

Hi I just have a few questions. All of which are about access;

-Can many people enter data into the database? Or can it only be done by
one
user?

Out of the box, Access is multi-user. However, to do it properly, your
application should be split into a front-end (containing the queries, forms,
reports, macros and modules), linked to a back-end (containing the tables
and relations). Only the back-end should be on the server. Each user should
have his/her own copy the front-end, ideally on his/her hard drive.

-Are query results automatically stored in the database?

Queries are snapshots of the data that's in tables. Nothing is stored.

-Do all the field names need to be unique within a database?

Field names only need to be unique within a table.

-Does the lookup wizard allow field values such as photographs or video
images?

Not only does the lookup wizard not work with images (to the best of my
knowledge), it shouldn't be used with any data.

See http://www.mvps.org/access/lookupfields.htm at "The Access Web" for some
of the reasons.

-Does access provide query capabilities that allow updating of field
properties of the tables in a database?

Not as a query, but it can be done using VBA.

-If I check the show box for a field, does it display in the results
window?

I have no idea what this question is asking.

can multiple fields be used as sort keys using the sort buttons no matter
where they are in relation to each other?

The Sort button is really for light-weight use. If you've got more advanced
requirements, use queries. In a query, you can sort however you like.

-Does the aggregate function preform arithmetic and statistical operations
on records I select?

I don't believe there are any statistical operations defined, but you can
use them to sum or count records or determine the mininimum or maximum value
in a set of records.

-If I click the active sheets option buton in the print dialog box, are
only
the active sheets printed?

There's no such thing as "active sheets" in Access. Where are you seeing
such an option?