Course details

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
Updated on 23 August, 2016

About ITBM

Instructional & Courseware Design

  • Customized CD Learning, e-Learning and Courseware for companies. Find out more now.

Office Workflow Automation

  • When running your day-to-day business, you realise that things can be made easier for you if the system is computerised. But how do you get started? More information here.
See all ITBM courses
Are you from ITBM ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Access starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or