MS Access 2000 for Windows Introduction (English)

 

Chapter: Name: Description:
1 What's Database & what's Access 2000  (2"42')  What is database & What's Access 2000
 Setting up a database
2 Create table by using wizard (3"45')  Creating a table by using wizards
 Entering records in a table
3 Create table by design view (3"03')  Creating a table by using design views
 Changing the data types
4 Extracting data by using Query (Part I) (4"06')  Extracting data by using select query method
5 Extracting data by using Query (Part II) (4"12')  Extracting data by using action query method
6 Create AutoForm (2"13')  Create Autoform
7 Create a form with a Wizard (2"14')  Create a form by using form wizard
8 Editing form in Design View (1"13')  Using Design View to edit form
9 Create AutoReport (2"28')  Creating Autoreport
10 Create a report with a wizard (2"11')  Create a report by using form wizard
11 Create mailing labels (2"13')  Create mailing labels step by step
12 Publising a database as a Web Page (3"47')  Creating and using data access pages
 Editing a page
13 Working with external data (2"39')  Gathering data from external sources
 Creating a link to an external data source
 Importing a table
14 Exporting data for analysis (2"19')  Exporting a datasheet to a spreadsheet file

 

MS Access 2000 for Windows Advanced (English)

 

Chapter: Name: Description:
1 Define relationships between tables (4"58')  Why define relationships
 Establishing relationships
 Creating a One to one relationship
 Creating a One to many relationship
 Referential integrity rule
2 More sophisticated forms (I) (3"17')  Create form by using controls
 Adding labels and textboxes
3 More sophisticated forms (II) (6"01')  Adding options groups
 Adding combo boxes and list boxes
 Adding command buttons
4 Global Chart (3"22')  Add a global chart base on table
5 Record bounded chart (2"29')  Add a record bounded chart base on table
6 Grouping data in reports (2"37')  Grouping without a wizard
 Details in grouping data
7 Automation task by macros (3"49')  Creating macro
 Macro action
 Run macro
 Assign macro to a command button
8 Create a macro group (4"10')  Create a macro group
9 Startup option (2"17')  Creating a startup form
 Changing the startup options
10 Create and manage a switchboard (2"41')  Create a switchboard
 Customizing a switchboard
 Make default switchboard
11 Make a tailored made switchboard as default (1"33')  Make switchboard as a startup form