Font size:

Description:

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

Course Price
Programmability and Administration in Access 2007 $74.95
Database Administration in Access 2007 $74.95
Importing and Exporting Data and Data Presentation in Access 2007 $74.95
Advanced Data Management in Access 2007 $74.95

Bundle Price: $169.00
Total Savings: $130.80


Programmability and Administration in Access 2007

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.
  • determine how to move data to a SharePoint site
  • specify how to publish data to a SharePoint site
  • create an Access view of a SharePoint list
  • work with SharePoint lists
  • take SharePoint list data offline
  • work offline and track data in Access 2007
  • move data to SharePoint using the Move to Sharepoint Site wizard
  • publish a database to a Sharepoint site |w
  • import a SharePoint list to Access 2007
  • view different versions of a SharePoint list item
  • create and edit Access 2007 macros
  • run Access 2007 macros
  • use VBA to create an event handler in Access 2007
  • work with event handlers in Access 2007
  • create an Access 2007 macro
  • run an Access 2007 macro
  • edit an Access 2007 macro
  • create an event handler in Access 2007

Database Administration in Access 2007

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.
  • customize datasheets in Access 2007
  • recognize how to compact and repair a database
  • illustrate how to convert earlier Access database formats to Access 2007
  • specify how to back up databases and restore database files
  • customize the datasheet view in Access 2007
  • convert an earlier Access database to Access 2007 format
  • change the default file format of an Access 2007 database
  • outline how to view and change object dependencies in Access 2007
  • illustrate how to analyze objects for performance
  • outline how to use the database documenter and the Table Analyzer wizard to optimize database performance
  • use the performance analyzer
  • use the Database Documenter
  • use the Table Analyzer wizard
  • view an object's object dependencies
  • identify how to enable content for an Access 2007 database
  • recognize how to hide a database object
  • summarize how to encrypt a database by setting a database password
  • restate how to protect VB code in Access 2007
  • determine how to split a database and repair database links
  • use an Office Access 2007 database in a trusted location
  • restate how to package, sign, and distribute an Office Access 2007 database
  • protect a database by setting a database password
  • add a new location to the trust center
  • split a database
  • create a signed package
  • outline how to work with switchboards and the Navigation Pane
  • outline how to create a custom group and add objects to it

Importing and Exporting Data and Data Presentation in Access 2007

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.
  • import data into an Access 2007 database
  • distinguish between the options available for importing data into Access 2007
  • export Access 2007 data
  • distinguish between the formats you can export to from Access 2007
  • set up data collection in Access 2007
  • collect data by using e-mail messages
  • import an object into an Access 2007 database
  • export a database object to Excel
  • collect data using e-mail messages
  • build an Access 2007 PivotTable
  • modify a PivotTable in Access 2007
  • build a PivotChart in Access 2007
  • modify an Access 2007 PivotChart
  • create a PivotTable in Access 2007
  • create a PivotChart in Access 2007
  • modify a PivotTable
  • modify a PivotChart

Advanced Data Management in Access 2007

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.
  • add a lookup field to an Access 2007 table
  • add a subdatasheet to a table
  • add attachments to Access 2007 records
  • implement data validation in Access 2007
  • add a lookup field to a table
  • add a subdatasheet to a table |w
  • use Expression Builder to construct a rule
  • add Subforms to an Access 2007 database
  • add Subreports to an Access 2007 database
  • apply conditional formatting to a form in Access 2007
  • add a subform to an existing form
  • apply conditional formatting to a form
  • add a subreport to a database
  • create and edit joins in Access 2007 databases
  • create and use simple parameter queries
  • create and run update and append queries in Access 2007
  • create and run a make table query
  • delete data from an Access 2007 database
  • create union queries in Access 2007
  • recognize how to create or modify Access 2007 tables and indexes using data-definition queries
  • perform SQL processing on a server
  • edit the SQL of a SELECT query and use subqueries
  • specify a join in a query
  • create and run a parameter query
  • create and run an update query
  • edit the SQL of a SELECT query
  • use SQL to create Access 2007 queries
Register Now
Microsoft Office 2007: Advanced Access e-learning bundle
  • Course ID:
    252418
  • Duration:
    10 hours
  • Price:
    $169