Microsoft Access Introduction Level

3 day; Instructor-Led

Course description

This course introduces the usage of Microsoft Access and database’s concept. Such as database designing, normalization, relationship, data’s component. Fundamental of program, create database file, create table create field and its operation, queries and how to manipulation.

Target Trainees

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

Course Outline

o Database’s Concept (in Brief)
  • Database Definition.
  • Type of Database.
  • Principle of Database Designing.
  • Database’s Terminology.
    - Entity and Attribute.
    - Normalization.
    - Relationship.
    • Type of Relationship.
    • Create Relationship.
o Fundamental knowledge of Program.
  • Program’s Component.
  • Toolbar.
    - How to use.
    - Troubleshooting.
  • Program’s limitation.
o Getting start Database.
  • Table.
    - View of table.
    - Create table.
    - Field.
    • Create.
    • Setting properties.
    - Entering data.
    - Delete Record.
    - Add new Record.
    - Filtering Record.
    • By Selection.
    • By Form.
    - Format Table.
  • Queries.
    - Definition.
    - Type.
    - View.
    - Create.
    • By wizard.
    • Blank queries.
    - Perform queries.
    • Search queries.
    • Calculate queries.
    • Create new field.
    • Field properties

Microsoft Access Intermediate Level

1 day; Instructor-Led

Course description

This course’s objectives are introducing the trainee to work with form, report. Type of form report, create modify form or report. Set properties to the form or report. Perform calculate in form or report. Work with control, naming control, and decision’s rule for using control.

Target Trainees

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

Course Outline

o Work with Control.
  • Type and its functions.
  • Naming rule.
  • Decision’s rule for using.
o Form.
  • Type
    - Columnar.
    - Tabular.
    - Mixed.
  • Component of Form.
  • Create and modify form.
    - Control source.
    - Create method.
    • Wizard.
    • Manual.
    - Properties.
    - Add field to form.
    - Add control.
    - Modify control.
    - Add calculate form.
    -Insert date and time.-
  • Create switchboard
o Work with Report
  • Type
    - Columnar.
    - Tabular.
    - Mixed.
  • Component of Form.
  • Create and modify form.
    - Control source.
    - Create method.
    • Wizard.
    • Manual.
    - Properties.
    - Add field to report.
    - Grouping data.
    - Add control.
    - Modify control.
    - Add calculate form.
    - Insert date and time
    - Insert page number.