PAC | Hands-On Microsoft Access 2019 (2020 EN)

Company: Packt Publishing
Author: Ben Beitler
Full Title: Hands-On Microsoft Access 2019
Year: 2020
Language: English
Genre: Educational: Software
Skill Level: -
Price: €124.99
-
Files: MP4 (+ Code Files)
Time: 07:18:05
Video: AVC, 1920 x 1080 (1.778) at 30.000 fps, 450 kbps
Audio: AAC at 112 Kbps, 2 channels, 48.0



Get more productive with Microsoft Access 2019.

Microsoft Access 2019 is an information management tool that stores information and, arguably, helps manage data more efficiently than other spreadsheet apps. It is an ideal and particularly useful tool for small-to-medium-sized (SME) businesses.

This will be a practical, beginner-level course with hands-on, real-world examples you can use as models for your own activities. Beginning with a quick introduction to an example Access database, you will cover the core concepts, interface, and terminology you need to get started. You will then master the key components of data query management; forms to help you view, add, edit, and even delete data in a controlled environment. Then, you will publish your data with the help of built-in reporting, and move on to work with RDBMS concepts relating to ‘joins’ and why they’re important. You’ll find out how to automate your Access database by creating and applying macros and learn about VBA programming and how it’s used with Access.

By the end of the course, you will be confident in your new skills in Microsoft Access 2019 to improve productivity, and data visualization.


Learn:
✓ How and why Access provides an ideal solution to store, manage, and manipulate data, whilst keeping it all in one place and synchronized with your daily activities
✓ Core fundamentals of building simple-to-use queries that help you get the answers you need from your data
✓ Create great-looking forms for end users to submit and view data in easy-to-use layouts
✓ Build simple-to-use (and simple-to-visualize) reports for publication to meet the needs of all stakeholders in your organization
✓ Automate parts of a database with the aid of macros and VBA code for ease of use without learning to be a programmer
✓ Create links with other applications using simple import and export features
✓ Handle back-end database administrative tasks for maintaining data and objects in Access

Features:
✓ A ‘one-stop’ shop to learn about data management, interrogation, reporting and automation using all the key Access tools (tables, queries, forms, report, and macro)
✓ Hands-on, practical training to get you up and running with an industry-leading database management suite that can integrate with core Microsoft applications (including r Excel, Word, and Outlook), exchanging data with ease
✓ Take advantage of organizing data sets into logical units that take advantage of RDBMS, simulating real-world business/organizational workflows and processes


Lessons:
1. Microsoft Access - In the Beginning
01. The Course Overview
02. Microsoft Access Components and Terminologies
03. How to Plan and Build an Access Database
04. Building Tables and Fields with Data Types
05. Working with Table and Field Properties
06. How to Import and Export Data
2. Asking Questions Using Queries
07. Building Your First Query and Setting Criteria
08. Calculating in a Query Using the Expression Builder
09. How to Summarize and Group Data in a Query
10. Building a Parameter Query
11. Creating Action Queries
3. Engaging with Data Using Forms
12. Building Quick Forms
13. Building a Form from Scratch
14. Working with the Property Sheet for a Form
15. Building a Popup Form
16. Building Navigation Forms
4. Publishing Your Data Using Reports
17. Building Quick Reports
18. Building a Report from Scratch
19. Working with the Property Sheet for a Report
20. Building a Multi-Page and Sub Report
21. Using the Report Wizard
5. Building Meaningful Relationships
22. Understanding and Setting Primary and Secondary Keys
23. Understanding What Normalization Means
24. Different Types of Joins
25. Applying Joins between Tables and Queries
26. Understanding the Relationship Window
6. Adding 'Bells and Whistles' Using Macros
27. What Are Macros and Their Benefits
28. Macro Designer Windows and Controls
29. Working with Key Commands and Parameters
30. Understanding and Setting Auto Macros and Debugging a Macro
31. Working with Data Macros
7. Introducing You to VBA Programming
32. A Quick Introduction to VBA
33. The Visual Basic Editor and Settings
34. Understanding the VBA Code
35. Working with VBA in Access (Events)
36. Testing and Debugging VBA Code

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