Entdecken Sie, was Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

Microsoft Office 2010

Von Sonic Performance

Become a proficient Office user!

This course package, consisting of seven individual courses in Word, Excel, PowerPoint, Outlook and VBA, provides an extensive Microsoft Office training. Beginners as well as advanced users can benefit from this Microsoft Office course.

Improve your skills in the following areas:
  • Formulas and functions in Excel
  • Pivot table
  • Power Point
  • Word
  • Scientific work with Word
  • Outlook
  • Visual Basic for Applications

Inhalte

Microsoft Word 2010 (EN)

Word 2010 Overview

play symbol Open and Close Word
03:50
lecture locked Open and Close Documents
05:45
lecture locked The Word Application Window
04:31
lecture locked Expand, Minimize and Move Documents
07:14
lecture locked Zoom In and Out
07:28
lecture locked Word Layouts
05:17
lecture locked Word 2010 Ribbon
08:49
lecture locked The Quick Access Toolbar
07:55
lecture locked Word 2010 Undo and Redo
07:09
Quiz zum Kurs „Word 2010 Overview“

The Basics of Word Processing

play symbol Enter Text
02:57
lecture locked Select Text
09:35
lecture locked Delete Text
05:55
lecture locked Format Text
08:34
lecture locked Modify Text Color
06:26
lecture locked Capital and Lowercase Letters
04:31
lecture locked Text Alignment
05:56
lecture locked The Format Painter
05:31
lecture locked Adjust Character Spacing
04:34
lecture locked Save Documents
06:13
lecture locked Various File Types
08:17
lecture locked Save in a 2003 Compatible Format
04:41
lecture locked Switch between Open Documents
02:49
lecture locked The Compatibility Checker Feature
04:12
Quiz zum Kurs „The Basics of Word Processing“

Print with Word 2010

play symbol Print Preview
03:43
lecture locked Print Documents
07:10
lecture locked Margins
04:53
Quiz zum Kurs „Print with Word 2010“

Edit and Correct Text / The Help Function

play symbol Copy and Move Text
07:06
lecture locked Search for a Text Element
04:55
lecture locked Replace a Text Element
06:16
lecture locked Check Spelling and Grammar
09:28
lecture locked The Clipboard Task Pane
07:25
lecture locked Paste Options
04:54
lecture locked The Word Help Function
07:34
Quiz zum Kurs „Edit and Correct Text / The Help Function“

Text Formatting Basics

play symbol Manual Line Break
04:11
lecture locked Show Formatting Marks
04:01
lecture locked Special Character Formatting
07:48
lecture locked Create and Format Paragraphs
07:08
lecture locked Line Spacing
05:59
lecture locked Paragraph Indent
07:24
lecture locked Paragraph Framing, Shading and Adding Background Color
08:48
lecture locked Page Breaks
07:26
lecture locked Modify the Size and Page Orientation of a Document
03:58
lecture locked Page Color
03:36
lecture locked Control Paragraph Flow
04:35
lecture locked Hide Text
04:26
Quiz zum Kurs „Text Formatting Basics“

Additional Text Formatting

play symbol Tab Stops
19:20
lecture locked Bullets and Numbering
10:05
lecture locked Multilevel List
07:12
lecture locked Insert a Symbol
07:07
lecture locked Insert the Date and Time
07:49
lecture locked Sort a List
05:40
lecture locked Insert Fields Using Quick Parts
07:02
Quiz zum Kurs „Additional Text Formatting“

Word 2010 Format Styles

play symbol Format Style Templates
04:28
lecture locked Create and Change Format Styles
10:09
lecture locked Organize Format Styles
07:52
lecture locked Manage Formatting
07:42
lecture locked The Style and Modify Style Dialog Boxes
05:58
Quiz zum Kurs „Word 2010 Format Styles“

Insert and Format Objects

play symbol Insert and Delete Objects
08:52
lecture locked Select an Object
04:13
lecture locked Position an Object
02:42
lecture locked Format an Object
12:18
Quiz zum Kurs „Insert and Format Objects“

Tables in Word

play symbol Create a Table
02:20
play symbol Input Data into a Table
04:08
lecture locked Add and Delete Rows and Columns
07:45
lecture locked Select Sections of a Table
05:32
lecture locked Change Column Width and Row Height
09:07
lecture locked Draw a Table
03:40
lecture locked Merge Cells
03:22
lecture locked Sort Tables
09:26
lecture locked Table Styles
05:47
lecture locked Format a Table
08:40
lecture locked Change Text into a Table and Vice Versa
03:30
lecture locked Insert an Excel Table
06:10
lecture locked Quick Tables
02:36
lecture locked The Table Properties Dialog Box
06:38
lecture locked Text Direction
04:10
lecture locked Perform Calculations in a Table
10:19
lecture locked Create a Custom List or Table Style
09:58
Quiz zum Kurs „Tables in Word“

Manage Documents

play symbol Quickly Access Folders with the Favorites Lists
03:49
lecture locked Customize how Documents are Saved
08:09
lecture locked Configure the Document Properties
02:58
lecture locked Prepare a Document for Sharing
07:04
lecture locked Word Documents on the Intranet/Internet
05:49
lecture locked Document Protection
07:36
lecture locked Track Changes
11:22
lecture locked Compare and Combine Documents
06:01
lecture locked Mark as Final
03:36
lecture locked Send a Document for Review
02:48
lecture locked The Comments Group
04:10
lecture locked Versioning
12:03
lecture locked Add a Digital Signature to a Document
09:12
Quiz zum Kurs „Manage Documents“

Auto Correct and Quick Parts in Word 2010

lecture locked AutoCorrect
08:55
lecture locked Create and Insert Quick Parts
09:52
lecture locked Edit and Delete Quick Parts
04:30
Quiz zum Kurs „Auto Correct and Quick Parts in Word 2010“

Spell Check, Hyphenation and Thesaurus in Word 2010

play symbol Check Spelling
10:06
lecture locked Edit the Custom Dictionary
05:01
lecture locked Check Grammar
06:06
lecture locked Set the Options for Checking Spelling and Grammar
06:18
lecture locked Automatic Hyphenation
06:45
lecture locked Use the Thesaurus to Suggest Synonyms
06:09
lecture locked Readability Statistics & Word Count
08:02
lecture locked The Research Task Pane & Options
07:31
lecture locked The Translate Feature
06:33
Quiz zum Kurs „Spell Check, Hyphenation and Thesaurus in Word 2010“

Document Templates in Word 2010

lecture locked Document Templates
06:50
lecture locked Create Edit and Save Document Templates
08:02
Quiz zum Kurs „Document Templates in Word 2010“

Create Mail Merge Documents in Word 2010

play symbol Prepare a Mail Merge Document
03:09
lecture locked Select Recipients
07:22
lecture locked Insert Merge Fields in a Document
10:18
lecture locked Print out a Mail Merge Document
04:12
lecture locked Edit the Data Source
08:51
lecture locked Print Envelopes and Labels
14:30
Quiz zum Kurs „Create Mail Merge Documents in Word 2010“

Sections, Columns, Headers, Footers and Footnotes in Word 2010

play symbol Insert or Delete a Section Break
07:39
lecture locked Split Text into Columns
09:11
lecture locked Add Headers and Footers
07:14
lecture locked Edit Headers and Footers
11:55
lecture locked Create and Edit Endnotes and Footnotes
08:11
lecture locked Add Hyperlinks
10:51
lecture locked Add Cross-References
08:37
Quiz zum Kurs „Sections, Columns, Headers, Footers and Footnotes in Word 2010“

Outline in Word

lecture locked Outline a Document
04:53
lecture locked The Outline View
10:01
lecture locked Modify an Outline
08:30
Quiz zum Kurs „Outline in Word“

Directories in Word 2010

play symbol Create a Table of Contents
11:16
lecture locked Create a Table of Figures
08:52
lecture locked Work with Bookmarks
06:38
lecture locked Create an Index
09:53
lecture locked The Caption Dialog Box
05:57
lecture locked Add Text & Mark Table of Contents Entry
09:52
Quiz zum Kurs „Directories in Word 2010“

Graphic Design Options in Word 2010

play symbol Create and Edit Drawings
19:55
lecture locked Create and Edit Text Boxes
08:19
lecture locked WordArt
09:21
lecture locked SmartArt
11:51
lecture locked Accent a Document with a Watermark
06:46
lecture locked Compress Images in Word
10:21
lecture locked Add a Cover Page
04:13
lecture locked ClipArt & Microsoft Clip Organizer
07:40
lecture locked Page Borders & Border Types
07:19
lecture locked Create Charts in Word
11:11
lecture locked Insert and Format Screenshots in a Document
06:54
lecture locked Pull Quotes and Sidebars
08:06
lecture locked Types of Shapes and Drawing Canvas
11:59
lecture locked Drop Caps
04:22
Quiz zum Kurs „Graphic Design Options in Word 2010“

Forms in Word 2010

lecture locked Create a Form
13:32
lecture locked Restrict Editing
06:07
Quiz zum Kurs „Forms in Word 2010“

Macros in Word 2010

lecture locked Automate Tasks Using Macros
08:47
lecture locked Create a Macro
09:11

Microsoft PowerPoint 2010 (EN)

PowerPoint 2010 Overview

play symbol Open and Close PowerPoint
03:52
lecture locked The PowerPoint Application Window
04:35
lecture locked Zoom Slider
04:13
lecture locked The PowerPoint Ribbon
12:18
lecture locked The Quick Access Toolbar
08:08
Quiz zum Kurs „PowerPoint 2010 Overview“

The Basics of PowerPoint 2010

play symbol Text Placeholder
06:41
lecture locked Save, Close and Open
06:06
lecture locked Slides and Outline Tabs
03:13
lecture locked Undo, Redo and Repeat
04:02
lecture locked Slide Layouts
05:05
lecture locked New Presentations and Templates
05:12
lecture locked Move between Open Windows
04:06
lecture locked The PowerPoint Options Dialog Box
07:24
lecture locked The Customize Status Bar Menu
02:36
Quiz zum Kurs „The Basics of PowerPoint 2010“

Basic Text Design with PowerPoint 2010

play symbol Character Formatting
09:35
lecture locked Bullets and Numbering
09:38
lecture locked Format Painter
05:07
lecture locked Headers and Footers
06:51
Quiz zum Kurs „Basic Text Design with PowerPoint 2010“

Advanced Text Design in PowerPoint 2010

play symbol WordArt Styles
04:27
lecture locked The Replace Fonts Option
03:11
lecture locked Text Alignment Options
02:39
lecture locked Spacing Options and Rulers
03:57
lecture locked Typography Effects
04:54
Quiz zum Kurs „Advanced Text Design in PowerPoint 2010“

The Help Function / PowerPoint Views

lecture locked PowerPoint Help
07:00
lecture locked Normal View, Slide Sorter, Reading View, Slide Show
10:12
lecture locked Copy and Delete Slides
05:58
Quiz zum Kurs „The Help Function / PowerPoint Views“

Use Different Layouts in PowerPoint 2010

lecture locked Title Layout
12:29
lecture locked Two Content Layout
10:42
lecture locked Title and Content Layout with a Chart
09:19
Quiz zum Kurs „Use Different Layouts in PowerPoint 2010“

The Slide Master

play symbol Background Styles
08:00
lecture locked Themes
06:36
lecture locked The Slide Master
08:05
lecture locked Create Custom Slide Layouts
05:10
lecture locked Create Custom Themes
04:41
Quiz zum Kurs „The Slide Master“

Objects in PowerPoint 2010

play symbol Excel Charts
07:45
lecture locked Insert and Edit Images
09:33
lecture locked ClipArt as Company Logo
09:49
lecture locked Insert Shapes
11:27
lecture locked Hyperlinks
11:53
lecture locked Insert SmartArt
10:50
lecture locked Insert Videos
07:47
lecture locked The Photo Album Feature
06:27
Quiz zum Kurs „Objects in PowerPoint 2010“

Place and Align Objects in PowerPoint 2010

play symbol Object Levels
06:55
lecture locked Exact Object Placement
07:42
lecture locked Align Objects
09:41
lecture locked The Grouping Feature
05:01
Quiz zum Kurs „Place and Align Objects in PowerPoint 2010“

Using Tables in Powerpoint 2010

lecture locked Insert a Table
05:51
lecture locked Format Tables
11:32
lecture locked Import Tables from Other Microsoft Office Applications
05:39

Animation in Powerpoint 2010

play symbol Assign Animation
09:45
lecture locked Advanced Animation Options
07:38
lecture locked Animation Order
08:55
lecture locked The Animation Painter Feature
03:26
lecture locked Action Buttons and Action Settings
08:57
Quiz zum Kurs „Animation in Powerpoint 2010“

Organize Presentations in PowerPoint 2010

play symbol Protect Slide Shows
07:25
lecture locked Save Options
06:36
lecture locked Document Properties
03:51
lecture locked Insert Slides from other Presentations
03:54
lecture locked Divide a Presentation into Sections
08:09
lecture locked Review a Presentation
10:49
lecture locked Publish Slides to a Slide Library
05:30
lecture locked Publish a Presentation to Other File Formats
05:29
lecture locked Secure a Presentation
10:28
Quiz zum Kurs „Organize Presentations in PowerPoint 2010“

Transitions in PowerPoint 2010

lecture locked Slide Transitions
04:40
lecture locked Next Slide
05:08
Quiz zum Kurs „Transitions in PowerPoint 2010“

Slide Show Presentations

play symbol Set Up a Slide Show
14:06
lecture locked Rehearse Timings
08:22
lecture locked Hide Slides
02:57
lecture locked Custom Slide Show
07:58
Quiz zum Kurs „Slide Show Presentations“

Print Notes Pages and Handouts in PowerPoint 2010

lecture locked Print and Edit Notes Pages
09:02
lecture locked Print and Edit Handouts
12:48
Quiz zum Kurs „Print Notes Pages and Handouts in PowerPoint 2010“

Tips and Tricks for PowerPoint

play symbol Compress Images
08:27
lecture locked Save as a Template
07:23
lecture locked Presentations without PowerPoint
08:11
lecture locked Various File Types and Compatibility
05:14
lecture locked Create a Video
06:21
lecture locked Text Selection Methods
06:08
lecture locked The Cut, Copy, and Paste Options
08:42
lecture locked Paste and Paste Preview Options
05:47
lecture locked Review the Content in a Presentation
11:04
Quiz zum Kurs „Tips and Tricks for PowerPoint“

Microsoft Outlook 2010 (EN)

Overview: Outlook 2010

play symbol How to Open and Close Outlook
04:52
play symbol The Outlook Application Window
04:52
lecture locked The Ribbon in Outlook
06:15
lecture locked How to Minimize, Maximize and Move Windows
07:26
lecture locked The Quick Access Toolbar in Outlook
05:19
lecture locked The Zoom Slider in Outlook
03:42
lecture locked The Dialogue Box Launchers in Outlook
02:05
lecture locked The Outlook Help
05:54

Compose and Send Messages in Outlook 2010

play symbol How to Insert Recipient
07:38
lecture locked Composing and Editing Messages in Outlook
04:33
lecture locked How to Check the Spelling
04:10
lecture locked How to Attach Files and Items
06:00
lecture locked How to Draft Folders
03:25
lecture locked Sending Messages in Outlook
06:08
lecture locked The Message Format in Outlook
06:11
lecture locked The Signatures in Outlook
09:15
lecture locked How to Search Messages
06:10
lecture locked Modifying Delivery Options
10:31
lecture locked The Instant Search in Outlook
07:10

Receive Messages in Outlook 2010

play symbol Reading Received Messages
08:44
lecture locked The New Message Alert
08:17
lecture locked Printing Massages
04:11
lecture locked Saving Massages
04:36
lecture locked How to Reply and Forward Messages
11:31
lecture locked How to Open Hyperlinks and Attechments
06:43
lecture locked Categorinzing and Follow Up
07:20
lecture locked How to Delete Messages
05:06

Contact in Outlook 2010

play symbol How to Create Contacts
06:49
lecture locked How to Edit and Delete Contacts
12:51
lecture locked Using Contacts
05:55
lecture locked Printing Contacts
03:15
lecture locked Creating Custom Business Cards
07:22
lecture locked Creating Groups
08:57
lecture locked How to Import Contacts
16:34
lecture locked The Secondary Address Books
07:38
lecture locked How to Sort and Find Contacts
08:10
lecture locked How to Forward Contacts
05:57
lecture locked Exporting Contacts
05:49
lecture locked Performing a Mail Merge
11:58

The Calendar in Outlook 2010

play symbol The New Appointment in Outlook
05:23
lecture locked How to Edit and Delete Appointments
08:27
lecture locked The Reminder in Outlook
05:30
lecture locked Recurring Appointment
11:46
lecture locked The All Day Event
05:55
lecture locked The Calendar Options
06:54
lecture locked How to Categorize
06:07
lecture locked Searching for Appointments
03:37
lecture locked The Print Calendar Data
04:42
lecture locked The Calendar Symbols
01:51
lecture locked The Room Finder Pane
08:21
lecture locked How to Set Availability Options
03:35
lecture locked How to Send Calendar Information in an Email Message
06:57

Tasks in Outlook 2010

lecture locked How to Create New Tasks
11:37
lecture locked The Daily Task List
05:27
lecture locked Assigning Tasks
08:55

Meeting Requests in Outlook 2010

lecture locked How to Create Meeting Requests
04:41
lecture locked Scheduling in Outlook
04:51
lecture locked Processing Meeting Requests
10:04

Administration in Outlook 2010

play symbol How to Customize the Folder View
14:17
lecture locked How to Create Folders
08:33
lecture locked Moving and Copying Items
07:32
lecture locked Deleting Items
08:43

Manage Messages in Outlook 2010

play symbol Arranging Messages in Outlook
13:49
lecture locked Searching Folders
09:06
lecture locked The AutoReply
16:43
lecture locked Junk Mails
09:45
lecture locked Quick Steps in Outlook
10:46
lecture locked How to Create Mail Rules
17:58
lecture locked The Cleanup and Archive Mailbox
16:23
lecture locked Managing Email Messages
09:14

Teamwork in Outlook 2010

play symbol The Calendar Groups in Outlook
05:48
lecture locked Sharing Mailbox Folders
12:13
lecture locked How to Open Additional Mailboxes
11:40
lecture locked Delegating Access
06:54
lecture locked How to Use Voting Buttons
10:52
lecture locked The Microsoft Exchange Server
01:12

Microsoft Excel 2010 (EN)

Overview: Excel 2010

play symbol How to Open and Close Excel
05:24
lecture locked The Excel Application Window
06:03
lecture locked How to Zoom In and Out
04:31
lecture locked How to Expand, Minimize and Move Windows
05:11
lecture locked The Ribbon in Excel
05:32
lecture locked The Quick Access Toolbar in Excel
09:21

Basic Table Editing in Excel 2010

play symbol Navigating the Worksheet
06:01
lecture locked How to Input Numbers, Dates and Text Into Cells
06:16
lecture locked How to Create and Open Workbooks
07:13
lecture locked Changing and Deleting Cell Contents
08:19
lecture locked Selecting Elements of a Table
11:59
lecture locked How to Undo
05:12
lecture locked Printing Worksheets
08:23
lecture locked Switching Between Open Windows
09:45
lecture locked How to Add and Delete New Worksheets
09:44
lecture locked How to Copy, Move and Rename Worksheets
06:10
lecture locked Switching Between Worksheets
03:50

Work With Formulas & the Help Function in Excel 2010

play symbol Create and Enter Formulas
12:11
lecture locked Use Relative Cell References in Formulas
08:46
lecture locked Use Absolute Cell References in Formulas
13:16
lecture locked The Sum Function
17:12
lecture locked The Average, Minimum and Maximum Function
08:47
lecture locked The Count Function
08:21
lecture locked The Round Function
10:07
lecture locked Improvements to Excel Functions
03:05
lecture locked AND and OR Conditions
06:27
lecture locked The Help Function
08:58

Options & Basic Cell Formatting in Excel 2010

play symbol How to Save and Close Workbooks
09:05
lecture locked The General Pane in Excel
12:53
lecture locked The Save Pane in Excel
13:33
lecture locked The Font Size and Type
04:02
lecture locked Bold, Italic and Underline
05:10
lecture locked Cell Alignment in Excel
03:54
lecture locked Line Break in Excel
04:48
lecture locked Merging Cells
05:45
lecture locked The Cell Borders
13:01
lecture locked Decimals in Excel
07:40
lecture locked Percent in Excel
06:56
lecture locked Format Painter in Excel
05:12

Changing the Table Structure & More Features in Excel 2010

play symbol The Column Width and Row Height
10:58
lecture locked How to Insert and Delete Columns, Rows and Cells
09:30
lecture locked Showing and Hiding Colums and Rows
05:26
lecture locked The Function Wizard
10:36
lecture locked The IF Function in Excel
11:59
lecture locked The Nested IF Function in Excel
03:55
lecture locked VLOOKUP and HLOOKUP
18:34
lecture locked Standard Error Message
08:20
lecture locked Formula Auditing
12:01
lecture locked Consolidate Data
08:20

Work With Date and Time & Use Efficient Workbooks in Excel 2010

play symbol How to Insert and Format Time and Date
11:42
lecture locked Simple Time Calculation in Excel
09:05
lecture locked Working With Date and Time Functions
12:25
lecture locked How to Save in a Different File Type
10:08
lecture locked Cell References to Other Sheets and Workbooks
06:44
lecture locked Protecting Workbooks
05:18
lecture locked Protecting Sheets and Cells
08:39
lecture locked How to Share Workbooks
07:44

Managing Workbooks in Excel 2010

play symbol Favorite Links
04:32
lecture locked Saving Options
12:29
lecture locked Document Properties in Excel
03:39
lecture locked How to Import and Export Data
10:46
lecture locked Merging Workbooks
04:47

Print Settings & Styles and Templates in Excel 2010

play symbol The Print Preview in Excel
05:13
lecture locked Arranging Windows in Excel
05:36
lecture locked Margins in Excel
06:07
lecture locked The Scale in Excel
06:26
lecture locked Page Breaks
08:36
lecture locked The Header and Footer
10:23
lecture locked The Page Setup
08:44
lecture locked The Print Titles
05:06
lecture locked Editing Cell Styles
11:21
lecture locked Excel Templates
08:12

Charts in Excel 2010

play symbol How to Create Charts
06:20
lecture locked How to Move and Resize Charts
12:24
lecture locked Changing Chart Type
07:05
lecture locked Formatting Charts in Excel
07:49
lecture locked Formatting Axis in Excel
11:36
lecture locked The Labels in Excel
07:11
lecture locked How to Create a Trendline
07:37

Graphics and Objects in Excel 2010

play symbol How to Insert and Edit Objects
10:15
lecture locked The Image Styles in Excel
05:31
lecture locked How to Insert Drawings
06:26
lecture locked How to Insert SmartArts
09:58
lecture locked Layer and Group Graphic Objects
08:50

Edit Large Tables in Excel

play symbol Quick Access to Cells
08:33
lecture locked How to Split Sheet Window in Sections
07:57
lecture locked Freezing Lines and Columns
07:44
lecture locked How to Find and Replace Cells
09:38

Special Graphical Possibilities & Outlining Tables in Excel 2010

play symbol Conditional Formatting
20:48
lecture locked Custom Cell Formats
08:12
lecture locked The Data Validation in Excel
07:07
lecture locked Comments in Excel
07:32
lecture locked How to Use Hyperlinks
06:37
lecture locked Watermarks & Background Pictures in Excel
06:58
lecture locked Managing Themes in Excel
07:21
lecture locked Data Grouping
04:15
lecture locked Subtotal in Excel
07:57

Excel 2010 as Data Base

play symbol Creating a Data Base
04:22
lecture locked Sorting in Excel
08:56
lecture locked How to Use Filters in Excel
07:55
lecture locked How to Use Special Filters in Excel
08:37
lecture locked Database Functions
10:46

Pivot Table in Excel 2010

play symbol How to Create Pivot Table
03:43
lecture locked The Pivot Table Field List
14:20
lecture locked Data Grouping in Pivot Tables
09:07
lecture locked The Pivot Table Tools
19:25
lecture locked Inserting Calculated Field
07:22
lecture locked How to Create a Pivot Chart
07:31

Goal Seek and Solver & Scenarios in Excel 2010

play symbol The Goal Seek in Excel
07:55
lecture locked The Solver in Excel
17:51
lecture locked Solver Reports in Excel
06:50
lecture locked How to Create Scenarios
07:40

Practice Tips in Excel 2010

play symbol How to Prepare for Sharing
09:38
lecture locked How to Mark as Final
03:51
lecture locked The IFERROR Function
04:58
lecture locked Deleting Duplicates
06:32
lecture locked Text in Columns
10:16
lecture locked Administer Digital Signatures
12:36
lecture locked How to Create a Workspace
03:50
lecture locked Developing XML Maps
10:31

Microsoft Access 2010 (EN)

Overview: Access 2010

play symbol How to Open and Close Access
04:58
play symbol How to Open and Close a Database
03:50
lecture locked The Access Application Window
05:57
lecture locked The Ribbon in Access
11:43
lecture locked The Quick Access Toolbar
05:47

The Navigation Pane and the Help Function in Access 2010

play symbol The Navigation Pane in Theory
12:19
lecture locked Objects in the Navigation Pane
04:59
lecture locked How to Change the Navigation Pane View in Access
09:24
lecture locked How to Use the Access Help
06:17

Tables in Access 2010

play symbol How to Create a Table in Worksheet View
10:28
play symbol How to Create a Table in Design View
16:23
lecture locked Field Data Types in Access
09:57
lecture locked Field Data Types: Memo
06:12
lecture locked Field Data Types: Date/ Time
08:29
lecture locked Field Data Types: OLE Object
03:02
lecture locked Field Data Type: Hyperlink
03:29
lecture locked Field Data Type: Attachment
05:17
lecture locked The Lookup Wizard
08:12
lecture locked Field Properties for Text - Part 1
12:42
lecture locked Field Properties for Text - Part 2
10:42
lecture locked Field Properties for Numbers - Part 1
10:33
lecture locked Field Properties for Numbers - Part 2
09:52
lecture locked How to Format and Input Masks
12:47
lecture locked The Validation Rule in Access
15:26
lecture locked The Table Tools in Access - Part 1
09:08
lecture locked The Table Tools in Access - Part 2
09:13
lecture locked The Table Properties in Access
02:59

How to Search for, Replace and Sort Data in Access 2010

play symbol Navigate Between Data Records
07:04
lecture locked Copy and Delete Data Records
09:58
lecture locked Search for Data
09:25
lecture locked Replace Data - Part 1
07:05
lecture locked Replace Data - Part 2
08:36

How to Filter Data in Access 2010

play symbol Filter in Access
08:50
lecture locked Selection Filter in Access
06:17
lecture locked Advanced Filter Options in Access
06:34

Simple Queries in Access 2010

play symbol The Query Design in Access
12:15
lecture locked The Query Criteria in Access
07:41
lecture locked AND and OR
09:13
lecture locked The Query Operators in Access
10:07
lecture locked How to Use Wildcards in Access
10:37

Forms in Access 2010

play symbol Form Layout View - Part 1
07:00
lecture locked Form Layout View - Part 2
09:23
lecture locked Form Design View - Part 1
09:44
lecture locked Form Design View - Part 2
08:42
lecture locked Enter, Process and Delete New Data Records
09:10
lecture locked Sort and Filter in Forms
06:45

Relationships in Access 2010

play symbol The Relationships in Theory
11:55
lecture locked How to Link Data With the Help of Queries
08:30
lecture locked How to Link Data With the Help of the Lookup Wizard
09:02
lecture locked How to link Data with the Help of Relationships
08:57
lecture locked The Referential Integrity in Access
10:52
lecture locked The Object Dependencies in Access
05:30
lecture locked The First Normal Form in Access
09:42
lecture locked The Second Normal Form in Access
11:24
lecture locked The Third Normal Form in Access - Part 1
08:50
lecture locked The Third Normal Form in Access - Part 2
07:07

Advanced Forms in Access 2010

play symbol How to Create Forms Based on Queries
06:37
lecture locked How to Improve Forms Visually
13:14
lecture locked Get to Know Control Elements - Part 1
07:38
lecture locked Get to Know Control Elements - Part 2
10:54
lecture locked The Tab Order in Access
07:08
lecture locked The Subform in Access - Part 1
06:51
lecture locked The Subform in Access - Part 2
09:14
lecture locked The Property Sheet in Access - Part 1
08:45
lecture locked The Property Sheet in Access - Part 2
09:24
lecture locked The Property Sheet in Access - Part 3
06:57
lecture locked Retrieve Records Based on Input Criteria
03:55
lecture locked Restrict Data Entry in Forms
09:45
lecture locked How to Add a Command Button to a Form
03:55
lecture locked Display a Summary of Data in a Form
06:21
lecture locked Change the Display of Data Conditionally
05:29
lecture locked The Tab Pages in Access
04:31

Advanced Queries in Access 2010

play symbol How to Use Functions in Queries - Part 1
09:41
lecture locked How to Use Functions in Queries - Part 2
10:46
lecture locked Parameter Queries in Access
05:40
lecture locked How to Make Table Queries
08:52
lecture locked How to Update Query
11:37
lecture locked How to Append Query
06:02
lecture locked How to Delete Query
07:51
lecture locked Grouping Information in Access
13:05
lecture locked Finding Duplicate Data in Access
05:52
lecture locked Using Subqueries in Access
07:51
lecture locked The Crosstab Query
04:03
lecture locked Relate Data Within a Table
07:08
lecture locked Set the Select Query Properties
07:35
lecture locked Create a Junction Table
07:30
lecture locked Outer Joins in Access
15:40
lecture locked Indirect Joins in Access
07:58

Printing and Reports in Access 2010

play symbol Report Layout View
11:07
play symbol The Report Design View - Part 1
06:20
lecture locked The Report Design View - Part 2
09:39
lecture locked Manual Grouping in Access
14:03
lecture locked The Report Wizard
15:49
lecture locked How to Create a Mail Merge
04:02
lecture locked Organize Report Information
06:55
lecture locked Control Report Pagination
05:58
lecture locked Summarize Report Information
04:25
lecture locked Include a Chart in a Report - Part 1
08:26
lecture locked Include a Chart in a Report - Part 2
09:59
lecture locked Print Data in Columns
07:39
lecture locked Cancel Printing of a Blank Report
05:04
lecture locked Subreports in Access
14:51
lecture locked Mailing Label Report in Access
05:07
lecture locked How to Report With No Data
12:03
lecture locked Enhance the Appearance of a Report
07:03
lecture locked Format the Controls in a Report
04:21
lecture locked How to Quick Print and Printing
05:50
lecture locked The Print Preview in Access
08:54

Macros in Access 2010

play symbol How to Create a Simple Macro
06:20
lecture locked The Action Catalogue in Access
10:28
lecture locked The DoMenuItem Action
10:22
lecture locked The IF Action
13:28
lecture locked The RunMacro Action
15:36
lecture locked The Macro Buttons in Access
10:15
lecture locked How to Activate Macros With the Help of Events
12:29
lecture locked How to Validate Data Using a Macro
05:19
lecture locked How to Automate Data Entry Using a Macro
04:03

Import, Link and Export Data in Access 2010

play symbol How to Import or Link Access Objects
16:37
lecture locked How to Import or Link Foreign Data
14:54
lecture locked How to Export Access Data
14:07
lecture locked Saved Imports and Exports in Access
09:21

The Database Management in Access 2010

play symbol How to Analyze a Table
11:40
lecture locked Compress and Repair a Database
06:41
lecture locked The Database Documenter in Access
08:41
lecture locked How to Create a Pivot Table
05:34
lecture locked How to Analyze the Performance of a Database
03:12
Quiz zum Kurs „Microsoft Office 2010“

Details

  • Enthaltene Vorträge: 547
  • Laufzeit: 71:42 h
  • Enthaltene Quizfragen: 145
  • Enthaltene Lernmaterialien: 4

Dozenten des Kurses Microsoft Office 2010

 Sonic Performance

Sonic Performance

Sonic Performance Support is a provider of web-based video learning solutions in multiple languages for consumers, corporations of every size, associations and educational institutions.

All videos can be accessed instantly from any computer or mobile device via any browser and come with a human touch. Experienced trainers guide you step-by-step through the software features.


Rezensionen

(1)
5,0 von 5 Sternen
5 Sterne
1
4 Sterne
0
3 Sterne
0
2 Sterne
0
1  Stern
0
 
Übersichtlich!
von Deborah S. am 08. November 2015 für Excel 2010 as Data Base

Der Kurs erklärt die Basic sehr gut. Ist genau das, was jeder Anfänger wissen sollte. Gerade wenn man mit Datenbanken arbeiten will.