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 is divided in two sections; the first section introduces the skills required to design and plan a simple database using a standard database package; the second section introduces the skills required to retrieve information from an existing database by using the query, select and sort tools available in the data-base. The trainee shall also be able to create and modify reports.
This course prepares the participants for the Microsoft Office Specialist exams.
COURSE OUTLINE
Module 1. Creating Tables
Module 2. Setting Field Properties
Module 3. Working with Tables
Module 4. Finding and Filtering Data
Module 5. Printing Data
Module 6. Creating Relationships
Module 7. Using Simple Queries
Module 8. Modifying Query Results
Module 9. Using Operators in Queries
Module 10. Designing Advanced Queries
Module 11. Using Advanced Query Wizards
Module 12. Creating Basic Forms
Module 13. Manipulating Form Controls in Design View
Module 14. Using Other Form Techniques
Module 15. Using PivotTables and PivotCharts
Module 16. Creating Basic Reports
Module 17. Using Advanced Report Design
Module 18. Using Advanced Database Features
Module 19. Using Access Database Security
Module 20. Exporting Data
PRE-REQUISITE
An understanding of Windows / Microsoft Access 97 to 2003 will be an added advantage.
Course Rating
- /5 from users
Course Enquiry
Course Info
- Course Provider COMAT TRAINING SERVICES PTE LTD
- Course Category Technology
- Course Price n/a
Comments