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

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

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

Price: USD $149.00

USD

Getting Started with Access 2010

• Recognize the fundamentals of Access 2010 databases
• Plan a basic Access 2010 database
• Recognize key features of the Access 2010 interface and their functions
• Create a database using a template
• Create a blank database
• Create a database from a template
• Create a blank database
• Add application parts to a database

Creating Basic Tables in Access 2010

• Recognize the correct naming convention for tables
• Create tables in Design view
• Create tables in Datasheet view
• Create a primary key for a table
• Create input masks for table fields
• Create indexes for table fields
• Create validation rules
• Modify tables
• Create a basic table
• Modify a basic table

Data Manipulation and Simple Relationships in Access 2010

• Modify how data is presented in datasheets
• Sort and filter records in datasheets
• Find and replace data in records
• Import data from an Excel spreadsheet into an Access database
• Export data from one Access database to another
• Recognize key characteristics of table relationships
• Create table relationships in a database
• Edit table relationships
• Sort and filter records
• Find and replace data
• Import and export data
• Create and edit table relationships in a database

Introduction to Forms in Access 2010

• Create basic forms
• Recognize how Layout view and Design view are used when modifying basic forms
• Configure controls on a form
• Configure a Web Browser Control on a form
• Configure input masks for bound controls
• Configure a control that refers to a control in another form
• Create a basic form
• Configure controls on a form

Modifying Basic Forms in Access 2010

• Customize forms
• Format forms by creating your own themes
• Manage records in forms
• Sort and filter records in forms
• Work with navigation forms
• Use a theme to format a form
• Manage records in forms
• Create a navigation form

Introduction to Queries in Access 2010

• Recognize the basic characteristics of queries
• Create basic select queries
• Modify queries
• Use calculations to refine query data
• Apply grouping and calculating functions to query results
• Create crosstab queries
• Create unmatched queries
• Create find duplicates queries
• Create and modify a Select query
• Refine a query using groupings and calculations
• Create a Crosstab query
• Create a Find duplicates query

Introduction to Reports in Access 2010

• Distinguish between the tools used to create reports
• Create reports using client-compatible and web-compatible report tools
• Create reports using non-web-compatible report tools
• Organize Access reports
• Add controls to a report
• Apply data bars to a report control to present data
• Create a chart in a report to present data
• Create a report using a client-compatible and web-compatible report tool
• Create a report using a non-web-compatible report tool
• Group data in a report
• Add controls to a report

Advanced Importing and Exporting with 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

• 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
• Use a PivotChart to analyze data
• Create a PivotTable and manipulate its data
• Create a PivotChart and manipulate its data

Retrieving, Validating, and Attaching Data in Access 2010

• 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

• 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

• 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

• 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

• 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

• 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