Course Overview
TOPYou will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.
Scheduled Classes
TOPWhat You'll Learn
TOPUpon successful completion of this course, students will be able to:
- share Access data with other applications.
- use VBA to automate a business process.
- create and modify a database switchboard and set the startup options.
- secure and distribute databases.
Outline
TOPLesson 1: Planning the application
Lesson 2: Using command buttons and editing VBA code
Lesson 3: Macros used to that automate an unbound form for running reports
Lesson 4: Querying using forms
Topic A: Command buttons
Topic B: Expression builder
Topic C: Unbound controls
Lesson 5: Creating Switchboards
Lesson 6: Creating Splash Screens
Lesson 7: VBA Code:
Topic A: Sub procedures
Topic B: Calling sub procedures from forms
Topic C: Functions
Topic D: Loops
Topic E: IF statements
Lesson 8: Inserting an Active X Control and automating with VBA
Lesson 9: Splitting a database
Lesson 10: Security discussion and adding passwords
Prerequisites
TOPTo ensure the successful completion of Microsoft Office Access Part 4 VBA, the following Logical Operations courses or equivalent knowledge is recommended:
- Microsoft Office Access Part 1
- Microsoft Office Access Part 2
- Microsoft Office Access Part 3
Who Should Attend
TOPThis course is designed for students who have a thorough understanding of the basic and advanced user features of the Microsoft Office Access application, and are interested in learning introductory level administrator skill sets. The course is also for students who may be working in a web-based environment and may need to adapt Access applications to the environment.