Define Database Relationships
Referential Integrity Access
Cascade Update Delete
Working With Web
Using hyperlinks Forms
Data Access Pages
Data Access Types
Create Grouping Style Page
Working With Web Conclusion
Microsoft Access Security
Working With Startup Dialog
Encrypting Decrypting Database
Understanding Access Replication
Replicating Access Databases
Using Access Macros
Create Access Macro
Running Queries Macros
Assigning Macros to Controls on a Form - Exercise
Creating a macro and assigning it to an event
Create a macro and assign it to a command button's OnClick event.
You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the
button to receive full credit.
Recall that you are the Access database administrator for the marketing and documentation departments of companies in the software and networking business.
For one of your large clients, you need to create a switchboard for your application.
As we stated in the first module, the Consulting407.mdb database is available as a compressed download file available on the Resources page. If you've already downloaded the database, continue to work in that version.
Using the project database Consulting407.mdb:
Create a new macro group called FormMacros.
Create two macros in the group which open the Clients and Projects forms respectively. Name them OpenClients and OpenProjects.
Save the macro group.
Create an unbound form.
Place two command buttons on the form you just created, with the Caption properties set to Clients and Projects.
Set the OnClick events to the macros created.