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.
COURSE OUTLINE
Module 1. Exploring Access 2010
Module 2. Creating Tables
Module 3. Field Properties
Module 4. Working with Tables
Module 5. Editing Tables
Module 6. Finding, Replacing and Filtering Data
Module 7. Using Simple Queries
Module 8. Modifying Query Results
Module 9. Using Operators in Queries
Module 10. Relating Tables
Module 11. Creating Basic Forms
Module 12. Using Design View
Module 13. Creating Basic Reports
Module 14. Using Advanced Report Design
PRE-REQUISITE
An understanding of Windows / MS Access 2000 to MS Access 2007 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