Font size:

Description:

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

Course Price
Modifying Tables in Access 2013 $74.95
Creating and Modifying Queries in Access 2013 $74.95
Creating and Modifying Forms in Access 2013 $74.95
Creating and Modifying Reports in Access 2013 $74.95
Creating and Populating a Database in Access 2013 $74.95

Bundle Price: $199.00
Total Savings: $175.75


Modifying Tables in Access 2013

Microsoft Office Access 2013 makes it easy for you to modify database tables. It allows you to customize the table fields, and control and restrict data entry. You can modify the records and sort and filter them. And, you can also customize the visual appeal by formatting the table. This course explores ways to modify tables. It will cover creating and modifying fields, controlling data entry with required fields, indexing, input masks, and data validation rules. The course will also cover ways manage records including adding, updating, deleting records, as well as sorting and filtering. Finally, it will cover ways to format a table.
  • create and modify fields in Access 2013
  • control how data may be entered into a database in Access 2013
  • decide how to create fields and control data entry in Access 2013
  • add and modify records in Access 2013
  • sort and filter records in Access 2013
  • manage records in Access 2013
  • format a table in Access 2013
  • decide how to format a table in Access 2013

Creating and Modifying Queries in Access 2013

Microsoft Access 2013 includes a collection of query options to help make creating and modifying queries, easy. Access provides a number of query types with the ability to review data before running the queries. You can update or delete data that meets a certain criteria, request user input, and add calculated fields to queries. You can also group and summarize your data in queries. This course explores creating queries through the Query Wizard and Query Design. It also covers different types of queries like the Update and Delete queries, as well as the Parameter query. This course will cover adding new fields to queries, saving queries, and renaming them. It will also cover hiding or removing fields from queries as well as deleting queries. Finally, this course shows how to add calculated fields to queries, and group and summarize data in a query.
  • filter data in Access 2013 with queries
  • modify data in Access 2013 with queries
  • create user-defined input queries in Access 2013
  • decide how to create queries in Access 2013
  • edit and save queries in Access 2013
  • hide and delete query fields in Access 2013
  • decide how to modify queries in Access 2013
  • add calculated fields and grouping in Access 2013
  • decide how to customize a query in Access 2013

Creating and Modifying Forms in Access 2013

Microsoft Office Access 2013 offers several options for creating and managing forms. You can link the forms to tables and queries by adding bound controls. You can also make a variety of changes to the look and feel of a form. This course describes how to create forms in Access 2013. It covers creating basic forms from scratch, from an existing table, or using the Form Wizard. It includes adding and setting form controls, as well as creating forms from application parts. Finally, this course will demonstrate ways to format a form.
  • create a form based on existing data in Access 2013
  • decide how to create forms based on existing data in Access 2013
  • design a form from scratch in Access 2013
  • choose how to create forms from scratch in Access 2013
  • create forms with application parts in Access 2013
  • choose how to create forms with application parts in Access 2013
  • format a form in Access 2013
  • determine how to format forms in Access 2013

Creating and Modifying Reports in Access 2013

Microsoft Access 2013 reports are used to convert data into useful information and are an essential part of any database application. It provides various methods of creating reports to present summarized information easily and effectively. This course demonstrates the use of the Report Wizard, Blank Report, and Report Design. Also covered is how to add and bind controls, group and sort data, and format and print reports.
  • create a report based on existing data in Access 2013
  • decide how to create a report in Access 2013
  • create a report from scratch in Access 2013
  • determine how to create a report from scratch in Access 2013
  • sort and group data in reports in Access 2013
  • determine how to sort and group data in a report in Access 2013
  • format a report in Access 2013
  • prepare to print a report in Access 2013
  • decide how to format and prepare to print a report in Access 2013

Creating and Populating a Database in Access 2013

Access 2013 is the newest version of Microsoft's dynamic database management system and it offers features that allow you to create and modify a variety of database types through a convenient graphic user interface. Access, as a desktop application, helps you store and manage related information in one place. It helps prevent errors, inconsistencies, and duplicate information. This course explores the fundamentals of databases and the many tools that will help you create and modify databases in Access 2013. It will cover creating and saving databases, creating and renaming tables, importing and linking data, as well as creating relationships between tables.
  • create a desktop database in Access 2013
  • create a table from scratch in Access 2013
  • decide how to create a database and table in Access 2013
  • import data and link to data in Access 2013
  • create a database template in Access 2013
  • decide how to populate a database with tables in Access 2013
  • decide how to create a database template in Access 2013
  • create relationships in a database in Access 2013
  • decide how to create relationships between tables in a database in Access 2013
Register Now
Microsoft Office 2013: Beginning Access e-learning bundle
  • Course ID:
    252368
  • Duration:
    5 hours
  • Price:
    $199