Learn the principles of table relationships; advanced query techniques; an introduction to functions, macro actions, advanced form techniques including using macros in forms; database security, and advanced report techniques.
Class Outline
Unit 1: Implementing Advanced Form Design
- Topic A: Add Controls to Forms
- Topic B: Enhance navigation and organization of forms
- Topic C: Apply conditional formatting
Unit 2: Sharing data across applications
- Topic A: Import data into access
- Topic B: Export Access data
- Topic C: Link Tables to external data sources
- Topic D: Create a mail merge
Unit 3: Using macros to improve user interface design
- Topic A: Create a macro
- Topic B: Restrict records by using a condition
- Topic C: Validate data by using a macro
- Topic D: Automate data entry by using a macro
- Topic E: Converting a macro to VBA
Unit 4: Using Advanced database management
- Topic A: Manage a database
- Topic B: Determine object dependency
- Topic C: Document a database
Unit 5: Distributing and Securing a database
- Topic A: Splitting a database for multiple-user access
- Topic B: Implement security
- Topic C: Convert an Access database to an ACCDE file
- Topic D: Package a database with a digital signature
Unit 6: Creating a Start-up Display Form
- Topic A: Create a display form
- Topic B: Set start-up options
CourseHorse Gift Card
Made in NYC