Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Programming for your own use by MS Access

Video Introducing this tutorial

Introduction to the Course :
Welcome
Download Resources involved in all training steps


Why Database and How to make it right :
Difference between Database and non database
Test for basic knowledge about Database
1 question


Data Mining :
Access Filtering
Query Filtering 1
Query Filtering 2
Query Filtering 3
Group and summary 1
Group and summary 2
Normal Calculation
If Then Else
Date Conversion
Quick Matching and Join direction
Excercise 1 : Data Mining and Join Test


Normalization - 4 basic concepts :
Normalization
Normal 1 No typing allowed for Repeated Data
Normal 2 Vertical Thinking
Normal 3 Split Data into Header and Details for 'One to many' statement
Normal 4 Details out all valuable data


System Analysis and Program Design :
Variable Naming
Gathering all data needed on Excel
Utilized Normal 2
Utilized Normal 3
Utilized Normal 1
Exercise 2 : Design Practice


Table/Database :
Configure Setting
Create Table
Give ID Key to all tables
Adjust Data format and Create Dropdown 1
Adjust Data format and Create Dropdown 2
Adjust Data format and Create Dropdown 3
Relationships
Quiz 2
7 questions


Form - User Interface :
Form Introduction
Form assign
Good Forms must created from Query
1 Single Table Form - Form View
2 Single Table Form - Datasheet View
3 Single Table Form - Pop Up Form
4 Mother and Child - Form View
5 Mother and Child - Datasheet View
Exercise 3 Form Assigned
Quiz 3
3 questions


Automation :
Search or Filter from Form View
Search or Filter from Datasheet View
Double Click Set Value
Quiz 4 Code test on Automation
2 questions


Report :
Query Report for Trace and Track Part 1
Query Report for Trace and Track Part 2
Export Data to Excel for Pivot Summary
Printed Forms Part 1
Printed Forms Part 2


Manage Program :
Create Switchboard
Compact
Backup and Delete Old Data
Quiz 5 Compact
1 question


From Standalone to Network :
Network Conversion
Adjustment after program implemented
Quiz 6 Network concerned
1 question