What you’ll 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!
- 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.
Microsoft Access Three Course Bundle:
→ Access: Customizing Tables, Forms, Reports & Action Queries
→ Microsoft Access Macros: Automate Your Access Database
→ Microsoft Access SQL: SQL for Non-ProgrammersPart 1 Part 2
Source : www.udemy.com