The power of Access really gets unleashed when you start adding VBA (Visual Basic for Applications) to your project – and it is not hard! While you may not consider yourself to be a programmer, or thought you’d ever be one, automation is covered in small steps that are easy to understand. You can learn how to take advantage of the great power of VBA with just a few lines of code that make sense.
The application that is built has customers, services, invoices, and would be good for anyone in a service business such as architects, engineers, accountants, lawyers, electricians, plumbers, and even lawn mowers.
Video tutorials are recorded in Microsoft Access 2013.
- Learn how to design tables properly and build relationships.
- Create forms and reports and then modify the design.
- Make simple and complex queries and create calculated fields.
- Import information from other sources such as Excel.
- Use VBA to create command buttons to open forms and reports, set properties, track modification dates, and more.
Type of Certification
Format of Certification
Method of Obtaining Certification
Crystal Long - MS Access MVP
Crystal has always loved to teach. As a college student headed to a BSc. in Petroleum Engineering, she tutored her peers in physics, chemistry, math, and writing. She is passionate about sharing her knowledge and empowering learners.
Crystal has provided remote and face to face training in the MS Office suite of applications for 30 years, including Access, Excel, Word and PowerPoint.
Crystal was awarded the prestigious Microsoft Most Valuable Professional award for Access in 2006; a distinction she has won every year since! The Microsoft MVP Award recognizes exceptional technical community leaders from around the world who voluntarily share their high quality, real world expertise with others. In Microsoft's words, "MVPs are a highly select group of experts representing technology's best and brightest who share a deep commitment to community and a willingness to help others."
Crystal was chosen to present about Access at the 2015 Microsoft MVP Virtual Conference, a prestigious 2 day event designed by Microsoft to "showcase how the best and brightest independent technology experts are using Microsoft technologies today."