Hands-On Microsoft Access 2019: Build efficient database solutions with MS Access 2019

Key benefits

• 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

Description

Who is this book for?

What you will 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