Forum home » Delegate support and help forum » Microsoft Access Training and help » Append Query

Append Query

ResolvedVersion 2003

Thu 10 Sep 2009, 14:31 Delegate Kieran said...

Kieran has attended:
Access Intermediate course
Access Advanced course

Append Query

When should I use an append query?

Thu 10 Sep 2009, 15:50 Trainer Amanda said...

RE: Append Query

Hello Kieran

Thank you for your question and welcome to the forum.

An append query adds a group of records from one or more tables to the end of one or more tables, so it is used to update/add new records to an existing table.

For example, suppose that you acquire some new customers and a database containing a table of information on those customers. To avoid typing all this information into your own database, you could append it to your existing Customers table.

Kind regards
Amanda

Thu 17 Sep 2009: Automatically marked as resolved.

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Append Query

Append Query

RE: Append Query

Access articles

Access tip:

Choosing data types in Access