Access 2000:
Advanced

Topic-Level Outline

Days: 1

Prerequisites: Access 2000: Intermediate or equivalent experience

Unit 1 : Advanced forms

Topic A: 0 Building a form based on joined tables

A-1: Creating a form to display data from two tables by using a query

A-2: Modifying a query to display all fields on a form

Topic B: 0 Automating data entry

B-1: Using the Date function

B-2: Using the DateAdd function

Topic C: 0 Using grouped controls

C-1: Creating and using grouped controls

C-2: Adding an option group to a form

C-3: Modifying option group properties

Topic D: 0 Enhancing the user interface

D-1: Adding a tab control to a form

D-2: Setting form properties to prevent all modifications

D-3: Creating a Startup form

Topic E: 0 Subforms

E-1: Examining and using a subform

E-2: Creating a subform

Unit 2 : Macros

Topic A: 0 Creating and running macros

A-1: Examining and running a macro

A-2: Creating and running a macro to open a table

A-3: Modifying a macro to add an action

Topic B: 0 Attaching macros to events of database objects

B-1: Attaching a macro to the Open event of a form

B-2: Attaching a macro to a command button

B-3: Using a macro to resize and move a form’s window

Unit 3 : Advanced macros

Topic A: 0 Creating macros to provide user interaction

A-1: Creating a data validation macro

A-2: Creating a data-entry macro

Topic B: 0 Creating macros that require user decision

B-1: Creating a user-decision macro

Topic C: 0 Using AutoKeys and AutoExec macros

C-1: Creating an AutoKeys macro

C-2: Creating an AutoExec macro

Unit 4 : Exploring Access SQL

Topic A: 0 Identifying different clauses in a SQL statement

A-1: Discussing Structured Query Language

A-2: Examining a SQL statement in Access

Topic B: 0 Writing SQL statements

B-1: Writing a SQL SELECT clause

B-2: Using the WHERE clause

B-3: Creating a query to display matching data from related records

B-4: Using a SQL statement to find unmatched records

Topic C: 0 Attaching a SQL statement to a database object

C-1: Assigning a SQL statement to a command button

Unit 5 : Internet integration

Topic A: 0 Working with Hyperlink fields

A-1: Creating a Hyperlink field

A-2: Using a Hyperlink field to enter data

A-3: Modifying data in a Hyperlink field

Topic B: 0 Working with data access pages

B-1: Examining a data access page

B-2: Creating and using a data access page

B-3: Creating a grouped data access page based on multiple tables

Unit 6 : Security fundamentals

Topic A: 0 Securing databases

A-1: Assigning a password to a database

A-2: Removing a password

Topic B: 0 User-level security

B-1: Providing security by using the Security Wizard

B-2: Creating a new user group

B-3: Specifying permissions on database objects