Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4


This course is designed for students with advanced Access skills who are new to Visual Basic programming. Topics & theories covered include reasons for using VBA in Access, good coding habits, using variables, constants & data types, error handling....

  • Course Start Date: Mar. 20
  • Location: Edmonton (Map)
  • Time: 9:00 am - 4:00 pm (Note on end times)
  • Please Note: End Times are approximate and depend
    on the number or students and pace of the class.
    It is important to allow for the class to run a little bit longer,
    or finish a little sooner, than expected.
  • Duration: 3 Days
  • Delivery Method(s):Instructor Led
  • Mentored training is a revolutionary training method
    that provides you with the quality training that
    you have come to expect, and combines it with
    flexible learning and a self paced environment.
    For more information click here.
  • Seats Available: YES
  • Category:Microsoft Access Training Seminars and Courses

 
Course Outline
This course is designed for students with advanced Access skills who are new to Visual Basic programming. Topics and theories covered in this course include reasons for using VBA in Access, good coding habits, using variables, constants and data types, error handling, debugging code, using procedures, subroutines vs. functions, conversion, date, math, string, format and its functions, input and message boxes, logical programming commands, arrays, objects, and classes and instantiation. Other topics include working with forms, events, combo boxes, multi-select lists, text boxes, and sub forms.

Course Content
Why Access? Why VBA?

  • Understanding the Place of Access in Office
    • Choosing Between Access and Excel
    • Choosing Between Access and OneNote
  • Understanding Access Programming Choices
    • Using Macros
    • Using SQL
    • Using VBA
Getting Around in the Visual Basic Editor
  • Your First Glance at the Visual Basic Editor
  • Introducing the VBA Modules  
  • Entering and Running VBA Code
  • Getting Help on Code
  • Establishing Good Habits in Coding
Using Variables, Constants, and Data Types
  • Declaring Variables and Constants
  • VBA Data Types
Using Procedures
  • Understanding Procedure Types
  • Declaring Procedures as Public or Private
  • Passing Arguments
  • Giving a Function a Data Type
  • Implementing Error Handling
  • Debugging Code
Choosing the Right VBA Function
  • Introducing VBA's Built-in Functions
  • Converting Data Types with VBA Functions
  • Working with Date Functions
  • Using Mathematical and Financial Functions
  • Using String Functions
  • Using the Format Function
  • Using the Is Functions for Flawless Processing
  • Interacting Functions
Using Flow-of-Control Statements
  • Branching and Looping
  • Using If…Then…Else
  • Using Select Case
  • Using For…Next
  • Using Do Loops
  • Using GoTo
Working with Arrays
  • Introducing Array Variables
  • Declaring an Array Variable
  • Understanding the Array's Index
  • Working with Array Elements
  • Arrays with Multiple Dimensions
  • Expanding to Dynamic Arrays
Understanding Objects
  • Introducing Objects
  • Reading and Setting Properties
  • Invoking Methods
  • Working with Collections
  • Working with an Object Model
  • Creating Your Own Objects
  • Working with Events
Understanding Scope and Lifetime
  • What's Scope?
  • Measuring the Lifetime of a Variable or Constant
  • Using Static Variables
Working with Forms
  • Opening and Closing Forms
  • The Form Module and Event Handling
  • Performing Common Tasks
  • Handling Errors at the Form Level
  • Working with Multiple Form Instances
Analyzing the Access Event Model
  • Responding to Events
  • The Event Sequence for Controls
  • The Event Sequence for Forms
  • The Event Sequence for Reports
  • Canceling Events
Working with List and Combo Boxes
  • Populating a List Control
  • Adding to the List – or Not
  • Working with Multiselect Controls
  • Considering Callback Functions
Working with Other Controls
  • Working with Text Boxes
  • Using Controls in Option Groups
  • Working with Subforms
  • Working with the Tag Property
Working with Reports
  • Introducing the Report Module and Events
  • Opening and Closing Reports
  • Passing Arguments Using OpenArgs
  • Populating the Report
  • Handling Report-Level Errors
  • Using VBA to Determine Group Properties
Working with the Application Collections
  • Investigating the Application Collections
  • Retrieving Lists of Objects
  • Working with Object Properties
  • Programmatically Determining Dependencies
Retrieving Data with ADO
  • What's ADO and Why Do You need It?
  • Using the ADO Connection Object
  • Working with Command Objects
  • Understanding the Different Types of Recordsets
  • Creating and Opening a Recordset
  • Filtering Recordsets
  • Using the Recordset Property
Manipulating Data with ADO
  • Moving Through a Recordset
  • Finding Data in a Recordset
  • Adding Data Using a Recordset
  • Deleting Data in a Recordset
  • Updating Data in a Recordset
  • Using Transactions to Commit Groups of Records – or Not
Creating Objects with ADOX
  • What is ADOX?
  • Creating Tables
  • Securing Objects
Performing Advanced Data Operations
  • Coding for Concurrency
  • Retrieving a User Recordset
  • Using Other Schema Recordsets

Prerequisites & Certificates
Pre-Requisites

Access - Level III or equivalent knowledge/experience

Certificates offered

Certificate of completion


Cancellation Policy
10 business days cancellation or full course fee will be charged
Map & Reviews
Technology Training Centre
[ View Provider's Profile ]

TTC, B-11 Cameron Library
11320-89 Avenue,
University of Alberta

Edmonton, Alberta
Canada   T6G 2J8


Reviews
 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.
Worthwhile training that provided me with the skills needed to use Onenote.
Reviewed by 2016
I had a lot of knowledge on the course I took but I still learned a few new things which is really nice to come out of a course learning something. Thanks for the informative day. Doreen
Reviewed by 2016
The training provider (instructor) rushed through each training element and was not always patient when students didn't follow his fast demonstration. Smart person, but didn't validate that the students actually understood the process. Just interested that we could duplicate his clicks. Sorry, but I am also an instructor and was disappointed.
Reviewed by 2016
There were issues with being able to do a number of tasks , and the instructor told us many times that SharePoint 2013 was an inferior product.
Reviewed by 2016
I really enjoy the value added by a real hands-on instructor. Nothing beats a working knowledge of the product compared to a text book presentation. The commitment to ensuring the student's needs are met is a top priority and this instructor demonstrated that every day. The pace is excellent and the content extensive, I would and have recommended this course to several other people.
Reviewed by 2016
This course was good. I think it could benefit from having the sutdents create a mini catptivate module with all the components of a presentation that they can take with them and use as a template or their own use.
Reviewed by 2015
The instructor was absolutely fantastic. He is enthusiastic and very knowledgeable. I want to send the rest of the company to this class.
Reviewed by 2015
Loved the class.
Reviewed by 2015
This was a great course and I found it very helpful to the work that I will be completing in the near future.
Reviewed by 2015
Julie is an excellent instructor and I loved the class. She is very knowledgeable with a great sense of humor. Although the class was hard to find, sitting in the grass for my break in the beautiful courtyard was amazing. I will be back for more classes.
Reviewed by 2015
The course was very under the level I needed. I knew how to do everything except for the very first thing they covered in the training so I felt like it was a waste of my time and employers money. The description seemed more advanced than the material was.
Reviewed by 2014
Loved it! this was my second. Julie is very knowledgable and helpful. 1St class was downtown. U of A on the other hand...don't think I will take a course there again. over an hr to get there map wasn't very good and took a half and hr and 3 people to direct me to the parking lot where my husband was waiting.
Reviewed by 2014
This is an excellent course for all skill levels! Great instructor - lots of passion and patience for the subject. I went from never using Adobe Premiere to making my own videos at home in 2 days! I highly reommend this course!
Reviewed by 2014
Provided InDesign CS6 Visual Quickstart Guide by Sandy Cohen as reference. Very quick paced. Excellent overview of essentials. Opportunity to create a document as we went along.
Reviewed by 2014
The instructor was fantastic! Would definitely like to take a course from her again. I recently took a course at the Cameron Library location, however, and found this to be easier to access than downtown. Thanks for a great course.
Reviewed by 2014
For the amount of useful instruction we received, the course could have been two hours long. While the course did cover everything needed, the rest of the time was taken up with filler (tips on items loosely related to the course, but not needed in order to use the software). The room was freezing and I had to wear my coat for the entire day. There was no parking close-by so I had to take the bus.
Reviewed by 2014
Excellent instructor
Reviewed by 2014
He was AWESOME!!!
Reviewed by 2013
The course was very good, but with only 2 people in the class, we hoped that the course be more adaptive to the needs of the 2 attendees instead of the laid out course.
Reviewed by 2013
The instructor was excellent! One of the best instructors/educators I've had over the past 30 years. His ability to communicate the material far exceeded my expectations and made me feel comfortable and engaged in class.
Reviewed by 2013
Instructor was awesome, made the day go by quickly and had a lot of knowledge about the program as well as the industry. Very ressourceful.
Reviewed by 2013
When using Excel it can be confusing, but if u were to have a second day for this info to sink into the brain and be able to come back and try and create our own spreadsheet I feel what we learned would stay in our memory bank better.
Reviewed by 2013
this was a vary knowlageable course and i look forward to using all my new found tips
Reviewed by 2013
For the content covered, the course is way too short (2 days). It is more of a refresher course for students. I recommend that attendees have basic knowledge of Adobe suite software. This wasn't indicated on course profile.
Reviewed by 2013
Have not looked at the course handouts yet. Instructor does not just "go through" the book, which I really appreciate. So will look at course handouts later.
Reviewed by 2013
Re Trainer: she let us know right away that she did not like to use the book as her guide and that at the end of the day we would check it to make sure we had covered what was needed, however... having attended a previous "Level 1" I must say I much preferred using the book as a guide.I found that by just "checking" at the end if we had covered every thing, meant my notes on a particular subject were not on the corisponding pages because I didn't have time to find the correct page to write them on.
Reviewed by 2013
The course was fine. However,there were not enough books available, people had to share and only a few people were able to take a book home the same day. It was difficult to find the Cameron Library and to get to the class from the parking lots where you can park. It was frustrating especially in -30'C weather. The instructor was great.
Reviewed by 2013
Maybe go a little slower for beginners and give us time to follow along. He also only gave us 5-10 minutes o try things....if you are not familiar with Sharepoint thats not long.
Reviewed by 2013
The instructor was great - he made the material interesting and fun. The course is a beginners step into VBA which is useful, but you will need to take more if you plan to work vigorously with this application.
Reviewed by 2012
I wish the course had one more day to practice all that we learnt.
Reviewed by 2012
The course enlighted me on the basic structure of Access with tables, queries, & forms. However macros were not covered, which a large portion of our database. Perhaps they are covered on a subsequent course.
Reviewed by 2012
I'd recommend the training class to anyone who would like to learn about SharePoint. Our instructor Colin was excellent!
Reviewed by 2012
I found the classroom very hard to find. If you wern't familiar with the campus, even finding the Cameron Library difficult. A map would be very useful. Parking around the University was expensive and hard to find. The course itself was good and the instructor was great!
Reviewed by 2012
I thought Miche was a fabulous trainer - I would go back and take any course from him. He was very knowledgable and his teaching style was easy to follow along with. This course was a great crash course-I'll be looking to do Level 2 in the future!
Reviewed by 2012
Colin Rider was an extremely effective instuctor.
Reviewed by 2012
I enjoyed the course, the interaction with the other students and felt the instructor was punctual, knowledgeable and offered a great deal of reference material for further resource, I invited a coworker and we attended the course at out own expense. We both agreed we would attend another class at that facility again in future.
Reviewed by 2012
Unfortunately the initial instructor had an emergency to attend to on day 2 of the course. A second instructor (Project 2007 oriented) took over. All students have been offered a resit through the U of A for October 2nd and or 12th.
Reviewed by 2012
I truly appreciated this course and learned a lot, I now plan to take the next courses as well!
Reviewed by 2012
Course was excellent. Only thing was there should be more info indicating that this was entirely an entry level (beginner) course.
Reviewed by 2012
Awesome course. Content was extactly what I required.
Reviewed by 2012
EASY TO FOLLOW WELL DONE
Reviewed by 2012
Julie was awesome, she is very knowledable and very patient.
Reviewed by 2012
She was very knowledgeable. I enjoyed the course!
Reviewed by 2012
Unfortunately, it is not the fault of the course, the content did not cover what I required for my work. I will hopefully be taking the next level as our instructor indicated that would be the one that would provide the skills necessary for the type of documentation we produce.
Reviewed by 2012
Enjoyed the day
Reviewed by 2012
Concise, clear and well presented. I would request this facilitator for any future courses based on my confidence is her ability to communicate effectively and based on her knowledge of the materials.
Reviewed by 2012
We were hoping there would be more about 'forms'. (Portfolio was interesting, but not really releveant to my needs). - Actually, my boss asked if we talked about Forms Manager, I said no, and then we couldn't decide if Forms Manager is something that was discontinued in X (from 9).
Reviewed by 2012
Parking facilities at the UofA are incredibly expensive, for those who need to drive there. $40/day for parking was disappointing!
Reviewed by 2012
Made sure you did everyting twice, was double checked by instructor.
Reviewed by 2012
Had never done Excel before, it was all greek to me. Maybe need to repeat work sheets twice. I will come back for repeat class.
Reviewed by 2012
Great course
Reviewed by 2011
Course instuctor did not hand out the manuals until end of the day. Therefore not able to write notes in for reference later on. - kinda silly.
Reviewed by 2011
You shoudl have a Excel 3 class available
Reviewed by 2011
Great training, had to meet the various needs from no experience to some with experience. Washrooms looked tired and need of improvement. Personally prefer an early start/early finish 8am to 3pm would be great
Reviewed by 2011
Course materials were not handed out till the end of the course and may have been useful to follow along. Some of the example/course files were missing from my folder.
Reviewed by 2011
The Instructor was very knowledgable on the subject. The class moved quickly. I think an additional day would have been nice.
Reviewed by 2011
Trainer was open to answering questions and provide information in a clear manner.
Reviewed by 2011
Well presented, hands on course! The instructor was extremely knowledgable and helpful!! I have already reccommended this course to my managers.
Reviewed by 2011
The trainer I had was great. She had a great personality that kept me interested. Awesome Job! Thank you
Reviewed by 2011
The course was excellent and the instructor did a great job but why does everybody cut the time short. I think we should take a shorter lunch and get more class time instead of leaving a half of an hour early!
Reviewed by 2011
EXCELLENT instructor!!! Very patient ... customized the class to the needs of the students!
Reviewed by 2011
The only improvement I can suggest is focusing a bit more on the basics of Visio - more on Org & flow charts as opposed to so much time spent on designing rooms.
Reviewed by 2011
George was personable and easy to follow and work with.
Reviewed by 2011
Sue is an awesome instructor!
Reviewed by 2011
The instructor was excellent. It was evident that several of us who were competent with Excel 2003 Level 1 should have probably taken Excel 2007 Level 1 again rather than Excel 2007 Level 2, but the instructor was very patient and managed to cover basics from Level I as well as Level 2.
Reviewed by 2011
With myself being very green with this program I got very useful information that I can use daily.
Reviewed by 2011
One more hour would allow for more hands-on training.
Reviewed by 2011
Good course. Friendly instructor. I found the speed of the course to be a little slow for me, however I understand that other attendees required more help/detail than I did. Overall, a good experience.
Reviewed by 2011
20-March-2017 $450 Register for this course

Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer Make An Offer Help

Not enough budget for this course? Maybe you just love to make deals!
In either case, our Make an Offer feature gives you the opportunity to name
your own price. Try it out, you might get lucky, just keep in mind it can
take up to 1 full business day to get a response!
need-to-train-a-group-banner

This course currently does not have any dates other than this one scheduled. Please call 1-877-313-8881 to enquire about future dates.

Not interested in this Course?

Tell us why:

This page has been viewed 14 times.