Intellezy Course Catalog
Thousands of award winning videos

Categories

Microsoft 365

Microsoft Office

Google Workspace

Adobe

Microsoft Windows

General Computing

Business Skills

Security

Technical

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
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
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
45   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
6   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
41   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
28   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
18   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
36   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 - 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
187   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 - 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
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 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
56   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
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 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
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 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
135   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
33   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
171   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
213   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
241   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
280   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 Stream (Classic) - 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
52   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
59   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
217   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
51   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
46   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 Yammer - 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
36   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
PowerPoint 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
178   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 - 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
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
146   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
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
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
Word 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
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
Word 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
340   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 course is designed to give an overview of the Microsoft 365 suite and how to use it for collaboration. Work online, offline, and in collaboration with others. Students will create a plan, create and share a document, and learn to collaborate in Teams. Students will learn to co-author in Microsoft 365, use Yammer and Teams to get feedback and use Microsoft Lists to help create better delegation when working on projects.

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
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
45 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
6 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 provides an in-depth exploration of Copilot in Teams, an AI-powered assistant that revolutionizes the way you work within Microsoft Teams. Copilot is your everyday AI companion that helps you with a blank page or the perfect choice of words. It streamlines tasks so you can boost your productivity and creativity.This beginner-level course requires a basic understanding of Teams and promises to impart the skills necessary to harness Copilot's full potential. The curriculum includes: • Introduction to Copilot: Discovering the capabilities and benefits of using Copilot in your Teams environment. • Access and Integration: Learning how to access Copilot and integrate it seamlessly into your Teams workflow. • Content Generation: Utilizing Copilot to generate content, enhance writing, and facilitate effective communication. • Collaboration: Collaborating with team members using Copilot's insights and suggestions for a more productive teamwork experience. • Practical Application: Applying Copilot's features in real-time during meetings and chats for actionable suggestions and summaries. The course is structured to provide hands-on experience with Copilot, ensuring that you can apply the knowledge practically. You will engage with various features of Copilot, such as summarizing meetings, and crafting emails, which will enable you to streamline tasks and elevate your productivity and creativity. 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
41 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
28 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
18 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
36 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 - Intermediate

In this course, students will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. Students will also apply conditional formatting, outline with subtotals and groups, display data graphically with charts and sparklines. Additionally, students will also understand PivotTables, PivotCharts, and slicers and work with advanced PivotTables and PowerPivot features.

44 videos
187 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 - Intermediate
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 - 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 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 environment. Learn to customize the environment to your specifications and download the Microsoft apps to your mobile device

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
Getting Started with Microsoft 365 - 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 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
56 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
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 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
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
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
135 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 versatile project management application developed by Microsoft that enables teams to visually organize, assign, and manage tasks. As a web-based tool, it provides a centralized platform for teams to collaborate more effectively, making it easier for organizations to track progress, improve coordination, and enhance overall productivity. With features such as boards, buckets, and task assignments, Microsoft Planner helps streamline workflows, ensuring that every team member has a clear understanding of their responsibilities and deadlines. This course is designed to introduce students to the fundamentals of Microsoft Planner, guiding them through the essential tools and features necessary for effective project management. Students will learn how to create a new plan, assign tasks to team members, and organize work using boards and buckets. The course will also cover how to manage team members, monitor task progress, and set up notifications to ensure timely updates. In addition, students will explore how to customize views to better visualize tasks, export data to Excel for reporting purposes, and integrate Microsoft Planner with Microsoft Teams for seamless communication and collaboration. By the end of the course, participants will have the practical knowledge that is needed to use Microsoft Planner efficiently in their day-to-day work.

44 videos
33 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
171 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
213 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
241 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 tool that allows you to create forms and gather data. PowerApps is part of the Microsoft 365 suite and is the successor to InfoPath. In this course, you will learn how to modify SharePoint List Forms using PowerApps as well as how to work with PowerApp formulas. This course will also review some of the more advanced features of InfoPath, such as working with data sources. Finally, you will look at how to distribute your PowerApp, including how to share, embed, and export your app.

44 videos
280 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 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 Stream (Classic) - Beginner

This course is designed to teach students about Microsoft 365 Stream. Stream is a video service app in the Microsoft 365 suite where people in an organization can view all video content provided by their organization. Stream integrates seamlessly with applications across the Office Suite so users can create, share, discover, and manage video easily and securely within Stream and other Microsoft 365 applications. Users can access content via created Groups and Channels and if given Admin privileges, can provide or restrict viewing and creation access. Stream users can watch videos from across their organization in the Stream application or in other applications at any time, on any device. Users can also create live events using Microsoft Stream across the organization. They can schedule, produce, and deliver live events for a variety of scenarios such as companywide events, leadership updates and more. Live events enable producers to curate and control the content that is broadcast to an audience. This course was renamed to Microsoft 365 Stream (Classic) and will not receive any more updates as Microsoft is phasing it out.

44 videos
52 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 Stream (Classic) - 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
59 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. It features persistent and threaded chats, file sharing, and the ability to hold meetings. Students will learn to create teams, add users, manage a team, start a team conversation, reply to a conversation, and add files. In addition, students will explore channels, create new channels, create and share files, work with meetings, schedule team meetings, integrate with SharePoint, add tabs to keep files, notes and apps available, and connectors to access content and get updates.

44 videos
217 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.

44 videos
51 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. The primary focus is to get acquainted with creating the different diagrams using the shapes and templates. You will learn the difference between Visio Online and Visio, and the benefits of each. You will learn how to draw basic shapes, format shapes, group shapes, and arrange shapes. You will also learn how to create diagrams, work with text, apply formatting, and work with pages. Lastly, you will learn to share diagrams and start a review.

44 videos
46 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 Yammer - Beginner

In this course, students will gain familiarity with the features and functionality of Yammer in Microsoft 365. Students will overview the interface and features, navigate Yammer, edit a profile, work with and manage conversations, work with communities, and connect to an external network. Additionally, students will work with and manage messages, search Yammer, create posts such as polls, give praise, and make announcements.

44 videos
36 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 Yammer - Beginner
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
PowerPoint 365 - Advanced

In this course, students will learn the various collaboration tools in Microsoft PowerPoint 365 such as reusing slides, creating slides from Word, and working with Excel. Students will learn to utilize the power of Slide Masters, create custom themes, and design custom templates. In addition, students will learn to create exciting presentations by animating text and objects, add slide transitions, and use advanced graphic features including SmartArt, and audio and video. Finally, students will present like a pro by using advanced presentation features including annotations, hyperlinks and action buttons, timings, recordings, and creating videos, and review additional advanced slideshow options.

44 videos
178 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 - Advanced
Project 365 - 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
Project 365 - Beginner
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 Site Management. Upon completion of this course, users will have a basic understanding of SharePoint Sites and Sites structure, navigation, libraries, searching, newsfeeds, views, permissions, and organization. Students will learn the differences of Libraries and Lists and how to create different kinds of Libraries and Lists, add files to Libraries, add items to Lists, learn to use the Newsfeed to keep abreast of action on the site, and create and customize Views. In addition, students will explore Site and content organization, understand navigation of sites, search for content, and learn the basics of Permissions.

44 videos
146 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
Word 365 - 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
Word 365 - Beginner
Word 365 - 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
Word 365 - Intermediate
Word 365 - Advanced

In this course, students will automate with Microsoft Word 365 through the use of building blocks, Quick Parts, fields, and Macros. Students will also utilize reference tools such as bookmarks, hyperlinks, cross references, footnotes, endnotes, bibliography tools, sources, and placeholders. Students will also learn techniques to manage long documents through a table of contents, indexing, and captions. Students will also work with Outline View and master documents, Mail Merge, and forms.

44 videos
340 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
Word 365 - Advanced