Description
This is 2-Day Microsoft Access training suitable for beginner and those people have desire to learn Access and create some kind of database management system.
Objective:
At the end of the training, participants are able to:
-
Create and design Access database solutions
-
Work with Access tables, relationships, keys and constraints
-
Write basic and advanced queries
-
Create and design interfaces with access forms
-
Create basic to advanced access reports
-
Perform database maintenance
-
Automate tasks with macros
-
Know database design concept
Outline:
-
Databases and Database Objects: An Introduction
-
Project- Database Creation
-
Designing a Database
-
Creating a Database
-
The Access Window
-
Creating a Table
-
Previewing and Printing the contents of a Table
-
Creating Additional Tables
-
Importing Data from other Applications to Access
-
Additional Database Objects
-
Database Properties
-
Special Database Operations
-
Querying a Database
-
Project-Querying a Database
-
Creating Queries
-
Sorting
-
Joining Tables
-
Creating a Form for a Query
-
Exporting Data from Access to Other
-
Adding Criteria to a Join Query
-
Calculations
-
Crosstab Queries
-
Maintaining a Database
-
Project – Maintaining a Database
-
Updating Records
-
Filtering Records
-
Changing the Database Structure
-
Mass Changes
-
Validation Rules
-
Changing the Appearance of a Datasheet
-
Multivalued Fields in Queries
-
Referential Integrity
-
Ordering Records
-
Creating Reports and Forms
-
Project – Reports and Forms
-
Report Creation
-
Multitable Reports
-
Form Creation
-
Mailing Labels
-
Multitable Forms
-
Project – Multitable Forms
-
Adding Special Fields
-
Updating the new fields
-
Multitable form techniques
-
Object Dependencies
-
Date/Time,Memo, and Yes/No Fields in Queries
-
Datahseets in Forms
-
Creating a Multitable form based on the many table
-
Advanced Report Techniques
-
Project -Advanced Report Techniques
-
Additional Tables
-
Creating Reports in Design View
-
Advanced Form Techniques
-
Project- Advanced Form Techniques
-
Creating a Form with Combo Boxes and Command Buttons
-
Creating a Multipage Form
-
Using the Arrange Tab on Forms and Reports
-
Macros and Navigation Forms
-
Project – Macros and Navigation Forms
-
Creating and Using Macros
-
Creating and Using the Navigation Form
-
Data Macros
-
Administering a Database System
-
Project- Administering a Database System
-
Microsoft Access Tools
-
Navigation Pane
-
Table and Database Properties
-
Special Field Properties
-
Creating and Using Indexes
-
Encrypting a Database
-
Splitting a Database
-
Database Design
-
Project – Design a Database
-
Entities, Attributes, and Relationship
-
Relational Databases
-
Database Design
-
Normalization
Duration:
2 days (14 hours)
Target Audience:
This course is designed with novice Access users, but serves as a quick reference for more experienced Access users.
Methodology:
Demonstration, practical learning, case discussion and exercises
Prerequisite(s) or equivalent knowledge:
Basic knowledge of computers, using the keyboard, mouse and windows is required.
More detail about Growthvue Management & Consultancy (M) Sdn Bhd
