This course covers getting started with Access 2007, basic tables, basic forms, queries, reports, importing and exporting data and data presentation in Access 2007. The training will also teach you how to use advanced data management, programmability and administration as well as database administration in Access 2007.

Upon successful completion of this Microsoft Office Access 2007 training course, you will be fully prepared to sit for the Microsoft Office Specialist Exam 77-605 MOS: Microsoft Office Access 2007. All of our Microsoft Office 2007 training courses map to MOS certification paths.

Expected Duration (hours) – 18.5
Mentoring – Mon-Fri (9-5 EST)

Price: USD $149.00

USD

Getting Started with Access 2007

• plan a database
• match the main elements of the Access 2007 screen with their functions
• use Access Help
• plan a database
• use Access Help
• create a database from scratch
• create a database from a template
• add a blank datasheet to a database
• use views
• create an Access database and add a datasheet
• change the view

Basic Access 2007 Tables

• create a table from a template in a given scenario
• identify the elements in an Access 2007 table
• identify the table templates
• create a table using Datasheet view
• create a table using Design view
• modify a table
• modify a table in Design view
• create a validation rule
• create a masked input field in a table
• apply indexing to a table
• create a table from a template
• modify a table
• create a table in datasheet view and add a validation rule
• create an input mask
• manipulate data in records in Access 2007
• view, edit, and navigate records
• sort and filter data
• find and replace data
• print records
• create a relationship
• filter table information
• create a relationship
• edit a relationship
• create a relational database in Access 2007

Basic Access 2007 Forms

• create a form in Access 2007
• add controls to Access 2007 forms
• configure controls on an Access 2007 form
• bind controls to a field in Access 2007
• configure bound controls in Access 2007
• create a form using the Form Wizard
• add and configure an unbound control
• create a bound control and configure the record source
• customize forms in Access 2007
• format forms in Access 2007
• create and modify records
• navigate between Access 2007 records
• sort and filter Access 2007 records
• format an Access 2007 form
• create and modify a record in Access 2007
• sort and filter Access 2007 records

Queries and Reports in Access 2007

• create a simple query in design view
• create a simple query using the Simple Query Wizard
• modify a query in Access 2007
• create an expression with the Expression Builder
• use calculated fields and grouping in Access 2007
• create a crosstab query in Access 2007
• refine a crosstab query in Access 2007
• find unmatched queries in Access 2007
• find duplicate queries in Access 2007
• create and run a query in design view
• group a query by an aggregate function
• change an aggregate value for a crosstab query
• use the Find Unmatched Query wizard
• create a basic report in Access 2007
• add a control to an Access 2007 report
• recognize how to modify Access 2007 reports
• add a group and calculated summary to a report in Access 2007
• create a report using the Report Wizard
• add a control to a report and bind it to a field
• add a grouping to an Access 2007 report
• add a calculated summary to a group

Importing and Exporting Data and Data Presentation in Access 2007

• 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

• 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

Programmability and Administration in Access 2007

• 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

• 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