2015
Udemy
IsaBel Harrison
1:45
English
When you used command buttons to open, print, or analyze forms and reports, and compared that to manually navigating/analyzing your database, what did you find?
More control over the database? Work done faster? Feeling of efficiency?
This course, designed to help you create macros for Access databases for day-to-day use, will allow you to:
Become familiar with the Macro Builder window
Create macros for tables
Attach macros to buttons on forms and reports
Create macros that start when your database starts
Section 1: Introduction
1 Welcome to Upgrade Your Microsoft Access Skills with Macros
2 Pre Course Quiz - 11 questions
Section 2: Getting Familiar with Microsoft Office Access Macros
3 The Macro Builder Window
4 Actions & Arguments
5 Sharing Your Macros with Others
6 Converting a Macro to VBA
Section 3: Data Event Macros Attached to Tables
7 Introduction
8 Using Before Change to Populate Field Values
9 Using Before Delete to Raise Errors
10 Using After Insert to Send E-mails
11 Using After Update to Automatically Create Records in Other Tables
12 Using After Delete to Log Events
Section 4: Events Attached to Objects
13 Overview of Object Events
14 Click Events
15 Focus Events
16 Mouse Events
17 Keyboard Events
18 Text box Events
19 Combo box Events
20 Form Events
21 Report Events
Section 5: Macros Attached to Forms
22 E-mailing the Contact on a Form
23 Importing Contacts from Microsoft Office Outlook
24 Creating an Outlook Contact from Form Information
25 Opening a Report
26 Opening a Report with a Filter Condition
27 Automating Data Entry
28 Requiring Data Entry
29 Filtering Form Records
Section 6: Macros Attached to Reports
30 E-mailing a Report
31 Saving a Report as a PDF
32 Cancel Printing a Blank Report
Section 7: More Macros
33 Exporting a Table to Excel
34 Importing an Excel File
35 Running Macros at Startup
Section 8: Wrap Up
36 Conclusion
37 BONUS: Step by Step eBook
Download File Size:380.97 MB
|
