Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Access Training and help » ms access courses - Access

ms access courses - Access

ResolvedVersion Standard

Mon 23 Apr 2007, 09:41 Delegate Jane said...

Jane has attended:
Access Introduction course

Access

How do I use Filter by form

Mon 23 Apr 2007, 10:16 Trainer Richard said...

RE: Access

Jane,

Filter by form allows you to specify criteria you want to search by. Almost like a query, but using a form. When you click on the filter by form button, the window changes to a tabular form which you can specify one or many criteria. When you click the filter button, the filter will be switched ON. When you click on the filter buton again, then the filter is switched OFF and you see all the data again.

Regards

Richard

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

ms access courses - Access

Access

RE: Access

Access articles

Access tip:

Copy a Previous Record's Values to a New Record