Microsoft Access 2000 Designing and Implementing Database Applications Part 1 - Database Design

This is the first course in a five-part series that will provide IT professionals with the knowledge and skills necessary to design and implement database solutions using Microsoft Access 2000. At the completion of this course students will learn to identify the guidelines for selecting database architecture; create the key objects in a database application and generate outputs; identify the measures to secure a database.

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 8 hours Training Presented in: English

Audience

This series is designed for database programmers and developers who want to design and implement database solutions using Microsoft Access 2000. Participants should have completed Microsoft Access 2000 End User Series (Course Series 72050 - 72052).

Objective

• Basics of database designing and architectures and install Access 2000.
• Create the key objects in a database application and generate outputs.
• Identify the measures to secure a database.

Topics Include

Unit 1: Database Design: An Introduction

• Sequence the steps recommended to design an efficient database application.
• Group data into entities by applying normalization rules.
• Select an indexing strategy to optimize performance based on a specific situation.
• Specify the relationship between entities.
• Identify the foreign key in a table to ensure referential integrity.
• Match the criteria for data integrity with their functions.
• Identify the situations where the replication of data is appropriate.
• Identify the method of deploying a database based on a particular situation.
• Identify the guidelines for selecting database architecture.
• Match database architecture types to be used with specific situations.
• Identify the factors that affect the selection of a data storage architecture.
• Match data storage architecture to be used with specific situations.
• Match the features of Access 2000 with their uses.
• Install Access 2000 by using a CD-ROM on a Windows 2000 Server computer.

Unit 2: Database: Designing

• Create a database by using the Microsoft Access dialog box.
• Create a table in a database by using the Design view.
• Create a table by using the Table Wizard.
• Create an index by using the Design view.
• Import data from an external source into an Access 2000 table.
• Enforce referential integrity on the basis of specified requirements.
• Enforce data integrity in a table by using the Fields Properties section.
• Identify the guidelines for designing a form.
• Create a form by using the Form Wizard.
• Create a form by using the Design view.
• Identify the guidelines for designing a report.
• Create a report by using the Report Wizard.
• Create a report by using the AutoReport wizard.
• Create a report by using the Design view.
• Match the types of queries with the specific situations in which they are used.
• Create a query by using the Simple Query Wizard.
• Match the types of data access pages with the situations in which they are used.
• Create a DAP by using the Page Wizard.
• Create a DAP by using the Design view.
• Save the data present in a table to a hard disk.
• Export a table in a database to another application.
• Create a copy of an object in a database.

Unit 3: Database Security: Implementing

• Match the security measures that can be implemented for a database with their uses.
• Select the record-level strategy to lock records based on a specific situation.
• Set a password for a database.
• Encrypt a database .
• Create an account.
• Match permissions with the tasks that they enable a user to perform.
• Assign permissions to a user for a database object.
• Set the security options for a database by using the Security Wizard.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

• Microsoft Access 2000 Designing and Implementing Database Applications Part 2 - Handling Data
• Microsoft Access 2000 Designing and Implementing Database Applications Part 3 - Creating Application
• Microsoft Access 2000 Designing and Implementing Database Applications Part 4 - Debugging Applicatio
• Microsoft Access 2000 Designing and Implementing Database Applications Part 5 - Completing Applicati