Microsoft Access Advanced Level

2 day; Instructor-Led

Course description

This course for the trainee who had attended Microsoft Access Intermediate Level and had the experienced on create Form, Report, Table, and simple queries. The aims of the course to introduce Advance queries, Action Queries, Specialized Queries. Managing Database. Securities Database, and Automated Database system with Macro. Customize Toolbars and Menus. Create Webpage.

Tuition's Method

- Workshop training 1 trainee/ 1 PC Set.

Target Trainees

- Trainee who had attended Microsoft Windows Course, Microsoft Access Intermediate Level, readable English, fluent typing.
- Personnel Officer, Marketing Officer, Accountant, Student, Teacher, MIS EDP and IT Officer.

Course Outline

o Perform Advanced Queries.
  • Crosstab query.
  • Find duplicate records.
  • Find unmatched records.
o Perform Action Queries.
  • Delete query.
  • Append query.
  • Update query.
  • Make – Table query.
o Perform Specialized Queries.
  • Parameter Query.
  • Total Query.
  • AutoLookup Query.
  • Join Query.
o Database Management.
  • Managing database objects.
  • Managing database file.
  • Optimizing database performance.
  • Import and export data
    - Type
    - Link
o Managing Security in a Database.

  • Setting a database password.
  • Managing the Workgroup. 5.2.1 Create User and Group Account.
    - Set User and Group Permission.
    - Encrypting and Decrypting a Database.
o Automated Database with Macro
  • Definition of Macro.
  • Type of Macro in Microsoft Access.
  • Event work with Macro.
  • Debug Macro.
  • Convert Macro to VBA.
o Customized Toolbars and Menu