Request More Info

First Name*:

Last Name*:

Job Title:

Mail Point:

Company*:

Address*:

Town*:

Post Code*:

Country*:
   Codes

Office Telephone*:

E-mail*:

* Required

Information provided will be used to communicate with you about our products.
Privacy Statement

A Learning Tree representative will contact you to follow up your request for information.

Tidsbegränsat erbjudande – Upp till 40 % RABATT per kurs
 

Building Applications with Microsoft Access®: Hands-On

Course: 971 • 4 dagar

 E-mail   Print   Q&A   PDF   Facebook   Twitter    Se på svenska

Quick Enrol

You Will Learn How To

  • Develop distributable applications with Microsoft Access
  • Incorporate design requirements to enhance application functionality
  • Customise applications by dynamically setting properties and executing methods
  • Assemble expressions into VBA statements using variables and intrinsic functions
  • Control program flow with loops and decision-making logic
  • Programmatically control data access to incorporate business rules

Course Benefits

Microsoft Access provides the tools to build custom applications that can decrease the time and effort needed to accomplish business objectives. In this course, you gain the skills necessary to expand the capabilities of your applications. Through extensive hands-on exercises, you learn how to develop, integrate and customise Access applications using macros, expressions, VBA and Structured Query Language (SQL).

Who Should Attend

Those planning to create, support and enhance business solutions with Microsoft Access. Experience with Access at the level of Course 970, "Microsoft Access Comprehensive Introduction", is assumed. A basic understanding of any programming language is recommended but not required.

Hands-On Training

Extensive hands-on exercises, centred around a single case study, provide you with practical experience programming Access. Exercises include:
  • Adapting business requirements into macros and VBA code
  • Exploiting Forms and controls by manipulating properties and executing methods
  • Empowering your code using built-in functions
  • Incorporating logic and iteration statements
  • Programmatically manipulating data using VBA
  • Implementing error-handling code

Course Content

Automating Access with Macros

Designing complex macros

  • Creating decision-making macros
  • Implementing organisational techniques for macros
  • Incorporating temporary variables
  • Interfacing with the user

Maximising macro functionality

  • Trapping macro errors
  • Mastering event-driven programming
  • Binding macros to event properties

Transitioning to VBA

Beyond the macro object

  • Identifying limitations of macros
  • Converting macros to VBA
  • Exploring the DoCmd

Exploring the Visual Basic Editor

  • Navigating the Project Explorer
  • Writing code with IntelliSense
  • Troubleshooting code with debugging techniques

Programming Access Objects

Negotiating the Object Model

  • Methods
  • Properties
  • Events
  • Communicating with individual objects

Interfacing with Access objects

  • Application
  • Forms collection
  • Form and report object
  • Controls collection
  • Bang (!) vs. Period (.)
  • Exploiting the ComboBox, ListBox, Option Group and TextBox
  • Writing code with the Me keyword

Applying event logic

  • Identifying the order of events
  • Assigning requirements to events
  • Cancelling the event sequence

Demystifying the Object Browser

  • Finding objects
  • Object libraries
  • Locating methods, properties and events
  • Gateway into the Help system

Constructing VBA Expressions

Working with variables

  • Naming rules and conventions
  • Declaring objects
  • Implicit vs. explicit data type conversions
  • Specifying the scope and life of variables

Implementing built-in functions

  • Date, string and file system functions
  • Utilising domain aggregate functions
  • Integrating symbolic and intrinsic constants

Controlling Program Execution

Structuring code sequences

  • Creating decision-making logic
  • Building iteration statements
  • Queries and the Immediate If (IIf)

Logical and comparison operators

  • Developing comparative statements
  • Designing relational expressions

Optimising code for scalability and reuse

  • Defining procedures with arguments
  • Returning values with functions

Manipulating and Managing Data

Data access

  • Executing action SQL statements
  • Retrieving data into Recordsets
  • Building and modifying parameterised queries

Designing intelligent forms

  • Interacting with unbound controls
  • Changing data sources within code

Processing Runtime Errors

  • Classifying errors
  • Working with the Err object
  • Logging and error notification
  • Creating error-handling strategies

Getting Ready for Distribution

  • Customising the ribbon
  • Configuring start-up options
  • Creating and controlling ribbons in Access
  • Locking down the database

<< Back to Excel, Office och Access
 

Related Courses

Access is a registered trademark of Microsoft Corporation.
Learning Tree AnyWareTM is a trademark of Learning Tree International, Inc. in the United States and other countries, and is covered by a patent application pending in the United States.
  
Building Applications with Microsoft Access

Course Dates

Live online classroom training.Most events below can be taken in-class or live, online from your home or office with AnyWare.

UK Dates

24 - 27 JulLondon enrol
22 - 25 JanLondon enrol

US Dates

12 - 15 JunWashington, DC enrol
10 - 13 JulNew York enrol
25 - 28 SepWashington, DC enrol
9 - 12 OctWashington, DC enrol
6 - 9 NovNew York enrol

For AnyWare enrollments, please register at least 7 days prior to the start of the course.

More Dates and Locations.

 

On-Site &
Custom Training

Bring this or any Learning Tree course to your location or have it customized for your organization.

 

Kursdeltagarnas genomsnittsbedömning

 De senaste 12 månadernas bedömningar

5 stjärnor:
71 %
4 stjärnor:
23 %
3 stjärnor:
6 %
2 stjärnor:   0 %
1 stjärna:   0 %


 
Ten Questions to Ask Your Training Provider - Position Paper