Microsoft Access 2010 Level 2

Level
Total time

Microsoft Access 2010 Level 2

Indicia Training
Logo Indicia Training

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

Microsoft Office Access 2010 Level 2


Duration

1 day


Course Overview

You will improve and customize tables, queries, forms and reports, and share Access data with other applications.

Target Audience

This course is designed for individuals who wish to learn intermediate-level operations of the Microsoft Office Access program. The target student may also include individuals whose job responsibilities include creating databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces them to integrating Access data with other applications such as Microsoft Office Word or Excel.
Prerequisites

Before starting this course,…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Microsoft Access, Microsoft Office, Microsoft Office (management), Programming (general), and IT Security.

Microsoft Office Access 2010 Level 2


Duration

1 day


Course Overview

You will improve and customize tables, queries, forms and reports, and share Access data with other applications.

Target Audience

This course is designed for individuals who wish to learn intermediate-level operations of the Microsoft Office Access program. The target student may also include individuals whose job responsibilities include creating databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces them to integrating Access data with other applications such as Microsoft Office Word or Excel.
Prerequisites

Before starting this course, students are recommended to take the following Indicia Training course or have equivalent knowledge:
· Microsoft Office Access 2010 Level 1


Course Objectives

Upon successful completion of this course, delegates will have the necessary skills to:

· Streamline data entry and maintain data integrity.
· Join tables to retrieve data from unrelated tables.
· Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.
· Improve forms.
· Customize reports to organize the displayed information and produce specific print layouts.
· Share data between Access and other applications.


Course Content
Relational databases
Database normalization
Table relationships
Referential integrity
Related tables
Creating lookup fields
Modifying lookup fields
Subdatasheets

Complex queries
Joining tables in queries
Using calculated fields
Summarizing and grouping values

Advanced form design
Adding unbound controls
Adding graphics
Adding calculated values
Adding combo boxes
Advanced form types

Reports and printing
Customized headers and footers
Calculated values
Printing
Labels

Charts
Charts in forms
Charts in reports

PivotTables and PivotCharts
PivotTables
Modifying PivotTables
PivotCharts
PivotTable forms

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.