آموزش تصویری Access 2010 TrainSignal

آموزش تصویری ورد Word 2010 Total Training >>
 آموزش تصویری Access 2010 TrainSignal
نویسنده و تهیه کننده TrainSignal
امتیاز جایزه: 0
قیمت: 0 تومان

آموزش اکسس -Access 2010 TrainSignal

این مجموعه با فرمت ها و کیفیت های مختلف جهت اجرا بر روی انواع پلیر ها تهیه شده است.

 

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

مشخصات
زبان آموزش انگلیسی
مدت زمان آموزش 12:00
ویرایش 2010
نوع تصویری(Multimedia)
تعداد DVD 3
سطح مقدماتی-متوسط-پیشرفته
هزینه حمل دارد
اوپن کارت فارسی
فروشگاه اینترنتی محصولات آموزشی آفیس © 2016