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
Joins, SQL, and Action Queries in Access 2010 $74.95
Using Access 2010 with SharePoint and Access Services $74.95
Access 2010 Macros and VBA $74.95
Optimizing, Securing, and Sharing Access 2010 Databases $74.95

Bundle Price: $289.00
Total Savings: $310.60


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

Joins, SQL, and Action Queries in Access 2010

Advanced query methods in Access 2010 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 2010 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.
  • create and edit joins in Access 2010 databases
  • creates a parameter query
  • modify data in existing tables
  • create a new table from data in other tables
  • delete data from an Access 2010 database
  • identify how to create a union queries
  • modify an object within a database using a data-definition query
  • access a hosted database with a view to running a pass-through query
  • remove duplicate records from a table using a subquery
  • specify a join in a query
  • use action queries to modify a database
  • create and refine queries using SQL

Using Access 2010 with SharePoint and Access Services

Access 2010 and Windows SharePoint Services provide a tightly integrated solution for making Access databases web capable. This course details the primary features that allow for the seamless integration of Access and SharePoint so that data can be shared across corporate networks or the Internet. It demonstrates how to share Access and SharePoint data, and how Access and SharePoint work together with a new feature called Access Services to make entire applications available through SharePoint.
  • identify key characteristics of SharePoint and its integration with Access 2010
  • share data by linking Access to a SharePoint list
  • share data by exporting Access tables to SharePoint
  • share data by moving Access tables to SharePoint
  • use templates to create new SharePoint lists in Access
  • identify key characteristics of publishing Access 2010 applications on SharePoint
  • publish the entire Access application to SharePoint
  • share Access and SharePoint data
  • publish the entire Access application to SharePoint

Access 2010 Macros and VBA

Using Access macros and Visual Basic for Applications (VBA) code, you can easily add functionality to a database to suit your business needs. This course provides an introduction to programming in Access 2010 and explores when to use macros or VBA code to automate processes. It demonstrates how to create and modify different types of macros as well as how to specify actions, conditions, and event handlers.
  • create macros
  • execute macro actions conditionally
  • create data macros
  • work with data macros
  • recognize situations when you should use macros or VBA
  • convert macros to VBA
  • create macros
  • create a data macro
  • convert a macro to VBA

Optimizing, Securing, and Sharing Access 2010 Databases

Access 2010 provides a variety of tools to assist you in optimizing, securing, and sharing a database application. This course demonstrates how to assess a database's performance and improve its efficiency. Also covered are the ways that you can secure a database for users and the common methods employed to share a completed database application.
  • use the Performance Analyzer to assess and improve database performance
  • use the Object Dependencies pane
  • use the Database Documenter to create a report on database objects
  • use the Table Analyzer Wizard to analyze and organize new data
  • describe how the Access 2010 security architecture works
  • manage signed packages
  • split a database
  • create a package solution for installing a database application on a client computer
  • specify an appropriate method of sharing an Access database
  • optimize the performance of an Access database
  • secure an Access database
  • share an Access database
Register Now
Microsoft Office 2010: Advanced Access e-learning bundle
  • Course ID:
    271416
  • Duration:
    n/a
  • Price:
    $289