Microsoft Access Design Admin

Introduction

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.

Aims: To Design and Administer a Microsoft® Access relational database.

Content

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