About this Course

The course empowers the trainee to understand the basic concepts of databases and demonstrate the ability to use a database on a personal computer. 

The course introduces the skills required to design and plan a database using a standard database package as well as how to retrieve information from an existing database by using queries, select and sort tools available in the data-base. The trainee shall also be able to create and modify forms and reports.

This course prepares the participants for the Microsoft Office Specialist exam.

COURSE OUTLINE

Module 1.Exploring Access 2013

Module 2.Creating Tables

Module 3.Setting Field Properties

Module 4.Working with Tables

Module 5.Editing Tables

Module 6.Finding and Filtering Data

Module 7.Creating Relationships

Module 8.Using Simple Queries

Module 9.Using Operators in Queries

Module 10.Modifying Query Results

Module 11.Designing Advanced Queries

Module 12.Creating Action Queries

Module 13.Using Advanced Query Wizards

Module 14.Creating Basic Forms

Module 15.Manipulating Form Controls inDesign View

Module 16.Using Other Form Techniques

Module 17.Using Advanced Form Design

Module 18.Creating Basic Reports

Module 19.Using Controls and Layouts

Module 20.Using Editing Tools

Module 21.Using Advanced Report Design

Module 22.Using Advanced Database Features

PRE-REQUISITE

A basic working knowledge of Windows and older versions of Microsoft Access would be an advantage.

Rate this course:

Log in to submit

Comments