RelationalDBDesign
SiteMap
Data Manipulation
Access Features
Building Database
Tables Queries
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Access Tools
«Prev
Next»
Access Features
Define Database Relationships
Different-types-accessRelationships
One-to-One one-to-Many
Many-to-many Relationship
Referential Integrity Access
Cascade Update Delete
Referential Integrity
Working With Web
Using hyperlinks Forms
Data Access Pages
Data Access Types
Create Grouping Style Page
Working With Web Conclusion
Access Tools
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
Access Macros
Create Access Macro
Assign Macro
Running Queries Macros
Available Access Macros
Macros Conclusion
Replicating Access Databases - Exercise
Course Project: Replicating a Database
Objective:
Replicate a database.
Exercise Scoring
You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the
Submit
button to receive full credit.
Background/overview
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 are working on a database on your company's network, but you need to work on it at home for the afternoon.
Download Files
For this exercise, download a new database called ReplicatedExample from the Resources page.
Instructions
Download and make a replicated version of the ReplicatedExample.mdb by using the Briefcase. Next, double-click the replicated version in the Briefcase.