Invalid quantity. Please enter a quantity of 1 or more.
The quantity you chose exceeds the quantity available.
Please enter your name.
Please enter an email address.
Please enter a valid email address.
Please enter your message or comments.
Please enter the code as shown on the image.
Please select the date you would like to attend.
Please enter an email address.
Please enter a valid email address in the To: field.
Please enter a subject for your message.
Please enter a message.
You can only send this invitations to 10 email addresses at a time.
$$$$ is not a properly formatted color. Please use the format #RRGGBB for all colors.
Please limit your message to $$$$ characters. There are currently ££££.
$$$$ is not a valid email address.
Please enter a promotional code.
N/A
Sold Out
Unavailable
Please enter a password with at least 8 characters.
You have exceeded the time limit and your reservation has been released.
The purpose of this time limit is to ensure that registration is available to as many people as possible. We apologize for the inconvenience.
This option is not available anymore. Please choose a different option.
Please read and accept the waiver.
All fields marked with * are required.
Please double check your email address. The email address format does not appear valid.
Please double check your email address. Your emails do not match.
$$$$ requires a number between ££££ and §§§§
US Zipcodes need to be 5 digits.
Postal code may contain no more than 9 letter or number characters.
Please double check your website URL.
All fields marked with * are required.
Your card expiration date is in the past.
Your card CSC needs to be 4 digits.
Please confirm your order: $$$$ You have selected to Pay by Check.
Click OK to confirm your order.
Please confirm your order: $$$$ You have selected to Pay at the Door.
Click OK to confirm your order.
Please confirm your order: $$$$ You have selected to Pay upon Receiving an Invoice.
Click OK to confirm your order.
Your card CSC needs to be 3 digits.
Sofort is only available in Germany and Austria.
Boleto Bancario is only available in Brazil.
PagoFacil is only available in Argentina.
Rapipago is only available in Argentina.
Please enter a valid IBAN number.
You need to accept to charge your bank account.
Your billing zip code needs to be 5 digits.
Please double check your CEP info. The CEP format should be something like 12345-678.
Please double check your tax identifier.
There was a problem saving your address.
There was a problem saving your card info.
There was a problem saving your personal information.
Please select the date you would like to attend.
McAfee Secure sites help keep you safe from identity theft, card fraud, spyware, spam, viruses and online scams.
Copying Prohibited by Law - McAfee Secure is a Trademark of McAfee, Inc.
Unknown card type.
No card number provided.
card number is in invalid format.
Wrong card type or card number is invalid.
card number has an inappropriate number of digits.
Please enter numbers here.
Please enter an integer value.
Numbers must be less or equal to $$$$
All the required fields have not been filled out. Click OK to proceed without all the required information, or click Cancel to finish entering the missing data.
Please enter a donation amount.
Please select an attendee for donation.
There is currently an issue with card submission on Safari with iOS7. Please try again with a different browser or device.
Sorry, invalid event registration form.
Sorry, invalid event or database error.
Sorry, quantity must be a positive integer.
Sorry, you did not select a valid ticket.
Sorry, invalid event organizer email address.
Your order was canceled.
Thank You. Your order has been successfully completed. Your name and email address have been added to the list of event attendees.
Sorry, that option is sold out.
Sorry, that option is no longer available.
Sorry, there are only 32 tickets of that type still available.
Sorry, you entered an invalid quantity. Please enter a quantity of 1 or more next to the type or types of tickets you would like to purchase.
Sorry, you did not select any tickets to purchase. Please enter a quantity of 1 or more next to the type or types of tickets you would like to purchase.
Sorry, there are no tickets left for this event.
The tickets, ticket quantity or date and time you've requested are no longer available, due to previous sales. Please choose a different date, time or number of tickets and place your order again.
Sorry, one or more of the tickets you requested are no longer available for purchase.
Sorry, you need to select the date you want to attend.
Sorry, the promotional code you entered is not valid yet.
Sorry, the promotional code you entered has expired.
Sorry, the promotional code you entered is not valid.
Your session has expired. Try ordering again.
Sorry, your requested ticket quantity exceeds the number provided by your promotional code.
Structured Query Language (SQL) & Visual Basic for Applications (VBA)
Course Overview
This 4-day course is a follow-up to the Access 4-day Intensive and is designed to teach the skills needed in order to create database applications.
Day 1 is an overview of Access advanced concepts, including Macros, query functions and form and report properties.
In Days 2 – 4, participants will learn how to use SQL and VBA to automate their databases.
As a result of this course, participants will learn:
How to create complex forms, including switchboard and multi-tabbed forms.
How to add automation to forms to make the process of entering and updating data more efficient and less error-prone.
How to use automation to quickly manipulate records.
How to use SQL and VBA to query datasets quickly.
How to use Automation to transfer data from Microsoft Access to MS Word and Excel.
How to create and use message boxes and input boxes.
How to create switchboard forms to organize a database’s workflow.
How to use VBA and forms to create dynamic reports.
How to implement security in Access 2013 databases.
How to program form and report events.
Contact us:
To contact us about scheduling a presentation at your location, or to answer any questions please click here or call 770.498.7333.
This course instructor has over 20 years of Access database development experience. This course was developed to share the core skills needed to take your database development to the next level.
***Please bring your laptop.*** If you need us to provide the laptop, let us know when you register.
Can't attend? Want us to bring this course to your site? Interested in this course in Access 2010 instead of 2013? We offer affordable, customized training for groups of as few as 4 people. Contact us or call 770.498.7333 for details.
The employers we've provided software training for include ...
Feedback:
The class was very well taught and held my attention to the very end.
The instructor, Jackie, was organized, efficient, and willing to extend her instructional services even after the class was over. She did an excellent job showing her mastery of the ins and outs of Microsoft Access. But most of all her cooperative attitude and her enthusiasm while instructing us must be commended.
Even after the class was over, Jackie has been an invaluable resource by showing her continuous quest to ensure that Microsoft Access is demystified. And last but not least, Jackie's level of professionalism when dealing with questions on Microsoft Access and her efforts to go beyond the call of duty to ensure that class participants thoroughly understand Microsoft Access has left me with a great admiration of her technical skills.
Caroline E., Environmental Engineer
Your registration fee includes:
Hands-on computer based training
Training manual(s)
Practice exercises on CD
Real world exercises.
Pre-requisites:Windows experience and familiarity with the keyboard.
To contact us about scheduling a presentation at your location, or to answer any questions please click here or call 770.498.7333.
About your instructor Ms. Kiadii helps business professionals use technology to save time, lower costs and increase profits. She provides business technology workshops, customized software training, and Access database solutions. She has taught programs for hundreds of business owners, the Small Business Development Center (GSU), Small Business Administration (Atlanta), Women's Economic Development Agency, Georgia Center for Nonprofits.
Refund / Cancellation Policy: If instructor cancels class, students will be issued a full refund. If a student cancels registration, at lease one week prior to class, instructor will issue a refund less $75 administrative fee or 15%, whichever is higher. No refunds will be issued if student cancels within a week of class; student will be issued a credit.Credits are good for 90 days.
Share Access 2013 Application Development & Automation (VBA) (Nov 2016)
Email Share Tweet