(<img height='1' width='1' border='0' src="http://www.googleadservices.com/pagead/conversion/1072619999/?value=1&label=Lead&script=0" />)
F1
About F1Course ScheduleOther ServicesSite MapContactHome

Mastering Microsoft Access 2000 Programming

Exchange Server
Office (inc Access)
SQL Server
Visual Studio .NET
Windows
Web Development
Visual FoxPro
Programming
Business
Knowledge Management
Certification
Learning Options
Reserve a Place
No scheduled Course : Contact for Details
View Other Courses in Same Category

Module 1: Introduction to Programming

  • Overview of a Microsoft Access application
  • Writing procedures
  • Working with variables
  • Controlling program flow
  • Calling procedures
  • Getting help
Skills
  • Use Visual Basic Editor to add code to applications
  • Declare and use variables
  • Use built-in functions to obtain values from users
  • Create and call Sub procedures
  • Use conditional statements to control the flow of programs
  • Use Visual Basic Help
Top

Module 2: Responding to User Actions

  • Overview of the class application
  • Adding event procedures
  • Working with events
  • Using objects, properties, and methods
  • Using the DoCmd object
Skills
  • Create an event procedure
  • Add an event procedure to a form
  • Respond to user actions programmatically
  • Perform specific tasks using the DoCmd object
Top

Module 3: Validating Data

  • Overview of data validation
  • Validating data without using code
  • Validating data by using code
Skills
  • Differentiate between data validation at the table level, form level, and code level
  • Use the built-in validation tools in Microsoft Access
  • Write Visual Basic for Applications code to validate data
Top

Module 4: Using Functions and Understanding Scope

  • Using functions
  • Understanding scope
Skills
  • Create custom functions
  • Create private and public variables
Top

Module 5: Using Debugging Tools

  • Stepping through code
  • Viewing variables
Skills
  • Set breakpoints to stop program execution
  • Run selected portions of code
  • Test data and procedures in the Immediate window
  • Monitor variable values in the Locals window
  • Add and edit watch expressions
Top

Module 6: Handling Run-Time Errors

  • Types of errors
  • Run-time errors
  • Adding error handlers
Skills
  • Trap run-time errors
  • Create error handlers
  • Create a template to write procedures
  • Use the Err object
  • TOP
Top

Module 7: Looping Through Code

  • Overview of looping structures
  • Do loops
  • For loops
  • Interrupting the execution of a loop
Skills
  • Create loops to control the flow of programs
Top

Module 8: Working with Records

  • Overview of record sets
  • Retrieving data
  • Structured Query Language (SQL)
  • Manipulating data
  • Overview of record sets
  • Retrieving data
  • Structured Query Language (SQL)
  • Manipulating data
Skills
  • Retrieve data using SQL and ADO record sets
  • Manipulate data using SQL and ADO record sets
  • TOP
  • Retrieve data using SQL and ADO record sets
  • Manipulate data using SQL and ADO record sets
Top

Module 9: Working with Records

  • Overview of record sets
  • Retrieving data
  • Structured Query Language (SQL)
  • Manipulating data
Skills
  • Retrieve data using SQL and ADO record sets
  • Manipulate data using SQL and ADO record sets
Top

Module 10: Finalizing Your Application

  • Reviewing your application
  • Enhancing the user interface
  • Packaging for delivery
Skills
  • Use good coding practices
  • Customize a switchboard form
  • Hide code by creating an MDE file
  • Package an application for distribution
Top

Exams:

  • There are no exams directly associated with this course

Price Options ex VAT:

Classroom Training
?		 Distance Learning
?		 eLearning Options
?		 Book Learning
?
£ 1185
(€1683) 		£ 674.00
(€957) 		- No Books Supported for Course at present

Call Free on 0800 169 1890
Print 2 Page Flyer
Last Modified 01 May 2008