| Dates for this class: |
| No dates are available for this class. |
| Course Details [choose new course] [printable version] |
| Access 2007: Macros and Database Management (Half-Day) |
| Course Number: APH0005 |
| Category: Business & Office Applications |
| Duration: 0.50 days |
Description
This half-day class builds on the skills and concepts taught in the Access 2007: Introduction class. Participants will learn how to create macros; import, export, and link database objects; optimize resources; and protect databases.
Outline
- Unit 1 : Macros
- Topic A: Creating, running, and modifying macros
- A-1: Creating and running a macro
- A-2: Modifying a macro
- Topic B: Attaching macros to the events of database objects
- B-1: Attaching a macro to the Open event of a form
- B-2: Attaching a macro to a command button
- Topic A: Creating, running, and modifying macros
- Unit 2 : Advanced macros
- Topic A: Creating macros to provide user interaction
- A-1: Creating a data validation macro
- A-2: Creating a data-entry macro
- Topic B: Creating macros that require user input
- B-1: Creating a macro that runs a parameter query
- Topic C: Creating the AutoKeys and AutoExec macros
- C-1: Creating an AutoKeys macro
- C-2: Creating an AutoExec macro
- Topic D: Creating macros for data transfer
- D-1: Importing a database object by using a macro
- D-2: Exporting data to a spreadsheet by using a macro
- Topic A: Creating macros to provide user interaction
- Unit 3 : Importing, exporting, and linking
- Topic A: Importing objects
- A-1: Importing multiple objects
- A-2: Importing an object from Excel
- A-3: Using a Saved Import specification
- A-4: Importing a CSV file
- Topic B: Exporting objects
- B-1: Exporting an object
- B-2: Using a Saved Export specification
- Topic C: Interacting with XML documents
- C-1: Exporting and importing XML documents
- C-2: Exporting to an XML document with an XSL file
- C-3: Saving to an XPS file
- Topic D: Linking Access objects
- D-1: Linking to an Access table
- D-2: Updating the links
- D-3: Linking to an Excel workbook
- Topic E: Working with Windows SharePoint Services
- E-1: Discussing Windows SharePoint Services
- Topic A: Importing objects
- Unit 4 : Database management
- Topic A: Optimizing resources
- A-1: Converting a database to a prior version
- A-2: Analyzing performance
- A-3: Splitting a database
- A-4: Using the Compact and Repair Database utility
- A-5: Backing up a database
- Topic B: Protecting databases
- B-1: Encrypting a database with a password
- B-2: Removing a password and encryption
- Topic A: Optimizing resources