Microsoft Access 2002 Introduction (Cantonese)

 

Chapter: Name: Description:
101 Start Access 2002 (5"00')  How to start Microsoft Access 2002 program 
102 Database components (5"00')  Study Microsoft Access 2002 components.
103 Creating a database (5"00')  How to create a database 
104 Saving the database in Access 2002 version (5"00')  Study how to save the database in Access 2002 version.
105 Change File Default (5"00')  Study how to change default of database file format.
201 Entering data in a datasheet (5"00')  Creating a table by entering data in a datasheet.
202 Using table wizard (5"00')  Creating a table by using table wizard.
203 Design in design view (5"00')  Study how to create table in Design view.
204 Designing table in design view (5"00')  Design field name.
 Select data type.
 Set field properties.
205 Type in data (5"00')  Study how to enter records in a table.
206 Insert and Delete records (5"00')  Study how to switch in many records.
 Study how to insert and delete records.
207 Table views (5"00')  How to switch between design view and datasheet view 
208 Change the table¡¦s appearance. (5"00')  Changing datasheet formatting.
209 Printing (5"00')  How to print table 
210 Sorting (5"00')  How to sort records 
211 Filtering (5"00')  Filtering by selection.
 Filtering by form.
 Remove the filter.
301 Using queries (5"00')  Study how to select specific fields.
302 Setting criteria and Use parameter in query (5"00')  Study setting criteria.
 Study using parameter in query.
303 Calculating by query (5"00')  Study using perform general calculation.
 Study using group a field to perform statistic calculation.
304 Crosstab Query (5"00')  Study using crosstab query.
305 Create table query (5"00')  Study how to create table query.
306 Update query (5"00')  Study how to update table query.
307 Append query (5"00')  Study how to append table query.
308 Delete query (5"00')  Study how to delete table query.
401 Creating a form by using AutoForm (5"00')  How to create a form by using AutoForm 
402 Create a form with a wizard (5"00')  Study creating a form with a wizard.
403 Change formats (5"00')  How to modify form formats 
404 Align object (5"00')  Study how to arrange controls.
405 Add and Delete controls (5"00')  How to add and delete controls 
406 Change Titles (5"00')  Study how to change form title.
501 Creating AutoReport (5"00')  How to create AutoReport 
502 Creating a report with a wizard (5"00')  Study how to create a report with a wizard.
503 Modifying the report layout (5"00')  Study how to change the report layout.
504 Creating mailing labels (5"00')  Study creating a report with label wizard.
505 Previewing a report (5"00')  How to preview report before printing 
506 Printing a report (5"00')  How to setup page before printing 
601 Creating a data access page (5"00')  Study creating data access page in design view with page wizard.
602 Using data access pages (5"00')  Study how to edit data access pages formatting.
701 Import data (5"00')  How to import data from other files .
702 Link data (5"00')  Make a link for data with link spreadsheet wizard.
703 Exporting data for analysis (5"00')  How to export a datasheet to a spreadsheet file.
 How to export a table to other access database.

 

Microsoft Access 2002 Advanced (Cantonese)

 

Chapter: Name: Description:
101 Opening Access database in different modes (5"00')  How to open the database in Read and Write mode
 How to open the database in Read Only mode
 How to open the database exclusively
102 Setting table password (5"00')  How to establish the password to strengthen the safety of the database
 How to remove password protection
103 Creating listing of table property by documenter (5"00')  How to view the table property, such as, Categories, Columns, and Table Indexes by documenter
104 E-mail the content (5"00')  How to send out the database directly as the html format
105 Useful short-cut key (5"00')  How to use hotkeys to edit database more conveniently
201 Establishing relationship (5"00')  Understanding relationship definition and its classification
 How to create a one-to-one relationship
 How to Create a one-to-many relationship
 How to Create a many-to-many relationship
202 Referential integrity rule (5"00')  How to edit referential integrity rule for the relationship
203 Conditions for referential integrity (5"00')  How to condition for referential integrity
301 Creating find duplicates query (5"00')  How to make use of searching repetitive record
302 Creating find unmatched query (5"00')  How to create find unmatched query
303 PivotChart (5"00')  How to use pivot chart view
304 PivotTable (5"00')  How to make use of the PivotTable watch to on more objective analysis
305 Creating crosstab query without using wizard (5"00')  How to create crosstab query without using wizard
401 Toolbox in Form (5"00')  How to open the window the toolbox in form
402 Adding Labels and Textboxes (5"00')  How to create a label
 How to create a text box
 How to associate in label and textbox properties
403 Adding Options Groups (5"00')  How to add Options Groups
404 Adding Combo Boxes and List Boxes (5"00')  How to add combo boxes and list boxes
405 Adding tab control (5"00')  How to add tab control
406 Adding Command Buttons (5"00')  How to add command buttons
407 Adding Image (5"00')  How to add image in the window
408 Adding a Sub-form (5"00')  How to use the current window to increase the son window
409 Turning forms into Web pages (5"00')  How to convert the forms web page
501 Add a global chart base on table (5"00')  How to add a global chart base on table
502 Add a record bounded chart base on table (5"00')  How to add a record bounded chart base on table
601 Adding a Sub-report (5"00')  How to add a Sub-report
602 Grouping data reports (5"00')  How to group without Wizard
 How to create more than one Group
 How to change a Group Header / Footer
701 Creating pages by Data Access Page Designer (5"00')  How to create pages by data Access page designer
702 Publishing Access Report with XML features (5"00')  How to publish Access report with XML features
801 Integrating with MS Office (5"00')  How to integrate with MS Office software, such as Word
802 Linking to the MS SQL server (5"00')  How to link to the MS SQL server by ODBC data source
803 Managing SQL Server objects (5"00')  How to manage the SQL Server according to the different customer legal power
901 Creating a startup form (5"00')  How to create a startup form
902 Changing the application name and icon (5"00')  How to change the application name and icon
903 Getting tools on the Web (5"00')  How to get tools from Internet
1001 The Macro Window (5"00')  How to use Macro ActionArguments
1002 Creating a macro (5"00')  How to creating a macro
1003 Running a macro (5"00')  How to run a macro directly
 How to assign macro to command button
1004 Creating a macro group (5"00')  How to create a macro group
1005 Setting Conditions for running Macro (5"00')  How to create conditional Macro condition expressions
1101 Create Switchboard (5"00')  How to create switchboard
1102 Edit Switchboard (5"00')  How to edit switchboard
1201 Customizing toolbar and menu bar (5"00')  How to customize toolbar and menu bar
1202 Access Options (5"00')  How to set default field size
 How to set default font and font size
 How to set print margin
 How to set default folder