Duration: 1.5 Hours

Microsoft Office Access 2007 makes it easy for you to create and manipulate database tables. You can choose between a Datasheet view and a Design view to create tables from scratch, or you can base your tables on one of the many pre-defined templates. The introduction of the Ribbon and contextual tabs in Access 2007 makes table creation even more intuitive, and provides you with easier data manipulation techniques. This course explains the use of table templates, Design and Datasheet views, field creation, data types, and modifiable properties, and demonstrates the use of masked input fields and indexing. The course also explores viewing, editing, navigating, sorting, finding, and filtering records, in addition to printing data and implementing and maintaining table relationships.

Duration: 2 Hours

Microsoft Office Access 2007 offers several options for creating, customizing, and managing forms. This course describes multiple methods of form creation, including the Form, Split Form, Multiple Items, Blank Form, and Form Design tools and the Form Wizard. This course also explores controls - the available types, how they are added to a form, how their properties are set, and how they are resized, moved, grouped, and positioned on a form. The course demonstrates how forms can be customized using autoformat, or by adding the date and time, page numbers, logos, and other decorative controls. The creation and management of records in forms using different navigational methods, sorting and filtering options, and printing forms is also covered.

Duration: 2.5 Hours

Queries and reports are used in Access 2007 to convert data into useful information and are an essential part of any database application. Access 2007 has a Query Wizard which simplifies the process of formulating a query and provides various methods of creating reports to present summarized information easily and effectively. This course explores the use of the Query Wizard and demonstrates how to create or modify a query in Design view in order to achieve specific results. This course also covers Expression Builder, calculated fields, grouping options for displaying query results, and crosstab, unmatched, and duplicate queries. The use of the Report, Report Wizard, Blank Report, Report Design, and Label options are covered, as well as how to add and bind controls, group and sort data, and modify sections of a report.

Duration: 2 Hours

Microsoft Office Access 2007 offers several options for importing and exporting data, and also provides a variety of data presentation strategies. With Access 2007 you can link to, or import data and objects from external sources such as other Access databases, Excel spreadsheets, text files, XML files, and SharePoint lists. You can also export data and objects from an Access 2007 database to external sources. This course explains and demonstrates the various methods of importing, exporting, and linking to external data sources. It also describes how to create and modify PivotTables and PivotCharts as an alternate way to organize and present database data. The options used to apply aggregate functions to a PivotTable, add a calculated field to a PivotTable, and export a PivotTable to an Excel spreadsheet are also discussed in the course.

Duration: 3.5 Hours

You can use Microsoft Access 2007 to manage your data efficiently using advanced techniques. There are many advanced methods that can be used for modifying and enhancing tables, reports, queries, and forms in order to meet your business needs. This course explains and demonstrates retrieving and validating data, using subforms and subreports, as well as applying conditional formatting in Access 2007 tables, forms, and reports. Advanced query methods make it easy for an experienced end-user to retrieve the results they desire and to have those results displayed in such a way that the data is easy to interpret and analyze. This course describes the various types of join and parameter queries that can be used in Access 2007 and provides demonstrations on the use of action queries, including update, append, delete, and make table queries. It also explores the use of SQL-specific queries such as data-definition, pass-through, subquery, and union queries.

Duration: 3 Hours

Microsoft Office Access 2007 makes it easy for you to share and manage data using the collaborative environment of a Microsoft Windows SharePoint site along with the many data management features available within Access 2007. This course explains how SharePoint sites can be used with Access and demonstrates options such as moving data to a SharePoint site, publishing data to a SharePoint site, importing from or linking to a SharePoint list, creating an Access view of a SharePoint list, working offline with SharePoint lists, as well as tracking data versioning in SharePoint. Another feature of Access 2007 is its programmability. Using Access macros and Visual Basic for Applications (VBA) code you can easily add functionality to a database to suit your business needs. In addition to SharePoint integration, this course provides an introduction to programming in Access and explores when to use macros or VBA code to automate processes. It also demonstrates how to create, launch, and modify macros and explains the use of the Visual Basic Editor to create event handlers and set control property values.

Duration: 1.5 Hours

Microsoft Office Access 2007 makes it easy for you to share and manage data using the collaborative environment of a Microsoft Windows SharePoint site along with the many data management features available within Access 2007. This course explains how SharePoint sites can be used with Access and demonstrates options such as moving data to a SharePoint site, publishing data to a SharePoint site, importing from or linking to a SharePoint list, creating an Access view of a SharePoint list, working offline with SharePoint lists, as well as tracking data versioning in SharePoint. Another feature of Access 2007 is its programmability. Using Access macros and Visual Basic for Applications (VBA) code you can easily add functionality to a database to suit your business needs. In addition to SharePoint integration, this course provides an introduction to programming in Access and explores when to use macros or VBA code to automate processes. It also demonstrates how to create, launch, and modify macros and explains the use of the Visual Basic Editor to create event handlers and set control property values.

Duration: N/A

To test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.