Font size:

Description:

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

Course Price
Getting Started with Access 2010 $74.95
Creating Basic Tables in Access 2010 $74.95
Data Manipulation and Simple Relationships in Access 2010 $74.95
Introduction to Forms in Access 2010 $74.95
Modifying Basic Forms in Access 2010 $74.95
Introduction to Queries in Access 2010 $74.95
Introduction to Reports in Access 2010 $74.95

Bundle Price: $239.00
Total Savings: $285.65


Getting Started with Access 2010

Access 2010 is the newest version of Microsoft's dynamic database management tool and it offers features that allow you to create and modify a variety of database types. The ribbon is unique to Microsoft Office and stacks the many features of Access into related tabs, making it easy to quickly access the ones you need. Backstage view is a streamlined gathering of all database file-level tools, such as those used for saving, creating databases and tables, and working with external data. This course explores the fundamentals of databases and the many tools that will help you create and modify databases in 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

Microsoft Office Access 2010 makes it easy for you to create and modify database tables. This course discusses how basic tables are built, including creating fields and defining data types and properties, and how to modify them. It also demonstrates the use of primary keys, masked input fields, and indexing, as well as creating validation rules for the data.
  • 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

The ability to manipulate data, records, and relationships in Access 2010 is a valuable asset to any database administrator. Access 2010 provides you with the data manipulation and table relationship techniques necessary for reliable databases. This course demonstrates how to perform basic data manipulation tasks, how to import and export data, and how to implement and edit table relationships.
  • 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

Microsoft Office Access 2010 offers several options for creating and managing forms and controls. This course describes how to create forms in Access 2010 and also explores controls - the available types, how they are added to a form, how their properties are set, and how they are resized, moved, grouped, and positioned on a form. It also demonstrates how to configure the Web Browser Control, which is a new feature of 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

Access 2010 allows you to make a variety of changes to the look and feel of a form. These changes range from resizing columns and controls to applying Office 2010 themes and managing records in a form. Access 2010 also introduces a new form type, the navigation form, which you can use as a switchboard to navigate the various objects in a database. This course covers how to use these methods to customize and format forms in Access 2010 as well as how to create and modify navigation forms.
  • 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

Queries are used in Access 2010 to convert data into useful information and are an essential part of any database application. This course demonstrates how to create and modify a query in order to achieve specific results. It covers creating basic select queries, using Expression Builder, calculated fields, and grouping options for displaying query results. This course also demonstrates how to create crosstab, unmatched, and find duplicates queries.
  • 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

Reports are used in Access 2010 to convert data into useful information and are an essential part of any database application. Access 2010 provides various methods of creating reports to present summarized information easily and effectively. This course demonstrates the use of the Report Wizard, Blank Report, Report Design, and Labels. Also covered is how to add and bind controls, group and sort data, and perform calculations.
  • 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
Register Now
Microsoft Office 2010: Beginning Access e-learning bundle
  • Course ID:
    252394
  • Duration:
    7 hours
  • Price:
    $239