ITdatacorp - Access 2007 Advanced

Home | About us | Contact us | Sitemap | Login

You have [0] item(s) in your Shopping Bag

Categories

PRODUCTS

Help Desk

Ask a subject-matter expert to clarify concepts, fine-tune solutions, confirm a process, or simply seek assurance that you understand an application.
more info

Access 2007 Advanced

Manufacturer: MindLeaders

Regular Price: $39.99
On Sale For: $32.99
You Save: $7.00

	Course Review
	Email this to a friend.

This series covers how to use Access 2007 to create, modify, and access databases. It shows the learner how to use the Ribbon-based Access 2007 interface, as well as how to build tables, forms, and reports. Learners will also be able to use queries and filters to sort through data.

Total Items: 3 Total Time: 9.00 hour(s) Subscription Term: 12 month(s)

Audience:

This series is for anyone who wants to move beyond the basic concepts of Microsoft Access.

Features:

Flash and audio provide animated, interactive Lesson Introductions, Activities, and Simulations.
Audio accompanies each lesson page throughout the course.
Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
Activities allow learners to apply course concepts in an interactive questioning environment.
Full-page images allow learners to experience an application as if it were open on their computer.
Exercises allow learners to practice in the actual application being studied.
Supplied sample files include sample documents, application files, programs, and programming code that enable learners to practice with these files, enhancing the learning experience.
A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
Search text enables learners to rapidly search all text within a course to easily retrieve information required.
Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
A skill assessment generates a customized learning path based on the results of a pre-test.
A glossary provides a reference for definitions of unfamiliar terms.
Bookmarking tracks a learner's progress in a course.

Lesson 1: Access 2007 Advanced Series: Expressions and Queries - 3 Hours

Summary:

This course focuses on the use of VBA functions when creating queries, and examples of queries that use the four basic types of joins you can create in Microsoft Access 2007.

Objectives:

After completing this course, students will be able to:

Discuss the elements of expressions

Use the Immediate window to test return values of VBA functions

Describe the use of inner joins, outer joins, self-joins, and theta joins in queries

Create crosstab queries using the Crosstab Query Wizard

Topics:

Expressions, operators, literals, constants

Working with functions

Types of functions

Creating expressions

Using inner joins for multitable queries

Using outer, self, and theta joins

Creating crosstab queries

Lesson 2: Access 2007 Advanced Series: PivotTables, PivotCharts, and Graphs - 3 Hours

Summary:

This course provides an introduction to working with PivotTables and PivotCharts.

Objectives:

After completing this course, students will be able to:

Describe the main features of PivotTables and PivotCharts

Create a query for a PivotTable

Create, optimize, and export PivotTables

Create and modify PivotCharts

Create and modify Graphs

Topics:

Working with PivotTables

Creating PivotTables

Exporting and optimizing PivotTables

Working with PivotCharts

Working with graphs

Modifying graphs

Using PivotChart forms

Lesson 3: Access 2007 Advanced Series: Macros and Data Imports/Exports - 3 Hours

Summary:

This course focuses on the use of macros and the ability to import and export data between Microsoft Access 2007 and other programs.

Objectives:

After completing this course, students will be able to:

View macro events and actions

Create embedded macros

Import and link data from Excel

Import text data

Export Access data

Import and export XML data

Topics:

Introducing macros and events

Generating embedded macros

Importing and linking Excel data

Importing text files

Exporting data from Access

Importing XML data

Exporting tables and queries to XML