microsoft+access+course+london - Query

Resolved · Low Priority · Version Standard

Wed 7 Feb 2007, 10:09 Delegate Vicky said...

Vicky has attended:
Access Introduction course

Query

What is a query? Is it Access-specific terminology?

Wed 7 Feb 2007, 10:54 Trainer Garry said...

RE: Query

a Query is a question which you ask your database
Microsoft Access supports many types of queries. Here is a description of the major categories:

Select Queries
Retrieve records or summaries (totals) across records. Also includes cross-tabulations.
Make Table Queries
Similar to Select queries but results are placed in a new table.
Append Queries
Similar to Select queries but results are added to an existing table.
Update Queries
Modify data in the records.
Delete Queries
Records are deleted from a table.

it is not Access-specific terminology

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips

microsoft+access+course+london - Query

Query

RE: Query

Access articles

Access tip:

Choosing data types in Access