PLU | Access 2019 Essentials (2019 EN)

Company: Pluralsight
Author: Shari Oswald
Full Title: Access 2019 Essentials
Year: 2019
Language: English
Genre: Educational: Databases
Skill Level: Beginner
Price: -
-
Files: MP4 (+ Subtitles .SRT)
Time: 01:38:50
Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 550 kbps
Audio: AAC at 96 Kbps, 2 channels, 48.0 KHz



In this course, you’ll learn the basics of working with Access 2019. You'll explore the Access user interface and begin the process of building working database solutions.

Microsoft Access is an information management tool that helps you store information for reference, reporting, and analysis. In this course, Access 2019 Essentials, you will be will introduced to Access 2019, Microsoft’s application for creating working database solutions. First, you’ll begin with navigation lessons to help you find your way around the Access interface. Next, you will explore the basics of working with databases and tables. From there you’ll move into working with and sorting records, working with filters, forms, queries, and reporting. Finally, you'll explore and understand database objects. When you’re finished with this course, you will have the skills and knowledge of Access 2019 needed to begin development (and begin preparation for the Microsoft Office exams).


Lessons:
1. Getting Started with Microsoft Access
01. Getting Started
02. Database Basics
03. Opening Microsoft Access
04. The Getting Started Window
05. Opening an Existing Database
06. Touring the Access Interface
07. Working with the Ribbon
08. Using the Quick Access Toolbar
09. Using the Help Features
10. Using Tell Me
11. Setting Navigation Options
12. Closing Microsoft Access
2. Working with Databases and Tables
13. What Is a Table?
14. What Is a Record?
15. Adding Data Using a Table
16. Adding Data Using a Form
17. Viewing Data Using a Query
18. Viewing Data in a Report
3. Table Basics and Sorting Records
19. Opening an Existing Table
20. Exploring Tables
21. Navigating in Datasheet View
22. Entering Data in a Table
23. Finding a Record in a Table
24. Editing a Record
25. Finding and Replacing Values in Records
26. Using Spell Check
27. Selecting Records
28. Deleting Records from a Table
29. Printing Records
30. Sorting Your Records
31. Sorting Using Multiple Fields
32. Removing a Sort
4. Working with Filters and Forms
33. What Are Filters?
34. Filtering Records by Selection
35. Filtering Records Using Multiple Values
36. Clearing a Filter
37. Using the Column Filter Menu
38. Toggling a Filter
39. Filtering Records Using Forms
40. What Are Forms?
41. Opening an Existing Form
42. Exploring Forms
43. Navigating in Forms View
44. Entering Data in a Form
45. Finding and Replacing Data in Form View
46. Sorting and Filtering Records in Forms
5. The Basics of Queries and Reports
47. What Is a Query?
48. Opening an Existing Query
49. Exploring Queries
50. Sorting Query Results
51. Filtering Data in a Query
52. What Is a Report?
53. Opening an Existing Report
54. Exploring a Report
55. Previewing a Report
56. Printing a Report
6. Working with Database Objects
57. What Are Database Objects?
58. Managing Database Objects
59. Printing Database Objects
60. Using the Create Ribbon
61. Creating a Table from a Template
62. Using the Simple Query Wizard
63. Create a Basic Form Using the Wizard
64. Create a Quick Report the Report Wizard
65. Using the Label Wizard

Our members see more. Join us!
-------------
Our members see more. Join us!