Articulate the basic principles of Relation Database Management Systems
Identify appropriate use of fields and records
Identify candidate entities
Create Entity Relationship Diagrams (ERDs)
Performa data normalization
Create a database
Create a table
     Create fields
      Define datatypes
Set field properties
      Create lookup fields
       Define validation rules and text
      Define required fields
       Create input masks
Create primary keys
Create table relationships
Enforce referential integrity
Manage data within a table
Sort data within a table
Import data
Develop queries
Recognize basic SQL elements
Create forms using the MS Access 2000 wizard
Create MS Access 2000 reports
Create a MS Access 2000 data access page
Modify MS Access 2000 data access pages in design view
Identify the Visual Basic for Applications programming environment components
Use a VBA project
Identify the options for accessing VBA help
Create unbound forms
Manage forms
Use intrinsic controls
      Text box
      Label
      Check box
      Command button
      Option buttons
      Frames
Use toolbars
Use variables
      Datatypes
      Scope
      Constants
Use decision structures (If... Then...Else, Select… End Select)
Use repetition structures (do… loop, for… next)
Use MsgBox functions
Use InputBox functions
Understand the anatomy of functions and sub procedures
Create sub procedures
Create functions
Define sub procedures and function parameters (optional, IsMissing function)
Call functions and sub procedures (call keyword, function returns a value)
Articulate good practices for writing subs and functions
Run
Fix compile errors
Halt execution (stop statement, Set breakpoints, and Break button)
Step
Watch variables (Watch Window, Quick Watch, and Auto Data Tips)
Use the Immediate Window
Explain the difference between the Internet and an intranet
Articulate the use of VBScript in intranet development
Define the structure of the DHTML Object Model in Internet Explorer 5.0
Know the basics of objects, properties, methods, and events
Use VBScript to add functionality to a Web page
Implement variables in VBScript
Use VBScript built-in functions
     Use input boxes
      Use message boxes
      Use alerts
Create and implement VBScript sub procedures
Create control structures using VBScript
If… Then statements
If… Then… Else statements
For… Next loops
Do… While loops
Do… Until Loops
Implement validation on a Web form