Description
In this course, you will :
- 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.