Course details

The course provides the learners the basic concepts of databases and to demonstrate the ability to use a database on a personal computer. The module is divided in two sections; the first section, to design and plan a simple database using a standard database package; the second section requires the learners to demonstrate that he or she can retrieve information from an existing database by using the query, select and sort tools available in the data-base. The learners shall also be able to create and modify reports.

COURSE OUTLINE

  • Module 1. Exploring Access
  • 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. Using Simple Queries
  • Module 8. Modifying Query Results
  • Module 9. Using Operators in Queries
  • Module 10. Creating Relationships
  • Module 11. Creating Basic Forms
  • Module 12. Using Design View
  • Module 13. Creating Basic Reports
  • Module 14. Using Advanced Report Design
Updated on 03 September, 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