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
Access Add In
Encrypting, Decrypting Database
Understanding Access Replication
Replicating Access Databases
Convert Microsoft Access
Access Tools Conclusion
Using Access Macros
Create Access Macro
Running Queries Macros
Available Access Macros
Consulting Database - Exercise
Download the Consulting Database
Download the Consulting database that will be used for exercises.
This exercise is worth a total of 1 point. The exercise is auto-scored, which means that all you have to do to receive credit for it is click the
button below. Follow these steps to complete the exercise:
Click the Resources button.
Find the “Course Downloads” section.
Click the Consulting.zip link.
Your browser will ask you what you want to do with the file. Choose to save it to disk.
Specify that the file be saved in the downloads folder. This is the default folder for Windows downloads. If you are using Windows you can also save it to your C drive.
Unzip the file by double-clicking it.
For the purposes of this course, we will assume that you have placed your course downloads in the My Documents folder. If you have Windows or MAC OS X you can choose to place it elsewhere, make a note of the folder name so that you can find it later.