Access 2000: Introduction to Application Development

Prerequisite Skills:
Students should be current Access 2000 users who are proficient in the following:

• Creating normalized Access tables and their relationships
• Creating multi-table queries
• Creating forms, subforms, and reports

Course Description:
In this class, current Microsoft Access users will learn how to design Access applications; create controls, macros, dialog boxes, and custom switchboards; and apply security to a database.

Attend this course if you want to:

• Understand application design concepts.
• Create and use command buttons within a form or to navigate to other forms or reports within the application.
• Create and use a macro group.
• Create switchboard forms for navigating within the application.
• Customize toolbars and menus for use on specific forms.
• Create splash screen forms.
• Use Visual Basic procedures within Access applications.
• Add security to an application.

Class Length: 8 hours

Delivery Formats:

• On-site instructor-led

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

Excel 2003: Introduction to VBA

Objective:
Use Visual Basic for Applications (VBA) to create macros for automating repetitive tasks in Excel.

Prerequisite Skills:

• Comfortable with intermediate to advanced Excel capabilities.

• Comfortable creating basic macros in Excel.
  (Suggested Course: Excel 2003 Automating Tasks with Macros)

Course Description:
If you have created macros Excel 2003, you know that they can provide valuable shortcuts to common or complicated tasks. Sometimes, however, the macro recorder in Excel does not provide the flexibility you need for more involved macros. In this class, learn how to use VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations.

Attend this course if you want to:

• Edit or debug a macro.
• Sort data in a worksheet.
• Use a macro to insert rows and columns.
• Use a macro to insert or format text.
• Generate a report.
• Create an interactive worksheet.
• Use a macro to insert, copy, and delete worksheets.
• Create complicated and automated calculations.
  

Class Length: 8 hours

Delivery Formats:

• On-site instructor-led

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

Office 2000: Macro Programming Using Visual Basic for Applications

Objective:
Learn to create macros in Microsoft Office applications using Visual Basic for Applications (VBA) programming.

Prerequisite Skills:

• Comfortable with intermediate to advanced Word and Excel capabilities.

• Comfortable creating basic macros in Word and Excel.
  (Suggested Courses: Word 2000 Automating Tasks with Macros or Excel 2000 Automating Tasks with Macros)

Course Description:
If you have created macros in Word, Excel, or PowerPoint, you know that they can provide valuable shortcuts to common or complicated tasks. Sometimes, however, the macro recorder in Microsoft Office does not provide the flexibility you need for more involved macros. In this class, students learn how to create more advanced macros, using Visual Basic for Applications (VBA) programming.

Attend this course if you want to:

• Run macros and understand the basics of a Visual Basic module.
• Create relative and absolute recorded macros.
• Assign macros to menus, buttons, or toolbars.
• Use decision-making code to write macros that test conditions and then run only certain statements based on the results.
• Write procedures that execute one or more lines of code repetitively.
• Store Excel macros in a Personal Macro Workbook, so they are available in any workbook you create.
• Record and run macros in Word.
• Create macros that interact with the user.
  

Class Length: 8 hours

Delivery Formats:

• On-site instructor-led

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details