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?

 

[bhicks11 via AccessMonster.com]

Hi Michael

Here's my 2 cents:

1. Yes many people can enter data at once. When you user base get too large,
you would probably want to upsize to a SQL Server back end.

2. There are different types of queries. A SELECT query just shows you the
data as you specify,
a MAKE TABLE query makes a table with the data you specify, an UPDATE query,
updates the table as you specify, a DELETE query, deletes as you specify.

3. A database is a collection of tables, queries, forms, reports, modules
and macros. I think you mean a table - yes the field names in a table must
all be unique.

4. A lookup wizard is a tool included in Access to design a lookup control
on a form. You can use a field that has photograph or video names in a
lookup criteria.

5. No you cannot change a field property with a query. You do that in the
table designer or VBA code.

6. Sorry - don't understand this question.

7. You can either use a query to return a multiple field sort or drag the
fields next to each other and sort.

8. Be more specific.

9. Don't know what dialog box you mean.

Bonnie
http://www.dataplus-svc.com

 

[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?