Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Advanced Importing and Exporting with Access 2010 $74.95
PivotTables and PivotCharts in Access 2010 $74.95
Retrieving, Validating, and Attaching Data in Access 2010 $74.95
Subforms, Subreports, and Conditional Formatting in Access 2010 $74.95

Bundle Price: $169.00
Total Savings: $130.80


Advanced Importing and Exporting with Access 2010

Microsoft Office Access 2010 offers several advanced options for importing and exporting data. With Access 2010 you can link to, or import data and objects from external sources, such as other Access databases, SQL Server databases, Excel spreadsheets, Microsoft Word files, and XML files. You can also export data and objects from an Access 2010 database to a variety of external sources. This course explains and demonstrates the various methods of importing, exporting, and linking to external data sources in Access 2010.
  • import data from one Access database into another Access database
  • import data from SQL Server into an Access database
  • link an Access database to data in SQL Server
  • export data from an Access database to a Word document
  • export data from an Access database to an Excel spreadsheet
  • export data from an Access database to an XML document
  • collect data by using e-mail messages
  • import Outlook 2010 contacts to a new Access 2010 table
  • import data in Access
  • export data from Access to other applications
  • use e-mail messages to collect data in Access
  • import an Outlook 2010 folder to a new Access 2010 table

PivotTables and PivotCharts in Access 2010

This course demonstrates how to create and manipulate PivotTables and PivotCharts as an effective way to organize and display Access 2010 database data, such as showing and hiding data, sorting and filtering data, performing basic and complex calculations, and exporting to an Excel spreadsheet.
  • identify key characteristics of Access PivotTables
  • create a PivotTable in an Access database
  • use a PivotTable to analyze data
  • create a PivotChart in an Access database
  • edit a PivotChart
  • create a PivotTable and manipulate its data
  • create a PivotChart and manipulate its data

Retrieving, Validating, and Attaching Data in Access 2010

You can use Microsoft Access 2010 to manage your data efficiently using advanced techniques. There are many 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 advanced techniques for retrieving and validating data in Access 2010. These include such features as lookup fields and using the Expression Builder to aid in the validation of controls. How to attach files to tables and forms, and edit them, is also demonstrated.
  • create a lookup field for data entry
  • modify the behavior of a lookup field
  • validate control data on a form using the Expression Builder
  • identify ways that attachments can be used in Access 2010
  • add an attachment to a table
  • add an attachment to a form
  • create a lookup field and change its behavior
  • validate control data on a form
  • add an attachment to a table
  • add an attachment to a form

Subforms, Subreports, and Conditional Formatting in Access 2010

Subforms and subreports allow you to display related data from separate sources in a single interface in Access 2010. This course will demonstrate how to use Access 2010 to create and use subforms and subreports. It also explores how to apply conditional formatting to tables, forms, and reports using the streamlined conditional Formatting Rules Manager.
  • create subforms
  • set the default view of a subform
  • create subreports
  • make design change subreports
  • apply conditional formatting to data in a report
  • change the priority of a conditional formatting rule
  • add a subform to a form and set it's default view
  • add a subreport to a report and prepare to make subsequent design alterations
  • use conditional formatting in a report
Register Now
Microsoft Office 2010: Advanced Access Part 1 e-learning bundle
  • Course ID:
    252397
  • Duration:
    4 hours
  • Price:
    $169