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

microsoft access

ResolvedVersion 2003

Steve has attended:
Access Intermediate course

Microsoft Access

How do you set up a macro

RE: Microsoft Access

Hi Steve,

Thank you for your question.

Open the database. Select Macro from the Database Objects and then click New.

Then choose the appropriate actions line by line.

I hope this answers your question.

Regards

Simon



Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.