|
Published:
October 23, 2018

Access 2019 For Dummies

Overview

Easy steps to practical databases

People who really know how to build, populate, and simplify databases are few and far between. Access 2019 For Dummies is here to help you join the ranks of office heroes who possess these precious skills.

This book offers clear and simple advice on how to build and operate databases as well as create simple forms, import data from outside sources, query databases for information, and share

knowledge in reports. In short, it’s the book that holds all the secrets behind the mysteries of Access!

  • Build effective databases from the ground up
  • Simplify your data entry with forms and tables
  • Write queries that produce answers to your data questions
  • Simplify input with forms

There’s no time like the present to get your hands on the insight that database beginners need to become Access gurus.

Read More

About The Author

Laurie Ann Ulrich has trained more than 20,000 people to make better, more creative use of their computers. She has created online courses and written more than 30 books.

Ken Cook built and manages a computer consulting business that has helped users for over 20 years. He's an expert at creating Microsoft Office and Access database solutions and teaches online Access courses.

Sample Chapters

access 2019 for dummies

CHEAT SHEET

HAVE THIS BOOK?

Articles from
the book

Technical experts — the people who know Microsoft Access 2019 inside and out — might be a little intimidating, but they’re important — and they (we?) in no way intend to intimidate. They’re important to average Access users because they provide invaluable advice, and they’re important to Access itself because they drive the way Microsoft continuously improves its products.
A field in Access 2019, you remember, is where your data lives. Each field holds one piece of data, such as Last Name or Batting Average. Because there are so many different kinds of information in the world, Access offers a variety of field types for storing it. In fact, Access puts the following field types at your disposal: Short Text Long Text Number Currency AutoNumber (this data type is applied, by default, to the starting ID field in any new table) Date/Time Yes/No Lookup & Relationship Rich Text Attachment Hyperlink OLE Object Calculated Lookup Wizard The types just listed are those available for fields you create in addition to that first field — the ones that will contain your data.
The following keyboard shortcuts are especially useful in Access 2019. Some keystrokes work anywhere in Access 2019, whereas others work only in specific views, as noted below. Keystroke Function F1 Opens the Help window Alt+F Opens the File tab Ctrl+N Creates a new blank database Ctrl+O Opens an existing dat
When you look at all the applications in Microsoft Office 2019 — Word, Excel, PowerPoint, Outlook, and of course, Access — you’ll see some features that are consistent throughout the suite. Access has several features in common with the rest of the applications in the Microsoft Office suite. You’ll find the same buttons on several of the tabs, and the Quick Access Toolbar appears in all the applications.
If you’re upgrading to Access (or Office) 2019 from the 2013 or 2016 interface, you’ll find it looks very familiar — and you’ll find much of it to be the same as what you’re accustomed to.Let’s start with the File tab, where a vertical list of commands creates context-sensitive changes to the main workspace — essentially everything to the right of that left-hand menu panel.
Here are ten of the most common Microsoft Access problems and their solutions. Don’t give up hope if your problem is not on this list. Chances are, if you’re having the problem, someone else has already had it and figured out the solution. That’s why the Internet is a valuable resource. That’s just not normal—normalizing empty Access tables One of the hardest things to do (yet most important when building a database) is building the table structures properly.
ScreenTips in Access 2019 are the little names and brief descriptions of onscreen tools that appear when you put your mouse pointer over buttons, commands, menus, and many of the other pieces of the Access workspace.Not all onscreen features have ScreenTips, but for anything you can click to make something happen — as when a dialog box opens, Access performs some task for you, or something is created — these typically have associated ScreenTips that you can choose to view or not view.
When you open a Microsoft Access database — be it an existing one or one you’re just starting from a blank database or a template — the workspace changes, offering the Ribbon and its tabs shown here (Home, Create, External Data, and Database Tools). These tabs are not to be confused with the context-sensitive tabs that appear when various database objects (the tables, forms, queries, or reports that make up your database) are created or edited.
If you like keyboard shortcuts when you're working with software, Access 2019 has a Key Tips feature that can help make entering data move more quickly. The following section describes how to use it: 1. Press the Alt key. When you want to switch tabs and issue commands with the keyboard in Access 2019 (rather than with the mouse), press the Alt key.
Access 2019, the latest version of the Microsoft Office database application, has always been a powerful program, and this version is no different. All that power makes Access an application that’s not so easy to learn on your own. You don’t have to use every feature and tool and push the edges of the Access envelope.
https://cdn.prod.website-files.com/6630d85d73068bc09c7c436c/69195ee32d5c606051d9f433_4.%20All%20For%20You.mp3

Frequently Asked Questions

No items found.