Microsoft Access: Beyond the Basics of Access Bundle

Don't Miss This Info Packed Three-Course Bundle: (1) Customizing Your Database (2) Automate w/Macros (3) SQL Scripting

Created by: IsáBel .
Microsoft Certified IT Professional. Trainer of 25 Years

What Will I Learn?

• This bundle combines 3 courses to help you conquer Access in weeks - not months or years (because who's got time for that?)
• Learn TIME-SAVING Database Tips, AUTOMATE Your Database with MACROS, and SCRIPT SQL all in one course!
• ----------
• ----------
• SET Field Validations. Make sure users are entering the correct data.
• IMPORT and EXPORT Data Using Microsoft Excel, an application you probably use daily.
• CREATE Cascading Combo Boxes. Base the items in a combo box off what was selected in another combo box.
• CONDITIONALLY FORMAT Forms & Reports to make your data easier to understand.
• CREATE Parameter & Action Queries. Go beyond standard Select Queries
• CUSTOMIZE the Access Environment Ribbon, Navigation Pane & Startup
• UNDERSTAND Database Maintenance Tools to keep your data intact.
• USE the Macro Builder Window to automate your database
• CREATE Data Macros for Table Automation
• CREATE Macros for Forms & Reports
• CREATE AutoExec Macros to run Macros when starting your database
• SCRIPT SQL to Query Your Tables
• CREATE Database Tables with SQL
• CREATE Table Joins with SQL
• CREATE Action Queries with SQL
• ... and so much more!

Requirements

• Download the Northwind database to follow along with examples in this course. The Northwind database is available through the Access application. Please see Lecture 2 for details.

Target audience

• This Microsoft Access three course bundle is for anyone who wants to go beyond the basics of using Access. It is not for brand new users of Access or of databases. It can serve as a refresher for advanced users of Access, but is not designed to be an advanced level course.
• Please look over the course curriculum when making your decision on enrolling in this course.
• Although the course was created using Access 2013, 95% of the lectures also apply to Access 2010, and Access 2016. Access 2007 can be used for about 70% of this course.