Access 2007, Advanced
Your training in and use of Microsoft® Office Access 2007 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft® Office Access 2007. You're now ready to extend your knowledge into some of the more specialized and advanced capabilities.
Audience
The target student for this course should be comfortable using a personal computer and Microsoft Windows XP or later. Students should also have some experience using Access 2007. They’ll get the most out of this course if their goal is to become proficient using more advanced Access features and functions, such as querying with SQL, using crosstab, parameter, and action queries, creating and running macros, importing, exporting and linking database objects, optimizing a database, and basic database security.
- To ensure the successful completion of Microsoft® Office Access 2007™: Advanced, the following courses or equivalent knowledge are recommended for familiarity with: Basic and intermediate features of Access tables, Relationships, Queries, forms, and reports.
Upon successful completion of this course, students will be able to:
- Use SQL statements and examine them in Access, create aliases for fields, write SQL statements to create queries, and attach an SQL statement to a command button.
- Create crosstab queries to summarize grouped data, create parameter queries to view results based on specified criteria, and create action queries to add, delete, and modify data in tables and to make new tables.
- Create and run macros to automate tasks and attach macros to the events of database objects.
- Create data validation and data-entry macros, create macros that rn parameter queries, create the AutoKeys and AutoExec macros, and create macros to import and export database objects.
- Import Access objects from another Access database, from Excel, and from a CSV file. Export objects from one database to another. Create and use Save Import specifications and Saved Export Specifications. Export and import XML documents and save objects as an XPS file. Link objects from one database to another and update the links, and link to Excel workbooks. Export and import tables and queries to the Windows SharePoint Services site.
- Save to previous versions. Split, compact, repair, and back up a database. Encrypt and password-protect database files. Configure Access Options and populate database file properties.
- Create, populate, and modify a hyperlink field. Collect data via e-mail by using Outlook 2007.
- CertBlaster preparation and materials also included.
- Unit 1: Querying with SQL
- Unit 2: Advanced queries
- Unit 3: Macros
- Unit 4: Advanced macros
- Unit 5: Importing, exporting, and linking
- Unit 6: Database management
- Unit 7: Internet integration
In order for a class to be successful, all students should share the same general level
of knowledge and experience. If a participant does not demonstrate these, the instructor will take
the necessary steps either to prepare the participant or place him/her in a more appropriate course.
This policy is intended to maintain the high level of quality control that you have come to expect.