Microsoft Access 2010 Level 2
Starting dates and places
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,…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
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
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.