Font size:

Description:

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

Course Price
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: $169.00
Total Savings: $130.80


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 Part 2 e-learning bundle
  • Course ID:
    252398
  • Duration:
    4 hours
  • Price:
    $169