|
|
 |
| |
|
|
|
|
| |
1. Introduction To MS Access
- Startup of MS Access
- Quitting MS Access
2. Database Concepts
- Examples of Database
- Six Types of Database Objects
- Open a database
3. Table
- What is Table?
- Opening an Existing Table
- Opeing Table in Datasheet View
-
Opening Table in Design View
-
When to use Datasheet/Design View?
-
Standard Table by Table Wizard
-
Designing a Customized Table
-
Setting Up Field
-
Setting Up Data Type
-
Setting Up Properties
-
Setting Up Field, Data Type & Properties by Expression Builder
-
Add/Delete/Move a Field
-
Setting Up Primary Key
-
Setting Up Index
-
Setting Up relationships
-
Add, Edit, Delete Record
-
Copy, Move Data
-
Find, Replace, Filter, Sort Data
-
Change datasheet layout
-
Set Up Table with Existing Data
4.Query -
What is Query?
-
Run a Query
-
Types of Queries
-
Creating Query
-
Standard Query by Query
-
Wizard
-
Designing a customized Query
-
Setting Up Type of Query
-
Select Query -Crosstab , Make-table , Update , Append , Delete , Union , through , definition
-
Setting Up Table, Query
-
Setting Up Join
-
Setting Up Fields
-
Other Options-specify criteria, sort records, calculate totals, set properties
5.Form
-
What is Form?
-
Open a Form
-
Creating a Form
-
Standard Form by Form Wizard (AutoForm)
-
Designing a Customized Form , Customize or delete a control , Enhancing Form-title, page number, header & footer , Subform, Entry - Specify condition
6.Report -
What is Report?
-
Open a Report
-
Creating, Modifying a Report
-
Standard Report by Report Wizard (AutoReport)
-
Designing a Customized Report, Customize or delete a control, Report - title, page no, header & footer , Sort, Group records/ Calculate totals, averages
7.Relational Database
8.Exchange data
-
Import or link data
-
Import or link Microsoft Foxpro or Dbase files
-
Import or link data from a spreadsheet
-
 |
|
 |
| |
Client Testimonial
"I recommend the Computer Training Center without reservation. The quality of the instruction is excellent. The instructors are very knowledgeable and flexible. They will work out the best course strategy for a busy executive with little time and a fast-changing schedule ...”
Ms. Michelle Comrie – Marketing Manager
"Very enjoyable. Useful material that can be applied for job & normal usage."
Mr Oliver So
"Covered all the basics I supposed. Lesson's easy to understand. Steps are clear. Instructions by teacher is super clear."
Ms Elizabeth Mak
more ...
|
|
 |
|
 |
|
|
| |
|
|
| |
頂點 |
|
| |
|
|
|
本課程共3節或1.5天全日。學費$2,200
截止報讀於開課前三星期
|
|
|
|
|
|
|
|
|
|
|
|
|
|
 |
|
 |
| |
 |
| |
Schedules |
 |
| |
 |
 |
| |
| WAC0082 |
19 Aug |
 |
 |
|
 |
| |
| WAC0081 |
25 Aug |
 |
 |
|
 |
 |
 |
 |
 |
|
|
 |
|
 |
|
|
|
|
|
|
|