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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Access

Resolved · Low Priority · Version 2003

Reply Wed 18 Mar 2009, 16:41Delegate Vassilena said...

Vassilena has attended:
Access Introduction course

Access

how do I create a macro in access?

For upcoming training course dates see: Pricing & availability

Reply Mon 23 Mar 2009, 11:12Trainer Simon said...

RE: Access

Hi Vassilena,

Thank you for your question.

To create a macro in Access, you need to go to Macros on the Objects list and then click New.

The next step is to select an action and then set the properties for that action. An example of a macro might be pinting a Form in Design view and then assigning the macro to a command button.

I hope this answers your question.

Regards

Simon

Access articles

· Microsoft Access 2007: New Features
· Microsoft Access Flaws and Ways to Overcome Them
· How Reorganising Your Data Can Take Your Business to the Next Level
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· User-Proofing Your Access Database: Part 1

Please browse our web site to find out more about
access database courses and other Microsoft training courses.

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy