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 2010

Module 2. Customizing the Navigation Pane

Module 3. Creating Tables

Module 4. Setting Field Properties

Module 5. Working with Tables

Module 6. Editing Tables

Module 7. Finding and Filtering Data

Module 8. Creating Relationships

Module 9. Using Simple Queries

Module 10. Using Operators in Queries

Module 11. Modifying Query Results

Module 12. Designing Advanced Queries

Module 13. Creating Action Queries

Module 14. Using Advanced Query Wizards

Module 15. Creating Basic Forms

Module 16. Manipulating Form Controls inDesign View

Module 17. Using Other Form Techniques

Module 18. Using Advanced Form Design

Module 19. Creating Basic Reports

Module 20. Using Controls and Layouts

Module 21. Using Editing Tools

Module 22. Using Advanced Report Design

Module 23. Using Access Database Security

Module 24. 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