You have used databases to store and retrieve data. Now, you may want to plan, design and administer your own database. A well-designed database allows easy maintenance and quick access of data. In this course, you will plan, design, administer and create a functional and efficient relational database.

To Design and Administer a Microsoft® Access relational database.

• Employ design techniques in the design of a relational database
• Administer a relational database in a multi-user environment

Database Design techniques - Analysing client requirements - Create a preliminary design - Implement database design - Generate reports - Customise the database

 

Administer a Relational Database - Securing a database - Creating a workgroup information file - Joining a workgroup - Creating user and group accounts - Activating user logons - Setting object ownership - Setting database password - Encoding a database - Locking database records - Replicating a database - Backing up a database - Compacting and repairing a database - Splitting a database - Analysing a database - Converting a database - Setting Access startup options