Microsoft Office Access 2010: Transition from Access 2003
As a business professional, you may have worked with the earlier versions of Access such as Microsoft Access 2003. This course is designed for experienced Access users who want to use the upgraded version of Microsoft Access 2010 or those who want to examine the redesigned user interface and utilize its interactive features. In this course, you will explore the new features in and enhancements to Microsoft Access 2010, create tables, design forms, query a database, generate reports, import and export data and design databases for distribution on the web. Knowing the tools that allow you to accomplish these operations will greatly expand your Microsoft Office Access 2010 capabilities by enabling you to create a robust and highly functional database, and better management and distribution of your databases. This course is designed for experienced Access users who have worked with the earlier versions of Microsoft Access, ideally Microsoft Access 2003, and who have or are planning to upgrade to Microsoft Access 2010.
Course Length: 3 hours and 35 minutes
|
Microsoft Office Access 2010: Level 1
As a business professional you may need to use a database application to work with large amounts of data. This course is designed for users who want to use Microsoft Access 2010 to manage data. In this course, you will explore the features in Microsoft Access 2010 to create tables, design forms, query a database, and generate reports. Knowing the tools that allow you to accomplish these operations will greatly expand your Microsoft Office Access 2010 capabilities and enable you to create a robust and highly functional database, and better manage your data. This course is designed for students who wish to learn the basic operations of the Microsoft Access database program to perform their day-to-day responsibilities, and who want to use the application to be more productive in their work. It provides the fundamental knowledge and techniques needed to use more complex Access features such as maintaining databases and using programming techniques that enhance Access applications.
Course Length: 5 hours and 45 minutes
|
Microsoft Office Access 2010: Level 2
You have the basic skills needed to work with Microsoft® Office Access® 2010 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this course, you will consider how to maintain data consistency, customize database components, and share Access data with other applications. This course is designed for individuals who wish to learn intermediate-level operations of the Microsoft® Office Access® program. The target student may also include individuals whose job responsibilities include creating databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces them to integrating Access data with other applications such as Microsoft Office Word or Excel.
Course Length: 5 hours and 30 minutes
|
Microsoft Office Access 2010: Level 3
You have worked with the various Access objects, such as tables, queries, forms, and reports. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, and maintaining a database. This course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.
Course Length: 4 hours and 57 minutes
|
Microsoft Office Access 2007: New Features
This course provides an overview of the redesigned user interface and interactive features of Microsoft Office Access 2007. This course is designed for experienced Access users who have worked with earlier versions of Microsoft Access, ideally Microsoft Access 2003, and who have or are planning to upgrade to Microsoft Access 2007.
Course Length: 3 hours and 15 minutes
|
Microsoft Office Access 2007: Level 1 (Second Edition)
This course is designed for students who wish to learn the basic operations of the Microsoft Access database application to perform their day-to-day responsibilities, and to understand the advantages that using a relational database application can bring to their business processes. The Level 1 course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. Individuals who want to pursue Microsoft Certified Application Specialist certification in Microsoft Office Access 2007 can also take this course.
Course Length: 7 hours and 30 minutes
|
Microsoft Office Access 2007: Level 2 (Second Edition)
So far you have been focusing only on essential database user skills such as creating and working with Access tables, relationships, queries, forms, and reports. In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications. Microsoft Office Access 2007: Level 2 is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. The Level 2 course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications. This course is also a prerequisite to taking more advanced courses in Access 2007. Individuals who want to pursue Microsoft Certified Application Specialist certification in Microsoft Office Access 2007 can also take this course.
Course Length: 6 hours and 15 minutes
|
Microsoft Office Access 2007: Level 3 (Second Edition)
This course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft Office Specialist Certification for Microsoft Office Access 2007, and it is a prerequisite to take more advanced courses in Microsoft Office Access 2007.
Course Length: 5 hours and 30 minutes
|