Microsoft Access

Duration :

2 days ( 9am – 5pm )

Medium :

English & Bahasa Malaysia

Register Before:

–

Who should attend:

Anyone who want to advance their skill set by learning the database software

• Easy to install and use — Access gives data managers a fully functional, relational database management system in minutes. Like many other Microsoft applications, Access contains Wizards that walk you through each step of the way. The user interface is intuitive; accelerating data information retrieval.
• Ease to integrate – Access works well with many of the developing software programs based in Windows. It also can be used in the front-end as back-end tables with products like Microsoft SQL Server and non-Microsoft products like Oracle and Sybase.
• Widely popular — Microsoft Access is the most popular desktop database system in the world.
• Convenient storage capacity – A Microsoft Access database can hold up to 2 GB of data.
• Multi-user support – About ten users in a network can use an Access application.
• Importing data — Microsoft Access makes it easy to import data.

Adult learning approach: Course consists of interactive lectures, individual and group activities, role plays, and mini-case studies relating to real life practical situations

DAY 1 : BASIC

Unit 1: Getting started

• Topic A: Database Concepts
• Topic B: Exploring the Access environment

Unit 2: Databases and tables

• Topic A: Planning and designing databases
• Topic B: Exploring tab les
• Topic C: Creating tables

Unit 3: Fields and records

• Topic A: Changing the design of a table
• Topic B: Finding and editing records
• Topic C: Organizing records

Unit 4: Data Entry rules

• Topic A: Setting field properties
• Topic B: Working with input masks
• Topic C: Setting validation rules

Unit 5: Basic queries

• Topic A: Creating and using queries
• Topic B: Modifying query results and queries
• Topic C: Performing operations in queries

Unit 6: Using forms

• Topic A: Creating forms
• Topic B: Using Design view
• Topic C: Sorting and filtering records

Unit 7: Working with reports

• Topic A: Creating reports
• Topic B: Modifying and printing reports

DAY 2 : INTERMEDIATE

Unit 1: Relational databases

• Topic A: Database normalization
• Topic B: Table relationships
• Topic C: Referential integrity

Unit 2: Related tables

• Topic A: Creating lookup fields
• Topic B: Modifying lookup fields
• Topic C: Subdatasheets

Unit 3: Complex queries

• Topic A: Joining tables in queries
• Topic B: Using calculated fields
• Topic C: Summarizing and grouping values

Unit 4: Advanced form design

• Topic A: Adding unbound controls
• Topic B: Graphics
• Topic C: Adding calculated values
• Topic D: Adding combo boxes
• Topic E: Advanced form types

Unit 5: Reports and printing

• Topic A: Report formatting
• Topic B: Calculated values and sub reports
• Topic C: Printing
• Topic D: Label printing

Unit 6: Charts

• Topic A: Charts in forms
• Topic B: Charts in reports

Download Brochure