Intellezy Course Catalog
Thousands of award winning videos

Categories

Microsoft 365

Microsoft Office

Google Workspace

Business Skills

General Computing

Technical

Adobe

Microsoft Windows

Security

Microsoft 365

Access 365 - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
183   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Access 365 - Intermediate

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
225   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Access 365 - Advanced

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
110   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Collaborating in Microsoft 365 - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
95   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Copilot in Excel 365 - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
29   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Copilot in Microsoft 365 Stream - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
35   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Copilot in Microsoft Forms - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
12   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Copilot in Microsoft Loop - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
23   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Copilot in Microsoft OneNote - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
23   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Copilot in Microsoft Teams - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
47   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Copilot in Microsoft Whiteboard - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
13   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Copilot in Outlook 365 - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
43   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Copilot in PowerPoint 365 - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
23   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Copilot in Windows 11 - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
62   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Copilot in Word 365 - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
37   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Excel 2021 - Intermediate

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
191   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Excel 365 - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
220   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Excel 365 - Advanced

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
278   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Excel 365 - Expert

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
270   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Excel 365 VBA - Expert

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
312   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Getting Started with Microsoft 365 Copilot - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
64   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Copilot - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
70   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Copilot Chat - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
68   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Core Applications - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
58   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Delve - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
34   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Engage - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
25   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Excel - Intermediate

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
198   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Forms - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
81   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Introduction to Flow - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
129   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Loop - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
26   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Managing Microsoft Teams (Exam MS-700) - Intermediate

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
317   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Mobile Apps - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
120   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 New Features - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
134   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 OneDrive - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
55   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 OneNote Desktop - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
49   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 OneNote Online - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
47   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Outlook Web App - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
121   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Overview - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
26   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Planner - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
37   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Power Automate - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
184   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Power BI Desktop - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
194   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Power BI Desktop - Intermediate

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
231   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Power BI Report Builder - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
259   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Power BI Report Builder - Intermediate

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
372   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 PowerApps - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
249   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 PowerPoint - Advanced

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
113   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Project - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
128   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 SharePoint Site Owner - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
296   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 SharePoint Site User - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
191   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Sway - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
60   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Teams - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
148   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 To Do - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
48   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Video - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
29   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Visio Desktop - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
143   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Visio Online - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
44   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Word - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
261   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Word - Intermediate

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
349   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft 365 Word - Advanced

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
196   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Microsoft Stream for SharePoint - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
57   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Outlook 365 - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
179   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Outlook 365 - Advanced

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
108   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Power Apps - Enhanced Skills - Intermediate

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
189   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
PowerPoint 365 - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
95   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
PowerPoint 365 - Intermediate

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
183   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Project 365 - Advanced

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
86   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
SharePoint Sites 365 Fundamentals of Site Management - Intermediate

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
160   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
Skype for Business - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
121   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
The Foundations of Power Platform - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
271   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32
What is Power BI Desktop - Beginner

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

44  videos
228   minutes

VIDEOS

Introduction 00:52
Starting Access 02:07
Navigating the Main Screen 00:57
Using the Quick Access Toolbar and Ribbon 01:22
Using the Navigation Pane 01:08
Navigating in the Document Window 02:17
Opening a Table 02:40
Navigating a Table 02:27
Using Quick Search 00:42
Using Quick Filter 04:56
Adding Fields 02:39
Changing the Data Type 04:53
Adding a Lookup Field 02:38
Deleting a Field 01:00
Understanding The Design View 07:23
Setting Input Masks 02:21
Using The Lookup Tab 01:19
Indexing A Table  05:04
Adding a Record 03:03
Using Zoom Mode 01:45
Using Shortcut Keys 03:32
Filtering Data 02:35
Using the Find Dialog Box 02:21
Using Replace 01:05
Deleting Records 02:01
Changing Table Appearance 04:29
Understanding Query Types 00:57
Using the Query Wizard 05:21
Using the Query Design View 05:00
Using the QBE Grid 03:29
Entering Criteria 06:46
Creating a Query Manually 04:43
Using Logical Operators in Criteria 04:21
Using Wildcards in Criteria 08:03
Understanding Forms 01:13
Creating a New Form 07:32
Using the Form Design Window 03:33
Selecting, Moving, and Resizing Controls 17:00
Understanding Report Design Steps 01:20
Creating a Report 05:38
Modifying Controls in a Report 08:28
Basing a Report on a Query 03:31
Adjusting and Printing a Report 02:09
Course Recap 01:32

Microsoft 365

Access 365 - Beginner

This course is an introduction to Microsoft Access 365. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 365 Intermediate course.

44 videos
183 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Access 365 - Beginner
Access 365 - Intermediate

This course is designed to teach students intermediate level skills in Microsoft Access 365. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 365 Advanced course.

44 videos
225 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Access 365 - Intermediate
Access 365 - Advanced

Access 365 Advanced will further build upon the topics covered in the Access 365 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create backups, create and modify Navigation Forms, set startup options, split a database, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), convert macros to VBA, and use Table Events.

44 videos
110 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Access 365 - Advanced
Collaborating in Microsoft 365 - Beginner

This comprehensive course is designed to provide an in-depth overview of the Microsoft 365 suite, focusing on its powerful collaboration tools and features. Participants will learn how to effectively work both online and offline, ensuring seamless productivity regardless of their internet connectivity. The course emphasizes the importance of collaboration, guiding students through various methods and best practices for working together with colleagues and team members. Throughout the course, users will engage in hands-on activities that include creating a detailed plan, developing and sharing documents, and mastering the art of collaboration within Microsoft Teams. By the end of the course, participants will have a solid understanding of how to co-author documents in real time using Microsoft 365, allowing for efficient and synchronized teamwork. In addition to document collaboration, the course will cover the use of Viva Engage and Teams as platforms for gathering feedback and fostering open communication within an organization. Students will learn how to leverage these tools to create a more interactive and responsive work environment. Furthermore, the course will introduce Microsoft Lists, a versatile tool that helps streamline project management by enabling better delegation and tracking of tasks. Overall, this course aims to equip students with the knowledge and skills needed to harness the full potential of Microsoft 365 for enhanced collaboration and productivity. Whether working on individual projects or as part of a team, participants will leave the course with practical experience and confidence in using Microsoft 365 to achieve their goals.

44 videos
95 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Collaborating in Microsoft 365 - Beginner
Copilot in Excel 365 - Beginner

This course introduces Excel users to the basics of Excel Copilot. No previous experience with Copilot is required. This course starts by examining the licensing and work environment requirements to get started. Students follow the instructor with the same data files that the instructor uses. The Copilot pane is explored, and its features examined. Writing good prompts is explained and Copilot is asked to create calculated columns in tables, summary calculations on different worksheets, and data manipulation formulae to manage existing data. Excel Copilot often creates PivotTables when it needs to filter or summarize data. This aspect of Copilot is explored and demonstrated. The output of Copilot is deconstructed to understand how Copilot answers questions of this type. Formatting and styling data comes next. Copilot is asked to highlight data based on specific criteria. Dashboard style icons and formatting result. Formatting and styling are done with multiple criteria against different columns of data in a table. Copilot often leverages Excel’s Conditional Formatting feature. The results are examined and changed, as necessary. Finally, data is summarized and charted by Copilot. Copilot can use many chart types, and several are used in this course. Data shaping is explained and demonstrated, and the output of Copilot is examined.

44 videos
29 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Copilot in Excel 365 - Beginner
Copilot in Microsoft 365 Stream - Beginner

"Copilot in Microsoft 365 Stream" is an insightful journey into the world of video management and collaboration within the Microsoft 365 ecosystem. The course is designed to equip learners with the skills to leverage Copilot in Stream for enhancing productivity and collaboration. Participants will delve into the functionalities of Copilot in Stream, learning how to quickly catch up on videos, ask pertinent questions about video content, summarize videos for key points, and navigate to specific parts of a video. The course emphasizes the importance of transcripts in Stream, guiding learners through the process of generating and uploading transcripts to ensure Copilot can effectively read and interpret video content. Learners will start by understanding the basics of Copilot for Stream, followed by lessons on preparing Stream videos for Copilot, including generating and uploading transcripts. Subsequent chapters will cover working with videos, summarizing content, navigating to key moments, listing action items, and asking Copilot questions to gain insights from videos. By the end of this course, learners will be proficient in managing video settings, generating transcripts, summarizing video content, and utilizing Copilot to its full potential to streamline their workflow. This course is not just about learning the technicalities of video management in Stream but also about embracing the transformative capabilities of Copilot AI in Stream to drive efficiency and innovation in the workplace

44 videos
35 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Copilot in Microsoft 365 Stream - Beginner
Copilot in Microsoft Forms - Beginner

Discover the transformative power of Microsoft 365 Copilot in our comprehensive video course on using Copilot with Microsoft Forms. This beginner-level course will guide you through the innovative features of Copilot, enabling you to create surveys, polls, and forms with ease and efficiency. Learn how to leverage AI to draft questions that resonate with your audience, ensuring high response rates and valuable feedback. Our expert-led tutorials will demonstrate how to integrate Copilot's capabilities into your workflow, enhancing your productivity and communication. Whether you're gathering data for market research, employee feedback, or event planning, Copilot in Microsoft Forms is your go-to tool for designing forms that engage and deliver. With hands-on exercises and real-world examples, you'll gain practical experience in utilizing AI to streamline your form creation process. Join our course to explore the best practices for maximizing the use of Microsoft 365 Copilot. Discover how to craft compelling surveys that capture critical data and insights. Learn to harness the power of automation to save time and improve the accuracy of your data collection. This course is designed for anyone looking to enhance their skills in online form creation and data analysis. By the end of this course, you will be proficient in using Microsoft 365 Copilot to create sophisticated forms and surveys that drive engagement and yield actionable insights. Start your journey towards mastering Microsoft Forms today and transform how you collect and analyze data.

44 videos
12 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Copilot in Microsoft Forms - Beginner
Copilot in Microsoft Loop - Beginner

Welcome to the “Copilot in Microsoft Loop” course, a comprehensive guide to mastering the innovative features of Copilot within the Loop environment. This course is designed for all skill levels of Loop users who are ready to take their collaborative efforts to the next level with AI-enhanced tools. Course Highlights: • Understanding Copilot’s Role in Loop: Explore how Copilot integrates with Loop to improve content creation and management. • Creating Content with Copilot: Learn to initiate and refine content with Copilot’s assistance, enhancing the creative process. •Brainstorming with Copilot: Utilize Copilot’s brainstorming capabilities to generate and develop innovative ideas. • Utilizing Blueprints: Discover how to use Copilot’s blueprint feature for effective content structuring and organization. • Descriptive Content Creation: Understand how Copilot can assist in articulating complex ideas with clarity and precision. • Summarizing and Refining Content: Master summarizing and refining content with Copilot to ensure your Loop pages are impactful. • Editing and Customization: Develop the ability to edit and customize Copilot’s output to suit your specific needs and style. By completing this course, you’ll be well-equipped to use Copilot within Loop to create, manage, and refine content efficiently, transforming your collaborative projects and productivity. Embark on this journey to unlock the full potential of Copilot's AI systems for Microsoft Loop!

44 videos
23 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Copilot in Microsoft Loop - Beginner
Copilot in Microsoft OneNote - Beginner

Welcome to the "Copilot in Microsoft OneNote" course, a transformative journey designed to empower you with the skills to harness the full potential of Copilot within the OneNote environment. This comprehensive course is meticulously crafted for individuals who are eager to elevate their note-taking and content management capabilities through the integration of Copilot's cutting-edge AI tools. Course Highlights: • Integration of Copilot in OneNote: Delve into the seamless integration of Copilot with OneNote, and discover how it revolutionizes the way you interact with your notes. • Content Creation and Management: Learn to create and manage content with unparalleled ease, as Copilot assists you in drafting summaries, to-do lists, and rewriting notes for enhanced clarity. • Summarization and Refinement: Master the art of summarizing and refining content, ensuring your OneNote pages make a significant impact. • Editing and Customization: Develop the skill to edit and tailor Copilot's output, aligning it with your unique style and requirements. By the end of this course, you will have a robust understanding of how Copilot integrates with OneNote to enhance collaborative content creation and management. You will possess the expertise to initiate and refine content, leveraging AI-powered assistance to streamline the creative process. Furthermore, you will be adept at using Copilot's brainstorming and blueprint features to generate innovative ideas and organize content efficiently. Embark on this enlightening path with "Copilot for OneNote" and transform the way you interact with your digital notes. Unleash the power of AI to elevate your efficiency, creativity, and communication to new heights. Join us and become a proficient user of Copilot, ready to navigate the future of note-taking with confidence and skill.

44 videos
23 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Copilot in Microsoft OneNote - Beginner
Copilot in Microsoft Teams - Beginner

This course has been designed to help you harness the power of Copilot, Microsoft’s AI-driven assistant, within Microsoft Teams. You will learn to utilize Copilot's full capabilities, with a focus on its integration in Teams for Microsoft 365 Copilot subscribers. Discover how Copilot can enhance your productivity and creativity by facilitating communication and team collaboration. A significant part of this course emphasizes Copilot's role as a powerful assistant for meetings in Teams. Reduce the need for note taking by taking advantage of what Copilot can do for you. Copilot’s features will help you keep track of discussions, action items, and follow-ups, ensuring that your meetings are more efficient and effective. You will learn how to leverage Copilot to provide comprehensive meeting recaps, rewrite messages, and improve communication within Teams Channels. By integrating Copilot into your workflow, you will be able to streamline processes, reduce manual efforts, and focus on more strategic activities. This course aims to show you how to make the most of Copilot's functionalities within Microsoft Teams, ultimately enhancing your workflow and collaboration with the help of Microsoft's AI agent – Copilot. By the end of this course, you will have the skills and knowledge to use Copilot effectively within Teams to enhance your productivity and creativity.

44 videos
47 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Copilot in Microsoft Teams - Beginner
Copilot in Microsoft Whiteboard - Beginner

Welcome to the "Copilot in Microsoft Whiteboard" course, where we embark on an enlightening journey to master the innovative features of Copilot within the Whiteboard environment. This course is meticulously designed for individuals at the beginner level, aiming to revolutionize their collaborative and visual communication efforts with the aid of Copilot's advanced AI tools. Course Highlights: Understanding Copilot's Role in Whiteboard: Explore the integration of Copilot with Whiteboard, enhancing the creative process of visual storytelling and brainstorming. Visual Content Creation and Management: Learn to create, manage, and transform concepts into stunning visuals with Copilot's assistance, making your whiteboard sessions more impactful. Strategic Organization: Discover how to use Copilot's categorization feature to organize your thoughts and details into visually distinct groups for better clarity. Articulating and Summarizing Ideas: Gain the ability to articulate complex ideas with precision and summarize content effectively using Copilot's summarization tools. By the end of this course, you will have a robust understanding of how Copilot integrates with Whiteboard to enhance your visual communication and collaborative efforts. You will possess the expertise to initiate, develop, and refine visual content, leveraging AI-powered assistance to streamline the creative process. Furthermore, you will be adept at using Copilot's brainstorming and categorization features to generate innovative ideas and organize your thoughts efficiently. Embark on this transformative path with "Copilot for Whiteboard" and revolutionize the way you interact with your digital whiteboard. Unleash the power of AI to elevate your efficiency, creativity, and communication to new heights. Join us and become a proficient user of Copilot, ready to navigate the future of visual storytelling with confidence and skill.

44 videos
13 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Copilot in Microsoft Whiteboard - Beginner
Copilot in Outlook 365 - Beginner

Welcome to the “Copilot in Outlook 365” course, designed to revolutionize your email management and scheduling within Outlook. Throughout this course, you will explore the multifaceted capabilities of Copilot, an AI-powered tool that not only provides insightful suggestions but also assists in drafting and scheduling with ease. With Copilot, you’ll discover how to streamline your workflow, making email communication and meeting coordination more efficient than ever. Course Highlights: • Introduction to Copilot: Learn what Copilot is and how it can transform your Outlook experience. Understand the different forms Copilot takes, focusing on the Gen AI Copilot (chatbot) and its role in enhancing collaboration. • Accessing Copilot in Outlook: Master the simple steps to access Copilot directly from your Outlook toolbar. Whether drafting a new email or navigating your calendar, Copilot is just a click away. • Email Drafting with Copilot: Experience the future of email composition. Copilot’s drafting feature helps you create emails quickly and effectively, offering sentence completion and writing suggestions tailored to your needs. • Email Coaching with Copilot: Elevate the quality of your emails with Copilot’s coaching feature. Receive guidance on tone and clarity to ensure your messages resonate with your audience. • Thread Summaries: Say goodbye to endless scrolling through email threads. Copilot’s summarizing feature provides concise overviews of conversations, highlighting key points for quick reference. • Finding Shared Files in Emails: Locate important attachments effortlessly. Copilot’s search functionality makes it easy to find shared files within your emails. • Scheduling Meetings with Copilot: Simplify meeting planning with Copilot’s scheduling assistance. Draft invitations, suggest agenda items, and find suitable meeting times by analyzing participant availability. By the end of this course, you will have a comprehensive understanding of Copilot’s features and how to leverage them to enhance your productivity in Outlook.

44 videos
43 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Copilot in Outlook 365 - Beginner
Copilot in PowerPoint 365 - Beginner

Elevate your PowerPoint presentations with Microsoft 365 Copilot, your intelligent assistant that transforms how you work with slides. In this course, you'll discover how Copilot can help you craft compelling narratives, design impactful slides, and deliver presentations that resonate with your audience. Learn to navigate the Copilot features within PowerPoint, from summarizing key points to generating creative content that aligns with your message. Our expert-led tutorials will show you how to seamlessly integrate Copilot's capabilities into your workflow, making it easier to communicate complex ideas with clarity and precision. Whether you're summarizing meetings, brainstorming session outcomes, or drafting your next big pitch, Copilot in PowerPoint is your go-to tool for creating presentations that stand out. With exercises and real-world examples, you'll gain hands-on experience in harnessing the full potential of AI to elevate your storytelling and engage your audience. Join us and transform your approach to presentations with Copilot in PowerPoint, where efficiency meets creativity. Enroll now and step into a world where every slide tells a story, and every presentation leaves a lasting impression. This course is ideal for professionals at all levels who want to leverage the latest AI technology to create dynamic and persuasive presentations. No prior experience with Copilot is required.

44 videos
23 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Copilot in PowerPoint 365 - Beginner
Copilot in Windows 11 - Beginner

Embark on a journey to master Copilot for Windows 11 with our comprehensive course designed for beginners. Authored by Eric Encarnacion, this course will guide you through the essentials of navigating and utilizing Copilot to enhance your user experience. Starting with an introduction to Copilot, you’ll learn about its various forms and how it integrates seamlessly with Windows. You’ll discover how to access Copilot directly from your taskbar or through Microsoft Edge, and the benefits of signing in with a business account for enhanced privacy and security settings. Dive into the user interface, exploring the Copilot Icon, Notebook, and the array of conversation styles available – from creative to precise to balanced. You’ll gain proficiency in writing effective prompts, ensuring your instructions to Copilot yield the desired outcomes. The course also covers the innovative Copilot Notebook, a tool that allows for the crafting and refining of prompts, and supporting materials up to 18,000 characters. You’ll learn about the specialized Generative Pretrained Transformers (GPTs) that power Copilot, enabling it to perform tasks tailored to your needs. By the end of this course, you’ll be adept at leveraging Copilot for a variety of tasks, from summarizing meetings to generating content and refining existing materials. Join us to unlock the full potential of Copilot for Windows 11 and transform your productivity!

44 videos
62 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Copilot in Windows 11 - Beginner
Copilot in Word 365 - Beginner

Unlock your writing potential with “Copilot in Word 365”, an innovative course designed to transform how you interact with Microsoft Word through the power of AI. This beginner-friendly journey is perfect for individuals with a basic understanding of Word, aiming to elevate their writing from ordinary to extraordinary. Imagine having a personal writing assistant who not only understands your needs but also anticipates them, offering real-time suggestions and enhancements that streamline your writing process. “Copilot in Word 365” introduces you to a world where technology meets creativity, enabling you to harness the full capabilities of the Copilot plugin—an advanced tool that integrates seamlessly with your Word documents. Throughout this course, you will explore the myriad ways in which Copilot can assist you in crafting emails, reports, essays, blogs, and more. You'll learn how to tailor Copilot's settings to better match your stylistic preferences, ensuring that every piece of writing feels uniquely yours while maintaining the highest quality. Dive deep into practical sessions where you'll use Copilot to generate content, edit drafts, and even rewrite existing documents to perfection. Whether you're drafting a proposal, compiling a report, or simply adding flair to your daily communications, Copilot's intuitive interface makes these tasks effortless. Enroll in “Copilot in Word 365” today to start a transformative journey that will not only improve your productivity and creativity but also empower you to achieve unparalleled excellence in all your writing endeavors. Let Copilot become your ultimate writing partner, transforming your ideas into impactful written pieces that stand out.

44 videos
37 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Copilot in Word 365 - Beginner
Excel 2021 - Intermediate

Unlock the full potential of Excel 2021 and transform your data handling skills with our Intermediate course. Designed for users who are familiar with the basics and ready to explore more complex functions, this course takes you beyond the surface into the depths of Excel's capabilities. In this comprehensive guide, you will delve into advanced formatting techniques, discover the power of functions and formulas, and learn how to link workbooks and worksheets effectively. By mastering these tools, you will be able to streamline your workflows, enhance your analytical abilities, and make data-driven decisions with confidence. Gain hands-on experience with real-world scenarios to apply what you learn immediately. Whether you're managing large datasets, performing complex calculations, or creating sophisticated reports, this course provides the expertise you need to use Excel more efficiently. Enhance your proficiency with Excel's tools to maintain large datasets, ensuring data integrity and accuracy. Learn to utilize advanced features such as conditional formatting, pivot tables, and macros to save time and automate repetitive tasks. By the end of this course, you will not only be equipped with intermediate skills but also understand how to harness Excel to its full potential, making you an asset in any data-intensive role. Join us to bridge the gap between basic knowledge and advanced Excel mastery, paving the way for professional growth and success.

44 videos
191 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Excel 2021 - Intermediate
Excel 365 - Beginner

Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks.

44 videos
220 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Excel 365 - Beginner
Excel 365 - Advanced

This course will teach students advanced concepts and formulas in Microsoft Excel 365. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks.

44 videos
278 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Excel 365 - Advanced
Excel 365 - Expert

This course builds on the advanced course. Some topics that were introduced in earlier courses are expanded on and many new topics are introduced, including new features. The course begins by examining worksheet automation tools. Drop-down boxes, spinner controls, option buttons are all placed onto a worksheet and wired into its formulae. No macro code is required to achieve these professional results. Data consolidation is examined using both 3-D formulae and the Data Consolidation feature itself with the emphasis on using it with dissimilar worksheets. While the term “data type” has several different meanings, it’s a feature in Excel and is used to access different types of information from a single location – either within an organization or outside. PowerPivot cannot be used to its fullest without the ability to create a data model. This course retrieves information from different sources, takes multiple tables, and creates a single data model that may be used for PivotTables or other types of analysis. Lookup functions are covered to a certain level in n earlier course, but the Expert course pushes those functions further. It also introduces several new functions as well. Even those who are familiar with some of these functions will find new uses, tips and tricks, and other opportunities to push their usage further for a new level of professional results. While array functions have been available for several years, dynamic array functions are new. This course moves students past the use of scalar functions and brings them into the new world of dynamic array functions. Even the best of Excel users may find themselves intimidated by Excel’s financial and statistical functions. In this course, functions have been curated from both categories that add a large degree of professional analysis to worksheet data without the need for formal training in finance or stats. Everyone can use and understand these functions. The last chapter examines features used to perform predictive analysis. The use of Solver is expanded upon and is integrated with the Scenario Manager. The Analysis ToolPak is used to create descriptive summaries and traditional Histograms. The newer Histogram chart type is also utilized. Forecast sheets are finally re-examined and put to use.

44 videos
270 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Excel 365 - Expert
Excel 365 VBA - Expert

This course will teach students proper Visual Basic programming techniques along with an understanding of Excel's object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code.

44 videos
312 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Excel 365 VBA - Expert
Getting Started with Microsoft 365 Copilot - Beginner

This course is designed to provide a comprehensive overview of Microsoft 365, covering its features, functionality, and navigation within the online environment. Microsoft 365 is a versatile productivity suite that enables users to access a wide range of Microsoft tools and features online from any device with an Internet connection. This suite includes popular applications such as Word, Excel, PowerPoint, and Outlook, all of which are accessible through a unified platform. The course will emphasize how Microsoft 365 facilitates seamless sharing and collaboration, making it easier for teams to work together efficiently, regardless of their physical location. Participants will learn how to sign into Microsoft 365 from anywhere, ensuring they can stay connected and productive on the go. The course will also cover how to navigate the Microsoft 365 environment effectively, allowing users to find and utilize the tools they need quickly. Additionally, learners will discover how to customize the Microsoft 365 environment to suit their individual preferences and workflow requirements. This includes personalizing settings, organizing files, and integrating other applications. Furthermore, the course will guide participants on how to download and use Microsoft apps on their mobile devices, ensuring they have access to essential tools and features at their fingertips, anytime and anywhere. Moreover, this course will briefly introduce Microsoft Copilot, Microsoft's brand new AI companion, which enhances the user experience by providing personalized support, boosting productivity, and facilitating collaboration within the Microsoft 365 suite.

44 videos
64 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Getting Started with Microsoft 365 Copilot - Beginner
Microsoft 365 Copilot - Beginner

In today’s evolving digital workplace, efficiency is everything. Microsoft 365 Copilot is revolutionizing the way professionals work by seamlessly integrating AI-powered assistance into Microsoft 365 applications. Whether you're drafting reports in Word, analyzing data in Excel, or summarizing meetings in Teams, Copilot helps you complete tasks faster and with greater accuracy. But to maximize its potential, you need to understand how to communicate with this AI tool and when to use the power of AI to maximize efficiency. This course provides a comprehensive guide to Microsoft 365 Copilot, covering both Copilot Chat and in-app Copilot features. You’ll learn how to access Copilot, navigate its interface, and utilize key features like Copilot Pages and the Work vs. Web Tabs. We'll also dive into prompt engineering, teaching you how to craft effective prompts to generate high-quality responses tailored to your needs. Additionally, this course explores Copilot Agents, AI-powered assistants that automate workflows and retrieve business data. You'll see how Copilot seamlessly integrates with Microsoft 365 applications like Word, PowerPoint, Excel, and Outlook, enhancing productivity and collaboration. By the end of this course, you'll have the skills and confidence to leverage Microsoft 365 Copilot in your daily workflow, optimizing efficiency while reducing manual effort. Take control of your workday and let AI do the heavy lifting!

44 videos
70 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Copilot - Beginner
Microsoft 365 Copilot Chat - Beginner

In today’s fast-paced and ever-evolving work environment, harnessing AI technology to enhance productivity and streamline workflows is no longer a luxury; it’s an absolute necessity. Microsoft 365 Copilot Chat is a powerful AI assistant specifically designed to help you work smarter and more efficiently, not harder. But to truly maximize its full potential, you need to know how to interact with it effectively, utilizing its advanced capabilities to the fullest. This course is meticulously designed to provide a comprehensive guide to effectively using Microsoft 365 Copilot Chat, whether you’re new to AI-driven tools or looking to refine your existing skills. We’ll start by breaking down what Microsoft 365 Copilot Chat is and how it differs from Microsoft 365 Copilot, ensuring you understand its unique and distinct capabilities. You’ll learn how to access and navigate the user-friendly interface, craft effective and precise prompts, and leverage best practices to get the most accurate and valuable responses. Real-world use cases and examples will be highlighted to enhance and streamline your workflow. By the end of this course, you’ll be equipped with the skills and confidence needed to seamlessly integrate Microsoft 365 Copilot Chat into your daily tasks, transforming the way you work and unlocking new levels of efficiency. Take control of your workflow and let Microsoft 365 Copilot Chat do the heavy lifting, allowing you to focus on what matters most!

44 videos
68 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Copilot Chat - Beginner
Microsoft 365 Core Applications - Beginner

This course is an introduction to the Microsoft Word, Excel, and PowerPoint Online apps as part of the Microsoft 365 suite of products. This course has been retired and will no longer be updated. Please see our course, Getting started with Microsoft 365, for the most current content on this topic.

44 videos
58 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Core Applications - Beginner
Microsoft 365 Delve - Beginner

Delve is an application which is included as part of the Microsoft 365 suite. In this course, students will gain a basic understanding of the purpose, features, functionality, and navigation in Delve. Delve provides insight into the documents and files that are being worked on by the members of an organization. It will not display private files, but only those that a user has been granted access to. Files in Delve are displayed on Content Cards which display basic information like the file type, location, number of views and more. Students will learn how to work with Content Cards to find the content they are looking for and then open, edit or organize as needed. Students will learn how to use Boards for organization in Delve. Files that relate to the same topic can be grouped together in a Board. Files can be added to multiple Boards if applicable and can be removed when necessary. Students will learn how to navigate and utilize the various views that exist in Delve. This includes the Home, Me, Favorites, and People views. Students will learn how to access profile information for their colleagues in the Delve system. They will also learn how to search for and share documents in Delve.

44 videos
34 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Delve - Beginner
Microsoft 365 Engage - Beginner

Unlock the full potential of Microsoft Engage with this comprehensive course designed to enhance team collaboration and communication. Microsoft Engage, formerly known as Yammer, is an integral part of the Microsoft Viva toolset, providing a dynamic platform for employees to connect, share, and engage with their colleagues across the organization. In this course, you will learn how to navigate and utilize Microsoft Engage to its fullest extent. We will guide you through the process of accessing Engage, joining and creating communities, and leveraging its features to foster a collaborative work environment. You will discover how to use Engage for announcements and feedback and track trending topics and hashtags, ensuring you stay informed and connected with your team. Our expert-led tutorials will demonstrate best practices for engaging with coworkers, sharing updates, and participating in meaningful discussions. Through hands-on exercises and real-world examples, you will gain practical experience in using Engage to drive collaboration and enhance productivity. By the end of this course, you will be proficient in using Microsoft Engage to create a more connected and engaged workplace. Whether you are a team leader looking to improve communication or an employee seeking to stay informed and involved, this course will provide you with the skills and knowledge needed to make the most of Microsoft Engage.

44 videos
25 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Engage - Beginner
Microsoft 365 Excel - Intermediate

In today's data-driven world, proficiency in Microsoft Excel is a valuable asset. This Intermediate Microsoft Excel course is tailored to empower you with essential skills to excel in the world of data analysis, management, and reporting. Over the course's duration, you will delve into a variety of key topics, all designed to elevate your Excel expertise. Link Workbooks and Worksheets: Learn to seamlessly connect workbooks and worksheets, allowing you to consolidate and cross-reference data effortlessly. Work with Range Names: Gain the ability to efficiently navigate and manage large spreadsheets through the use of range names. Sort and Filter Range Data: Discover how to organize and analyze your data effectively by sorting and filtering information with precision. Analyze and Organize with Tables: Explore the power of Excel tables, enabling structured data organization and simplified analysis. Use Conditional Formatting: Learn to highlight critical insights by applying conditional formatting to your datasets. Outline with Subtotals and Groups: Master data outlining techniques using subtotals and groups to simplify complex spreadsheets. Display Data Graphically: Transform your data into compelling visuals, making complex information accessible at a glance. Understand PivotTables, PivotCharts, and Slicers: Uncover the world of PivotTables and PivotCharts, and learn to slice and dice your data dynamically with Slicers. PowerPivot: Elevate your data analysis capabilities by diving into advanced PivotTable usage and harnessing the potential of PowerPivot for in-depth analysis.

44 videos
198 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Excel - Intermediate
Microsoft 365 Forms - Beginner

Microsoft Forms is included as a part of the Microsoft 365 suite of applications. It is a great way to capture valuable information through surveys, quizzes or polls, making it much easier to gather important data and feedback from a determined group of colleagues, collaborators, or another group. In this course, students will become familiar with the Microsoft Forms environment, interface, and setup. They will learn how to use Microsoft 365 Forms in order to comfortably create easy to use feedback forms. They will also learn how to quickly create a quiz which can be used as an assessment or knowledge check. Students will learn how to use and take advantage of various tools within the forms that they will create. These include text controls, date controls and rating scales. In addition, students will understand how to view and manage user responses from within the form. They will learn how to test a feedback form to ensure that it will work as intended. Students will learn how to use design themes and images to put finishing touches on a created form. Once a form has been created and tested, they will also learn how to share it with the intended audience.

44 videos
81 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Forms - Beginner
Microsoft 365 Introduction to Flow - Beginner

This course gives students a comprehensive overview of Flow, a Microsoft 365 app which allows users to create automated workflows between apps in order to receive notifications, and synchronize files, collect data. In this course, students will review the various types of Flows, learn how to build a Flow, and how to work with actions. They will also learn how to use approvals as well as how to share, import, and export a Flow. This course has been retired and will no longer be updated. Please see our course, Microsoft 365 Power Automate - Beginner, for the most current content on this topic.

44 videos
129 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Introduction to Flow - Beginner
Microsoft 365 Loop - Beginner

Unlock the full potential of Microsoft 365 Loop with our comprehensive beginner course designed to help you master this powerful tool. Microsoft 365 Loop is a dynamic platform that integrates seamlessly with your existing Microsoft 365 suite, allowing for enhanced productivity and collaboration. This course is perfect for beginners who are new to Microsoft 365 or those who want to expand their skill set and improve their workflow management. Throughout this course, you will learn how to leverage Loop to create fluid and flexible workspaces that adapt to your team's needs. You will discover how to use Loop components to streamline your workflows, improve communication, and increase efficiency across all your projects. By mastering the use of Loop for task management, content creation, and real-time collaboration, you will be able to ensure that you and your team stay organized and on track. We will guide you through the process of setting up Loop, understanding its interface, and utilizing its various features to enhance your productivity. You'll also learn best practices for integrating Loop with other Microsoft 365 tools, enabling a seamless and cohesive work environment. By the end of this course, you will have the skills and confidence to use Microsoft 365 Loop to its full potential, transforming the way you work and collaborate with your team. Enroll now to take the first step towards a more productive and collaborative future.

44 videos
26 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Loop - Beginner
Microsoft 365 Managing Microsoft Teams (Exam MS-700) - Intermediate

This course is for people interested in administering a Microsoft Teams environment or taking the MS-700 Microsoft Teams Administrator Associate certification exam. We will cover all they task required for a person charged with the day-to-day management of a Microsoft Teams environment. We will cover topics including planning and configuration, managing chat, calling and meetings settings and experiences, along with creating teams, membership, and app control. There will be a discussion about upgrading considerations as you move from Skype for Business to Teams. We will discuss using the various portals as well as PowerShell for administration. We will examine governance and lifecycle management as well as security and compliance, including guest and external access. This course will help you understand how to deploy and manage various Microsoft Teams endpoints such as desktop, mobile and IP phones. You will learn how to monitor the environment using usage reports, Call Analytics, Call Quality Dashboard and Power BI. As a cloud PBX solution, we will gain an understanding of how to manage phone numbers, emergency address configuration, call routing, auto attendants as well call parking, caller ID policies and calling plans. If you are sitting the exam to earn your MS-700 Microsoft Teams Administrator Associate certification, this course will cover all the skills being measured.

44 videos
317 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Managing Microsoft Teams (Exam MS-700) - Intermediate
Microsoft 365 Mobile Apps - Beginner

This course is designed to teach students the basics of the Microsoft Mobile Apps and help them gain familiarity with the environment and basic functionality of using the mobile office suite. Students will learn the basics of mobile Word, PowerPoint, Excel, Teams, OneNote, OneDrive, and Outlook.

44 videos
120 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Mobile Apps - Beginner
Microsoft 365 New Features - Beginner

This course is designed to introduce students to the new features of Microsoft 365. Students will review the common changes across the suite of products such as co-authoring, icons, Microsoft translator, inking tools, new chart types, and the accessibility checker. Students will review the individual feature enhancements in Microsoft Word, Excel, PowerPoint, Outlook, and Access.

44 videos
134 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 New Features - Beginner
Microsoft 365 OneDrive - Beginner

This comprehensive course is designed to equip students with a thorough understanding of Microsoft OneDrive, the innovative cloud-based storage solution that revolutionizes the way we store, access, and manage data. OneDrive's seamless integration across devices ensures that users can effortlessly save files and have them readily available on the go, provided there is an internet connection. Participants will delve into the intricacies of OneDrive, starting with the basics of accessing and navigating the user-friendly interface. The curriculum includes hands-on exercises that allow students to create, open, and save files directly within OneDrive, fostering a practical understanding of its capabilities. A key feature of OneDrive is its version history, which safeguards information by keeping track of document changes. Students will learn to navigate this feature, ensuring they can revert to previous versions when necessary. The course also covers the synchronization of files across devices, a critical skill for maintaining up-to-date data and facilitating workflow continuity. Moreover, the course addresses file management skills, such as deleting unnecessary files to optimize storage space. An essential component of OneDrive is its collaboration feature, which the course will explore in depth. Students will learn to share files securely and collaborate in real-time with colleagues, enhancing teamwork and productivity. By the end of this course, students will have a solid foundation in using OneDrive effectively for personal and professional purposes, empowering them with the skills to navigate the digital landscape with confidence and efficiency.

44 videos
55 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 OneDrive - Beginner
Microsoft 365 OneNote Desktop - Beginner

OneNote is a free-form note-taking application by Microsoft for cross-platform information gathering and collaboration. OneNote is included for Desktop and Online with Office 365 and can be accessed as a Windows application on the Microsoft Store. While each form of OneNote functions similarly, there are important differences to recognize when choosing which version is right for you. This course provides an in-depth look at OneNote Desktop 365. Through these lessons, you will learn how OneNote can help to organize your ideas and information more effectively and allow access to content locally and on the cloud to share with others. You will learn how to open OneNote Desktop, create Notebooks, Sections and Pages, as well as modify Page details and more. We will also discuss and demonstrate ways to insert, format, and search for objects or text across all your notebooks as well as create and assign tags to differentiate and notate your materials. Finally, you will learn methods to share your notebooks with others, as well as export or print your notebooks if desired. Successful completion of this course will provide the tools you need to jump into the Desktop version of OneNote and begin crafting rich, detailed notebooks for organizing and sharing your thoughts with others.

44 videos
49 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 OneNote Desktop - Beginner
Microsoft 365 OneNote Online - Beginner

OneNote is a free-form note-taking application by Microsoft for cross-platform information gathering and collaboration. OneNote is included for Desktop and Online with Office 365 and can be accessed as a Windows application on the Microsoft Store. While each form of OneNote functions similarly, there are important differences to recognize when choosing which version is right for you. This course provides an in-depth look at OneNote Online 365. Through these lessons, you will learn how OneNote can help to organize your ideas and information more effectively and allow access to content on the cloud to share with others. You will learn how to open OneNote Online, create Notebooks, Sections and Pages, as well as modify Page details and more. We will also discuss and demonstrate ways to insert, format, and search for objects or text in your notebook sections and assign pre-defined tags to differentiate and notate your materials. Finally, you will learn methods to share your notebooks with others, as well as export or print pages if desired. Successful completion of this course will provide the tools you need to jump into the Online version of OneNote and begin crafting rich, detailed notebooks for organizing and sharing your thoughts with others in the cloud.

44 videos
47 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 OneNote Online - Beginner
Microsoft 365 Outlook Web App - Beginner

This course is designed to teach students the basics of Microsoft Outlook 365 Online and help them gain familiarity with the Outlook environment and basic functionality. It is important to note that this course will be focused on the Online version of Outlook 365. A separate course is available on how to use the Desktop version of Microsoft Outlook. The first chapter, Getting Started with Outlook Online, will provide a tour of Outlook 365's user interface. Participants will learn how to use the My Day view and request read receipts on sent emails. In the second chapter, Working with Emails, students will learn the basics of email, how to reply to received messages, and formatting email text. In the third chapter, Managing the Outlook Mailbox students will also learn organizational techniques through the use of Sweeps, Flagging, and creating and editing rules. The following chapters will provide a basic overview of how to use several of the Sub-applications that exist within Outlook 365 Desktop. These sub-applications include the calendar, the contact/people view, and the task list. Through this course, participants will gain a full overview on how to use Microsoft Outlook Online. This course is suited for both beginner-level and advanced-level users of Outlook Online

44 videos
121 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Outlook Web App - Beginner
Microsoft 365 Overview - Beginner

This course is designed to give an overview of Microsoft 365 features, functionality, and navigation of the online environment. Microsoft 365 is a productivity suite that allows a user to access many of the Microsoft Office tools and features online from any device with an Internet connection. It helps facilitate sharing and collaboration. Learn to sign into Microsoft 365 from anywhere, and navigate the Microsoft 365 environment. Learn to customize the environment to your specifications and download the Microsoft Office apps to your mobile device. This course has been retired and will no longer be updated. Please see our course, Getting started with Microsoft 365, for the most current content on this topic.

44 videos
26 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Overview - Beginner
Microsoft 365 Planner - Beginner

Microsoft Planner is a project management application developed by Microsoft that allows teams to create, assign, and organize work visually. With this web-based application, companies can better facilitate teamwork, as well as improve progress visibility and coordination. This course is designed to teach students the basics of Planner and help them gain familiarity with both the benefits and functionality of the application. Students will learn to create a new plan, use boards and buckets, work with members and tasks, and manage notifications. They will discover how to change views to better suit their workflow needs, ensuring that they can keep track of their projects more efficiently. Exporting data to Excel is another key feature covered in the course, which allows users to sort, filter, report on, and share their plans with people who aren't members of the plan. This can be particularly useful for generating reports and sharing progress updates with stakeholders. Additionally, the course will cover how to integrate Planner with other Microsoft applications. The course will also explain how to create a calendar feed to add key plan dates to Outlook Calendar, ensuring that all team members stay updated as the plan progresses. In summary, this course provides a comprehensive overview of Microsoft Planner, equipping students with the skills needed to effectively manage and coordinate their projects.

44 videos
37 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Planner - Beginner
Microsoft 365 Power Automate - Beginner

This course offers a basic overview of Power Automate, a Microsoft 365 app which allows users to create automated workflows. These workflows interact with other online apps in order to receive notifications, synchronize files, and collect data. Topics include the various types of Flows, how to build a Flow, and how to work with actions. Other topics include the use of approvals as well as how to share, import, and export a Flow.

44 videos
184 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Power Automate - Beginner
Microsoft 365 Power BI Desktop - Beginner

Modern business reporting demands the ability to visualize data within an organization's business context. Power BI Desktop is Microsoft's premier tool for visualizing data and for creating highly interactive dashboards. This course starts with the basics. Business Intelligence concepts are examined and explained. The process of grooming data for analysis is covered with demonstrations at each step. Connecting to data sources is the first step and this course covers several data sources as examples. Data may live in humble Excel workbooks, SQL databases, or the Power BI Service. Once data sources have been created, data must often be prepared before visualizations can be created. Data must be cleansed, transformed, and shaped before analysis can begin. Power BI Desktop has tools to assist with all these tasks. Each feature is examined and demonstrated. Many visualizations are created in this course. Each type is explained so that students understand why one visualization should be used instead of others. The lesser used chart types are given extra attention because their value is usually not understood without examples. Created in this course: Tables and Matrices, Text Based visuals, Column Charts, Line Charts, Interactive Legends, Waterfall Charts, Funnel Chars, Scatter Plot Charts complete with motion, Area and Stacked Area Charts are all created. Gauges and KPIs are also created. Finally, the Power BI Service is examined and used to create truly interactive dashboards that may be shared with other users within their organizations.

44 videos
194 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Power BI Desktop - Beginner
Microsoft 365 Power BI Desktop - Intermediate

Modern reports and dashboards are highly interactive and use data from multiple sources. Managers want real-time information for analysis and decision making. This course builds on the beginner course and enables dashboard creators to support these requirements. Data is only as up to date as its latest refresh. The location of data has refresh implications, as does the feature used by Power BI Desktop to connect to that data. This course covers the issues that must be addressed to determine the freshness of an organizations reporting data. Data often comes from different sources. When all that data together must be used for visualizations and analysis, the data must be modeled. Data modeling includes the topics: Table Relationships, Cardinality, Row-level Security, and Referential Integrity. Sometimes a data source does not have all the information that is required for reporting or forecasting. Calculated columns may be added to produce the data required for further analysis. Calculated columns are covered in this course. Visualizations that are not covered in the beginner course are covered here. This course includes: Donut Charts, Tree Maps, Line and Stacked Column charts, Line and Cluster Column charts, Maps, and Filled Maps. Perhaps mostly importantly, use cases that determine when each of these visuals is the best one to use are explained and demonstrated. Filters are introduced as a technique for interactively analyzing data. Filters may be applied to single visualizations, pages, or entire reports. Each has its place. Special filters are also included such as: Include / Excluded filters, Cross filters, Top N filters, and relative Date filters. Slicers are visual filters that enhance interactivity, especially on dashboards. There are various types of slicers, and this course covers date slicers, time slicers, numeric range slicers, and others. Even though dashboards are covered in the beginner course, there is so much that can be done with them! In this course, dashboards are created the use the new visualizations and that also incorporate filters and slicers!

44 videos
231 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Power BI Desktop - Intermediate
Microsoft 365 Power BI Report Builder - Beginner

Modern day report writing involves creating interactive reports that are published and shared with others within an organization. These reports must be accessible and usable on mobile devices. Microsoft's Power BI Report Builder joins the Power BI platform, along with other products, to deliver this functionality. This course is for beginners who need to learn how to create basic reports. In this course, reports are created, published, and accessed through a browser. The course begins with explanations of the related technology and necessary terminology. The steps for downloading Power BI Report Builder are demonstrated. The Power BI Service is introduced. Several completed reports are examined in order to explore the Report Builder environment and learn where all the necessary features are located. Data Sources are created that connect to several different data sources, including the Power BI Service itself. Datasets, which are essentially queries, are created next. Basic table reports are created and techniques for sorting and grouping follow. Matrices are created after the standard tabular reports are created. A matrix is as close we get to an Excel-style PivotTable in Report Builder. Expressions are like miniature formulae that often use Excel-style functions to produce results. Expressions are one of the most powerful aspects of Report Builder, so expect to see Expressions covered in the Intermediate and Advanced courses as well. Moving back to the Power BI Service, workspaces are examined as the containers for reports. Reports are stored here so that they may be shared with others. Finally, skills for printing, exporting, and publishing reports round out the course.

44 videos
259 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Power BI Report Builder - Beginner
Microsoft 365 Power BI Report Builder - Intermediate

This course continues where the beginner course leaves off. Parameters are introduced and integrated with datasets for customized selection of data. Drop-down lists are created for interactive filtering. Expressions are used to enhance reports. Visual formatting is added with alternating colors and rows, and conditional formatting is also applied. Expressions are used to correct for bad data. Top N filters are created along with running values. A number of functions are introduced like: IIF, SWITCH, ROWNUMBER and others. Charts for reports and dashboards are introduced with emphasis on the reasons for using specific chart types. Traditional charts are created as well as treemaps, sunburst charts, donut charts, funnel charts and scatter plots. Expressions and parameters are added to charts to customize appearance and add functionality. Advanced grouping is explored by creating groups with expressions. Hierarchies are created manually. Grouping layers are added manually for perfect control of all aspects of data groups. Interactivity is added to reports through interactive sorting, filtering, collapsible and expandable hierarchies, bookmarking, and document mapping. Maps are a staple on modern reports. To finish the course, geographic maps are added to reports to help analyze business data. These maps include heat maps and color maps. International maps are also created using spatial data available from the Internet.

44 videos
372 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Power BI Report Builder - Intermediate
Microsoft 365 PowerApps - Beginner

This course introduces the user to Microsoft PowerApps, a powerful tool within the Microsoft 365 suite, designed to facilitate the creation of custom apps without extensive coding knowledge. PowerApps allows users to create forms, gather data, and automate workflows, making it a successor to InfoPath. Throughout this course, you will learn the fundamentals of modifying SharePoint List Forms using PowerApps. Starting with an overview of the basic functionalities, you will progress to mastering PowerApp formulas, which are essential for customizing and enhancing the behavior of your apps. In addition to formula work, this course delves into some of the more advanced features that were previously a part of InfoPath, such as working with multiple data sources and integrating them seamlessly into your PowerApps. Furthermore, the course covers the practical aspects of distributing your PowerApp creations. You will learn how to share your apps with colleagues, embed them into websites or SharePoint pages, and export your apps for broader distribution. This comprehensive approach ensures that by the end of the course, you will not only be proficient in creating robust PowerApps but also in deploying them efficiently within your organization. By the conclusion of this course, you will have a solid foundation in Microsoft PowerApps, enabling you to contribute effectively to your organization's digital transformation efforts.

44 videos
249 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 PowerApps - Beginner
Microsoft 365 PowerPoint - Advanced

In this course, students will learn the more advanced functions available in Microsoft PowerPoint 365. They will be introduced to the various collaboration tools such as reusing slides, co-authoring in PowerPoint 365, and utilizing comments to make suggestions. Learners will also be taught to create slides from Microsoft Word documents, use data from Microsoft Excel spreadsheets, and compare and merge PowerPoint presentations. From there, students will learn to utilize the power of Slide Masters including creating global changes within a presentation, working with layout masters, and adding images to a slide master. The course will then cover how to add a footer to a slide, create custom design themes, and design custom presentation templates. In addition, students will learn to create exciting and accessible presentations by using advanced graphic features including creating and customizing SmartArt as well as adding Alt Text to images. After that, the course will cover advanced presentation features such as utilizing action buttons when presenting and creating a custom slideshow. Students will learn to present like a pro by using advanced slideshow options including slide annotations and timings. As the course concludes, learners will be comfortable configuring self-running presentations, creating video from a presentation, and package a presentation so that other people can watch it on most any computer.

44 videos
113 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 PowerPoint - Advanced
Microsoft 365 Project - Beginner

This course covers the basic functions and features of Project 365. Students will learn how to create, and enter task information into Project plans. They will learn how to manage project resources and assign them to tasks. They will also create custom project elements such as calendars, tables and views that can be used to monitor and manage important project information.

44 videos
128 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Project - Beginner
Microsoft 365 SharePoint Site Owner - Beginner

The SharePoint Site Owner course is a comprehensive video course designed to equip students with the knowledge and skills necessary to effectively manage and maintain SharePoint sites within their organization. This course offers an in-depth exploration of the roles and responsibilities of a SharePoint Site Owner, including the addition and configuration of sites, creation, and management of libraries and lists, and customization of columns and content types. Participants will gain hands-on experience in managing permissions and permission levels, ensuring secure and appropriate access to site resources. They will also learn to create and modify site pages, enhancing the user experience with tailored navigation and regional settings. The course emphasizes best practices for permission assignments, advocating for the use of groups over individuals and discouraging unique permissions at the item level for optimal site management. Furthermore, the course delves into the intricacies of SharePoint permissions, covering the default permission levels and groups and the importance of understanding inheritance, permission levels, and groups to maintain a secure and well-organized site. By the end of this course, students will be well-versed in the advanced functionalities of SharePoint Site Owner, ready to apply their learning to real-world scenarios and contribute to the efficient management of their organization's SharePoint environment.

44 videos
296 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 SharePoint Site Owner - Beginner
Microsoft 365 SharePoint Site User - Beginner

This course serves as a comprehensive introduction to Office 365 Sites, equipping users with a fundamental understanding of SharePoint Sites and their structure. By the end of this course, participants will have a clear grasp of the differences between the Modern and Classic views, enabling them to navigate and utilize each view effectively. The course will guide users through the essential tasks associated with libraries, such as adding files, managing document version control, and setting up alerts to stay updated on changes. Participants will also learn how to work with lists, including adding items and creating custom views to tailor the interface to their specific needs. A key component of the training is the search functionality within SharePoint Sites. Users will become adept at searching for content, ensuring they can quickly locate the information they need. Additionally, the course covers file synchronization, allowing users to keep their documents up-to-date across devices. Understanding permissions is crucial for managing access to content, and this course will introduce users to the basics of permissions, helping them control who can view and edit their documents. By the end of the course, users will be well-prepared to utilize SharePoint Sites effectively, enhancing their productivity and collaboration within Office 365.

44 videos
191 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 SharePoint Site User - Beginner
Microsoft 365 Sway - Beginner

Sway is an application which is included as part of the Microsoft 365 suite. In this course, students will gain a basic understanding of the purpose, features, functionality, and navigation in Sway. Sway makes it easy to create and share interactive reports, personal stories, presentations, and more. Students will first learn how to create a new project. This can be done from scratch or from a template. New Sways can also be created from an existing document such as a Word document. Students will learn how to use the Storyline view in Sway where most of the editing will take place. Also, they will gain familiarity with the Design view which previews what the final product will look like while still allowing for some minor editing. The course will cover how to add and format text. Students will learn how to add media like images, video, and audio. They will also learn how to change the look of the Sway by utilizing the Design view. This view will make it possible to adjust the styles, fonts, colors and much more. Students will learn how to share a completed Sway with others. A link can be created with specific permission levels and then sent out. The Accessibility checker will also be reviewed to ensure Sways that are created will work for all.

44 videos
60 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Sway - Beginner
Microsoft 365 Teams - Beginner

Teams is the hub for teamwork in Microsoft 365, providing a centralized workspace for teams to communicate and collaborate effectively. This course is designed to help learners harness the full potential of Microsoft Teams by exploring its various features and functionalities. Learners will begin by learning how to create teams and add users, ensuring that everyone in the organization can participate in collaborative efforts. They will also learn how to manage a team, which includes setting permissions, adding or removing members, and customizing team settings to suit specific needs. Communication is a key aspect of teamwork, and this course will cover how to start a team conversation, reply to a conversation, and use persistent and threaded chats to keep discussions organized and accessible. File sharing is another crucial feature, and learners will learn how to add files to a team, share them with members, and collaborate on documents in real-time. In addition to these basics, the course will delve into the use of channels within Teams. Learners will explore how to create new channels for different projects or topics, share files within these channels, and ensure that all relevant information is easily accessible to team members. The course will also cover the integration of Teams with other Microsoft 365 applications, such as SharePoint. Learners will learn how to add tabs to keep important files, notes, and apps readily available within Teams. They will also explore the use of connectors to access content and get updates from various services directly within the Teams interface. Furthermore, the course will teach learners how to work with meetings in Teams. This includes scheduling team meetings, sending out invitations, and managing meeting settings. By the end of the course, learners will have a comprehensive understanding of how to use Microsoft Teams to enhance collaboration and productivity within their organization.

44 videos
148 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Teams - Beginner
Microsoft 365 To Do - Beginner

To Do is a Microsoft app which is part of the Microsoft 365 suite. It can be used to create individual tasks and to do lists. These tasks can be broken down into smaller steps, assigned due dates, and much more. Students will learn how to create tasks, lists, and groups. They will learn how to manage, track, and complete these tasks, and utilize the integration that is set up with Outlook and Teams. To Do is a Microsoft app that is part of the Microsoft 365 suite, designed to help users manage their tasks efficiently. This course will dive into the functionalities of Microsoft 365 To Do, guiding students through the process of creating individual tasks and comprehensive to-do lists. Each task can be broken down into smaller, manageable steps, assigned due dates, and categorized for better organization. The course will cover how to prioritize tasks, set reminders, and track progress to ensure productivity. Students will also learn how to create and manage lists and groups, making it easier to keep track of different projects and responsibilities. The integration of To Do with other Microsoft 365 applications, such as Outlook and Teams, will be a key focus, showing how tasks can seamlessly sync across platforms to enhance workflow and collaboration. By the end of the course, learners will have the skills to efficiently manage their workload, utilize To Do's features to their full potential, and integrate task management into their daily routines. Whether you are a professional looking to streamline your tasks, a student aiming to keep track of assignments, or anyone seeking to improve their productivity, this course will provide the tools and knowledge necessary to master Microsoft 365 To Do.

44 videos
48 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 To Do - Beginner
Microsoft 365 Video - Beginner

Video is an app included in Microsoft 365 which allows a user to upload, share, stream, and play videos. In this course, students will gain a comprehensive overview of Video, including how to navigate in the app and how to watch videos. They will also learn how to search for videos, as well as use channels as a way to organize and share videos. In addition, students will learn how to edit channel settings, share videos with others, and edit permissions in Microsoft 365 Video.

44 videos
29 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Video - Beginner
Microsoft 365 Visio Desktop - Beginner

This course teaches the basic functions and features of Visio Professional 365. The primary focus is to get acquainted with creating the different diagrams using the stencils and templates. You will learn how to draw basic shapes and compound lines and arrange objects. You will also learn how to create diagrams, work with text, and apply formatting. Finally, you will create organization charts and brainstorming diagrams, set shape properties, and work with pages.

44 videos
143 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Visio Desktop - Beginner
Microsoft 365 Visio Online - Beginner

This course teaches the basic functions and features of Visio Online. Visio online is accessible through any browser, which makes diagram creation easily accessible. The primary focus is to get acquainted with creating the different diagrams using the shapes and templates within Microsoft Visio. Microsoft Visio Online is a web-based flowchart and diagramming tool. Visio offers several templates for different types of diagrams, including flowcharts, process diagrams, and timelines. Visio online is often used to visualize complex information and communicate ideas. You will learn the difference between Visio Online and Visio Desktop, and the benefits of each. Learners will get a complete overview of the Visio environment, including a review of the tool bar. This course covers all aspects of the Visio online program which will help you will learn how to draw basic shapes, format shapes, group shapes, and arrange shapes. You will also learn how to create diagrams, organizational charts, work with text, apply formatting, and work with pages. You will learn how to change the stacking order of shapes and insert pictures and pages into your Visio document. Lastly, you will learn how to share diagrams with colleagues and others in your organization and start a review process.

44 videos
44 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Visio Online - Beginner
Microsoft 365 Word - Beginner

This video course is designed to introduce students to the basic functionality and user interface of Microsoft Word 365. In this course, students will learn the basics of saving and opening documents and review the Word 365 interface. Students will practice text navigation, selection, entry, and various other text formatting and editing commands and features. Students will learn about the Word 365 Accessibility Checker, which reviews documents and makes suggestions to ensure that document content is properly formatted to be accessible for people with disabilities. Students will also review the sharing and co-authoring features of Word 365, which include online file sharing, real-time collaboration, detailed version history, and file recovery options to prevent lost work while collaborating. Additionally, students will learn about the Inking Tools that facilitate a range of additional editing and drawing features for touch-enabled devices. Next, students will work with bulleted and numbered lists and tables and their various features and options to organize and manage information in their documents. Students will also work with graphics and the various tools available in Word 365 to format and edit them. Lastly, this course will cover various options for viewing documents, proofing options for documents, and settings to prepare documents for distribution and publication.

44 videos
261 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Word - Beginner
Microsoft 365 Word - Intermediate

This is the intermediate course in the Microsoft Word 365 video course series. This course expands upon the topics covered in the Word 365 Introduction video course and introduces more advanced and powerful options for document customization and design. In this course, students will work with, create, manage, and customize Styles, Templates, and Themes to update document design quickly and efficiently. Students will also work with various types of data in Word using Lists, Tables, advanced Copy and Paste commands, and Charts. Students will review options for sorting, formatting, designing, and editing Lists, Tables, and Charts to best match the data contained and the display needs of particular projects. Students will then review advanced document layout options in Word to customize the appearance of content and various collaboration tools such as Comments, Tracking Changes, and Markups to facilitate co-working. Lastly, students will learn to work with graphic elements such as pictures, text boxes, shapes, the Drawing Canvas, SmartArt, Text Effects, Typography Effects, WordArt, and Equations to create more functional and visually compelling documents. Students will also learn about additional graphic element features such as grouping, layering, and moving objects to arrange and manage graphics and perfect the final appearance of project documents.

44 videos
349 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Word - Intermediate
Microsoft 365 Word - Advanced

This video course builds on the knowledge developed in the Word 365 Beginner and Word 365 Intermediate courses and introduces more sophisticated and powerful features of Word 365. In this course, students will automate with Microsoft Word 365 through the use of building blocks, Quick Parts, fields, and Macros, which allow users to simplify complex or repetitive processes. Students will utilize reference tools such as bookmarks, hyperlinks, cross references, footnotes, endnotes, bibliography tools, sources, and placeholders to improve navigation and clarity within documents, allow communication between documents, and facilitate referencing outside sources. Students will also learn techniques to manage long documents through a table of contents, indexing, and captions. Students will learn about working with Outline View to facilitate more detailed editing and formatting of documents and master documents to link documents together, create subdocuments, and facilitate co-authoring of long or complex documents. Students will learn about using Mail Merge to create and sort mailing lists with integrations in Excel and Outlook and using merge fields to customize outcomes for specific conditions. Finally, students will learn about creating forms in Word with different display and input options that facilitate sharing, adding content controls and protecting forms, and entering and managing data.

44 videos
196 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft 365 Word - Advanced
Microsoft Stream for SharePoint - Beginner

Stream (on SharePoint) is a part of the Microsoft 365 suite and replaces the former Stream (Classic). Microsoft has taken a new approach to working with videos in Microsoft 365 using the new Stream. Videos are now treated the same as any other file type in Microsoft 365. Stream is no longer a storage place for videos. They are stored in SharePoint or OneDrive. Stream (on SharePoint) is the application that is used to open, view, and adjust the settings of videos. It also can be used to record new videos. In this course, students will learn all the basic features, functionality, and navigation in Stream (on SharePoint). They will learn how to find videos using the Recommended section, the search, and the filtering options. They will also learn how to record their screen or video using Stream. Students will learn how to adjust the name, description, options, and settings for videos that they own. This includes adjusting the video thumbnail, adding transcripts and captions, and adding chapters. They will also learn how to manage the playback settings for any video they view in Stream. This course will instruct students on how to share videos with others. Videos can be shared by link, email, or granting direct access to colleagues. Students listen also learn how to collaborate on videos, using comments including using @mentions.

44 videos
57 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Microsoft Stream for SharePoint - Beginner
Outlook 365 - Beginner

This course is designed to teach students the basics of Microsoft Outlook 365 and help them gain familiarity with the Outlook environment and basic functionality. It is important to note that this course will be focused on the Desktop application version of Outlook 365. A separate course is available on how to use the Online application version of Microsoft Outlook. The first chapter, the first look at Outlook, will provide a tour of Outlook 365's user interface. Participants will adjust reading options and navigate the main tabs and sub-applications within Outlook 365. In the second chapter, creating and sending messages, students will learn the basics of email, how to create and send messages, and how to work with attachments. In the third chapter, Managing and Organizing the Outlook Mailbox students will also learn organizational techniques through the use of folders, views, categories, flags, and searching. The Fourth, Fifth and Sixth chapters will provide a basic overview on how to use several of the Sub-applications that exist within Outlook 365 Desktop. These sub applications include: the calendar, the contact/people view, and the task list. The final chapter in this course will round up the basic overview by discussing several techniques that help increase efficiency in Outlook. These include using the focused inbox, creating and using signatures, setting out of office replies, and creating quick steps.

44 videos
179 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Outlook 365 - Beginner
Outlook 365 - Advanced

In this course, students will expand upon their existing knowledge and learn and use advanced features of Microsoft Outlook 365. Students will modify and manage message options, track and delivery options, voting options, contact options, calendar options, and other advanced Outlook features. Students will also review rules and automation, cleanup commands, sharing options, advanced graphic options, junk mail options, import and export features, and how to back up their Outlook data.

44 videos
108 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Outlook 365 - Advanced
Power Apps - Enhanced Skills - Intermediate

Microsoft Power Apps became available in 2016. Since then, it has continually added features and functionality for technical personnel and citizen developers alike. Inevitably, developers want to accomplish very specific tasks, and those tasks do not fit neatly into a beginner, intermediate, or advanced level class. Power Apps – Enhanced Skills is a course based upon customer needs and requests. All are invited to take it, as long as the basics have been mastered. This course contains ten chapters covering a range of topics. These include: Uploading Files is a common requirement. Learn which controls and functions are required to upload a single file or multiple files to a data source, including SharePoint. Pop-up windows, similar to dialog boxes, are another favorite. Creating them is not obvious but it can be done. Canvas apps can interact with data from Microsoft’s Dataverse. Model-driven apps are not always required. Learn how to create a table based on another table and then interact with it from a canvas app. Managing that data is the next step. This is often done with a variety of functions, like Patch, ForAll, Table, Lookup, and more. Each function is given thorough coverage. Taking data from a screen and sending as a PDF document via email is almost a necessity now so techniques to do this are covered. When those PDFs need to be sent to a SharePoint site, a slightly separate set of skills are needed, and this process is explained in detail. Users who work with complex variables often need to merge them. The functions required to do this are covered as well, using Collect, ClearCollect, and others. Delegation issues eventually challenge all developers of all levels. Learn what delegation is, its limits, and how to push past those limits. Responsive apps adjust themselves to the dimensions of the mobiles devices on which they run. Doing this properly requires understanding containers in containers, initial screen properties, and other issues. Watch how these challenges are handled. When Power Apps need to talk to each other, this may be done by passing parameters in a URL. Learn how this works and make your own apps talk to each other!

44 videos
189 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Power Apps - Enhanced Skills - Intermediate
PowerPoint 365 - Beginner

In this course, students will get started with the basics of Microsoft PowerPoint 365. Learners will become familiar with opening the PowerPoint application, utilizing the Ribbon and interface, and navigating the different views and options. They will learn how to create a presentation on their own and work with various features and commands to update and customize their presentations with ease. This course will also review how to format slide text including character and paragraph formatting, using Format Painter, customizing bulleted lists and creating numbered lists as needed. Students will then be taught how to edit a presentation by moving and copying slides as well as cutting and copying slide content to paste it onto other slides. From there, learners will be taught how to work with graphics including pictures and shapes. They will learn how to insert, resize, arrange and format graphics to add visual appeal to their presentations. As the course concludes, students will be taught how to proof, print, and deliver a presentation so they are prepared to apply what they have learned and present their work to the desired audiences. Once completed, learners can test their knowledge in the course assessment to solidify what they have learned.

44 videos
95 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
PowerPoint 365 - Beginner
PowerPoint 365 - Intermediate

In this course, students will take a deeper dive into Microsoft PowerPoint 365 in order to learn how to better organize their presentations and make them even more visually appealing. They will be taught how to utilize outline view to edit and arrange text as well as how they can create slide sections and Zooms to further organize their presentations. In addition, students will learn to create exciting and dynamic presentations by animating text and objects and adding slide transitions. Learners will then be taught how to use more advanced graphic features including text boxes, WordArt, and 3D models to add even more interest to their presentations. From there, the course will cover how to create tables and charts as well as how to format and design them to present data in clear, visually appealing formats. Students will then learn how to insert and configure media files such as audio and video and add hyperlinks that will work within their presentations. As the course concludes, students will be shown additional presentation tools including how to work with speaker notes and handouts, rehearse using Presenter Coach, and record a presentation that they can utilize to ensure they are making the most of their presentations.

44 videos
183 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
PowerPoint 365 - Intermediate
Project 365 - Advanced

This course is designed to cover the essential features within Microsoft Project 365 that every project manager needs to master. Students will learn how to update tasks, split tasks, reschedule project work, move a project, and set new baselines, ensuring they can manage their projects efficiently and effectively. Additionally, the course will teach students how to use the variance table to monitor project performance, display progress lines to track progress visually, and edit and create custom tables to organize project data according to specific needs. Students will also learn to create custom views and sort and filter project information, enabling them to tailor the project interface to their preferences and improve their workflow. Moreover, students will work with Project reports, learning how to create custom reports that provide valuable insights into project status and performance. They will also explore visual reports, which use graphical elements to present data in an easily digestible format. Finally, the course will cover advanced topics such as setting default options, saving a project template for future use, using the content organizer to manage project documentation, comparing different Project versions to identify changes, and working with Subprojects to manage larger projects effectively. By the end of this course, students will have a comprehensive understanding of Microsoft Project 365 and the skills needed to utilize its full potential.

44 videos
86 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Project 365 - Advanced
SharePoint Sites 365 Fundamentals of Site Management - Intermediate

This course is an introduction to the Fundamentals of SharePoint Site Management. Upon completion, users will have a basic understanding of SharePoint Sites and the structure of Sites, navigation, libraries, searching, views, permissions, and organization. Students will learn the differences between Libraries and Lists, how to create different kinds of Libraries and Lists, add files to Libraries, and add items to Lists. Additionally, the course covers how to create and customize Views to meet specific needs. Throughout the course, students will explore site content organization and understand site navigation. They will learn effective search techniques to locate content efficiently. The course also provides an introduction to Permissions, ensuring that students understand how to manage access and security within SharePoint Sites. Learners will delve into the intricacies of SharePoint site's features and functions, enabling them to utilize the platform to its fullest potential. By the end of the course, learners will be proficient in managing SharePoint Sites, creating various libraries and lists, and utilizing customized views. They will have the tools to organize site content effectively, navigate through sites seamlessly, and search for content swiftly. This comprehensive course is designed to equip students with the essential skills needed for proficient site management and to prepare them for more advanced SharePoint functionalities.

44 videos
160 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
SharePoint Sites 365 Fundamentals of Site Management - Intermediate
Skype for Business - Beginner

This course is designed to teach users about instant messaging with Skype for Business (formerly Lync). Users will learn about contacts, groups, meetings, and various presentation capabilities.

44 videos
121 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
Skype for Business - Beginner
The Foundations of Power Platform - Beginner

Confused about Power Business Intelligence? Then this is your starting course. This course starts with the basics by defining the Power Platform and the applications that run on top of it. Each application is examined and demonstrated with its basic functionality. If you've ever felt lost in a conversation with your colleagues concerning Power BI, then this course is for you. All terminology is explained, and nothing is left to speculation. Accessing each application is demonstrated. Those who are new to the platform have an opportunity to work with each app by using the exercise files provided with the course. Ready to try Power BI Desktop, Power BI Report Builder, Power Automate, Power Apps, Power Pages, and Virtual Agents? Then start here. There is no need to be a programmer or a technical person to participate in this course. There is much to be learned just by watching, even if you do not want to try what your instructor is doing. Learn how Power BI Desktop creates visualizations, how Power BI Report Builder creates reports, and how the other apps perform their magic. To become proficient with each app, there are courses available that start at the beginner level and progress to intermediate and advanced levels.

44 videos
271 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
The Foundations of Power Platform - Beginner
What is Power BI Desktop - Beginner

This course is an overview of Power BI Desktop and the Power BI Web App. Both products are used to create and publish visualizations. The course is not limited to a specific level of user. Users who are at a beginner level or intermediate level will find various topics accessible and usable. The features of the Desktop App and the Web App are carefully compared and demonstrated. Navigation within the two apps is examined first. There are different types of data sources to which connections may be made. This course covers files, Power BI datasets, and SharePoint lists. Though not a course in data modeling, this course does cover table relationships, calculated columns, measures, and even calculated tables. Various visualizations are created and formatted. Column and bar charts, line charts, maps, and other types of visuals are created, some of which appear on dashboards later in the course. The Analytics feature and the Insight feature are used to increase the usefulness of the visualizations. Reports and Dashboards are published to the Web Service. Worksheets and dashboards created in Excel are published first, then Power BI Desktop reports are published. Parts of each are used to create new dashboards in the Power BI Service. Other topics are covered as well such as the Power BI Gateway and Power BI for mobile devices.

44 videos
228 minutes

VIDEOS

Introduction
00:52
Starting Access
02:07
Navigating the Main Screen
00:57
Using the Quick Access Toolbar and Ribbon
01:22
Using the Navigation Pane
01:08
Navigating in the Document Window
02:17
Opening a Table
02:40
Navigating a Table
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Understanding The Design View
07:23
Setting Input Masks
02:21
Using The Lookup Tab
01:19
Indexing A Table 
05:04
Adding a Record
03:03
Using Zoom Mode
01:45
Using Shortcut Keys
03:32
Filtering Data
02:35
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing Table Appearance
04:29
Understanding Query Types
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Understanding Forms
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving, and Resizing Controls
17:00
Understanding Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Course Recap
01:32
What is Power BI Desktop - Beginner