Microsoft Access 2010 Training Tutorial Course
AVI | Resolution: 800×600 | Audio: PCM Audio 22050Hz 352 kb/s mono
Disk 1: 3.45 GB | Disk 2: 3.06 GB | Additional Content: 3.48 GB
Genre: eLearning
Microsoft Access 2010 is the newest version of this popular database software. During this 7-hour Access 2010 course, our professional trainer discusses new features in Access 2010, the new “Ribbon” interface, as well as how to design databases, create tables and reports, run queries, use Access forms and sort and filter data.
Learn How To Create and Use Forms, Utilize Queries to Retrieve Data, Perform Calculations Using Expressions and Functions, Create PivotCharts and PivotTables, Run Reports and Much More!. Plus, Discover the New Features of Access 2010!.
Access 2010 Training – Course Outline
Lesson 01 – Getting Started with Access 2010 Training
* Introduction to the Course
* About the Instructor
* Tour of the Course
Lesson 02 – Lab Setup
* Access 2010 Database Specifications
* Minimum Requirements for Access 2010
* Exercise Files
Lesson 03 – Introduction to Databases and Normalization
* Introduction to Relational Databases
* Flat–File Databases
* Relational Databases
* Introduction to Normalization
* Normalization Example
* Denormalization
* Designing Database Guidelines
* Normalization Example
* Trivia Time
Lesson 04 – Overview of Microsoft Access 2010 Objects
* Database Objects
* Queries
* Forms
* Reports
* Macros
* Modules
Lesson 05 – Tour of Microsoft Access 2010
* Starting Microsoft Access 2010
* Creating a New File
* Creating a New Table
* Saving a Database
* Opening a Database
* Trusting a File
* The Quick Access Toolbar
* Backstage View
* Access Options Overview
* The Ribbon
* Contextual Tabs
* The Navigation Pane
Lesson 06 – Understanding Object Views
* Introduction to Microsoft Access Object Views
* Table Views
* Query Views
* Form Views
* Report Views
Lesson 07 – Navigating Microsoft Access 2010 Database Objects
* Navigating a Table of Query
* Keyboard Shortcuts
* Navigating a Form
* Navigating a Report
Lesson 08 – Creating Simple Forms
* Creating a Single Item Form
* Automatic Subdatasheet Creation
* Creating a Multiple Items Form
* Creating a Split Form
* The Form Wizard
* Creating a Navigation Form
Lesson 09 – Form Formatting Basics
* Introduction to Controls
* Resizing Controls
* Moving Controls
* Working with Layouts
* Adjusting the Tab Order
* Applying Themes
Lesson 10 – Introduction to Queries
* Kinds of Queries
* Creating a Select Query Using the Simple Query Wizard
* Creating a Select Query from Design View
* Working with Fields
* Sorting and Filtering Records
Lesson 11 – Finding Specific Data Using Criteria, Operators, and Wildcards
* Introduction to Criteria
* Introduction to Operators
* Adding Criteria to a Query
* Combining Criteria
* Adding Alternate Criteria
* Locating Blank Values (Nulls)
* Introduction to Wildcards
Lesson 12 – Creating Parameter Queries
* Introduction to Parameter Queries
* Creating a Parameter Query
* Changing the Parameter Prompt Order
* Using Wildcards and Functions with Parameter Queries
Lesson 13 – Understanding Joins
* Introduction to Joins
* Types of Joins
* Creating an Inner Join
* Creating an Outer Join
* Creating a Self–Join
Lesson 14 – Creating Calculated Expressions
* Introduction to Expressions
* Creating a Calculated Detail Field
* Building Expressions Using the Expression Builder
* Building Expressions in Forms and Reports
Lesson 15 – Summarizing Data
* Introduction to Aggregate Queries
* Calculating a Group of Query Records
* Calculating a Group of Query Records From Datasheet View
* Calculating a Group of Query Records From Design View
* Grouping with Criteria and Calculated Fields
* Pitfalls of Summarizing Data
Lesson 16 – Introduction to Built-in Functions
* Introduction to Functions
* Basic Date/Time Functions
* The Month Function
* The Year Function
* Text Functions
* The LCase and UCase Functions
* The Left and Right Functions
* The Trim Function
* The Format Function
* Conversion & Math Functions
* The FormatCurrency Function
* The CCur Function
* The Round Function
Lesson 17 – Advanced Functions
* Advanced Date/Time Functions
* The DatePart Function
* The DateAdd Function
* The DateDiff Function
* The Sum Function
* The Max & Min Function
* The DMax & DMin Functions
* The DLookup Function
* Handling Null Values & Program Flow
* The Nz Function
* The IIf Function
* The Switch Function
* Using Functions in Macros
* Nesting Functions
Lesson 18 – Creating PivotTables
* Introduction to PivotTables
* Creating a PivotTable
* Creating a Calculated Field
* Manipulating a PivotTable
* Exporting Data to Microsoft Excel
Lesson 19 – Creating PivotCharts
* Introduction to PivotCharts
* Creating a PivotChart
* Manipulating a PivotChart
* Changing Chart Types
Lesson 20 – Creating Reports
* Creating a Report Using the Report Tool
* Creating a Report Using the Report Wizard
* Creating a Report from Design View
* Creating Mailing Labels
Lesson 21 – Basic Report Formatting
* Formatting Basics
* Controls
* Control Layouts
* Sections and Grouping
* Adding Controls & Page Elements
* Labels
* Text Boxes
* Pictures
* Page Numbers
* Date/Time
* Borders & Rectangles
Lesson 22 – Advanced Report Formatting
* Advanced Format Properties
* Filtering Reports
* Conditional Formatting
* Creating Data Bars
* Adding a Chart
Lesson 23 – Printing and Exporting Reports
* Previewing a Report
* Printing a Report
* Exporting a Report
Lesson 24 – Next Steps
Download
No comments:
Post a Comment