A New York State Certified Woman-Owned Business Enterprise
BEAHIVE Training in Downtown Albany!
MicroKnowledge, Inc.
21 British American Blvd.
Latham, NY 12110
Phone: 518.786.1181
Fax: 518.786.6221
Access 2007 Advanced
Description:
This course covers important topics related to creating or administering an Access database. Learn to build queries using SQL, create action queries, perform common database management tasks, create dynamic forms using macros, and optimize performance.
This course is recommended for individuals who are very familiar with Access but would benefit from learning a variety of advanced features.
Includes:
Microsoft Office Specialist (MOS) approved courseware
Downloadable CertBlaster© MOS Exam Preparation software
Access to participant data files
Follow-up support by email or phone for an unlimited period
Lesson 1: Querying with SQL
- SQL and Access
- Writing SQL statements
- Creating SQL-specific queries
Lesson 2: Advanced queries
- Creating crosstab queries
- Creating parameter queries
- Using action queries
Lesson 3: Macros
- Creating, running, and modifying macros
- Attaching macros to events
Lesson 4: Advanced macros
- Using data validation macros
- Creating macros that require user input
- Creating the AutoKeys and AutoExec macros]
- Creating macros for data transfer
Lesson 5: Importing, exporting, and linking objects
- Importing data from Access
- Importing data from spreadsheet
- Exporting data to Access
- Exporting data to spreadsheet
- Linking Access objects
Lesson 6: Database management
- Using a database in a network environment
- Optimizing resources
- Protecting databases
- Setting options and properties
Lesson 7: Internet integration
- Hyperlink fields
- Working with Outlook 2007
