Course details

This course enables the participant to operate effectively at more than a basic level of competence and be able to realize much of the potential of the database application. The participant shall be able to use the database to organize, extract, view and report on data using what are deemed to be advanced data management skills. The participant shall understand the variety of ways that data can be related and organized. In addition the candidate shall be able to run and record simple macros and to import, export and link data.

COURSE OUTLINE

  • Module 1. Designing Advanced Queries
  • Module 2. Creating Action Queries
  • Module 3. Using Advanced Query Wizards
  • Module 4. Using Advanced Form Design
  • Module 5. Using Advanced Report Design
  • Module 6. Using Subforms/Subreports
  • Module 7. Using Other Form Techniques
  • Module 8. Creating Macros
  • Module 9. Using Macros
  • Module 10. Using Advanced Database Features
  • Module 11. Exporting Data to Excel and Word
  • Module 12. Replicating Database
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?

Didn't find what you were looking for ?

or