Your Career
Training Marketplace

Questions? Call Toll-Free: 1-866-540-9677

Virtual Live Remote Training
Course ID: 252397

e-Learning Bundle

Microsoft Office 2010: Advanced Access Part 1

When you register for training with TrainUp.com, you are also supporting local education. Find out how.

  • Instant Access
    From Anywhere
  • Unlimited
    Viewing
  • 6-12 Months
    To Complete

Agenda

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
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
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 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

Join The 50,000+ Companies That Have Purchased Training from TrainUp.com

  • 50K+ Companies Trained

    Including 90% Of Fortune 500 Companies Have Purchased Training With TrainUp.com

  • 300K+ Courses & Videos

    Live Instructor-Led (Classroom & Virtual), Self-Paced E-learning & Custom OnSite Training Solutions From Leading Training Providers

  • 800+ Expert Instructors

    Industry-Leading Subject Matter Experts (SMEs).Tenured &
    Award-Winning Instructor Network

Get the latest industry news, recommended courses, & promotions from TrainUp.com sent straight to your inbox.