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.
Autorentext
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.
Klappentext
- Get a grasp on database design and functions
- Create forms that simplify your data entry routine
- Build reports that answer your data questions
Discover the easy way to access your data
Access is one of the most powerful and least understood elements of the Office suite. With this handy book as your guide, you'll be able to learn its secrets and demystify the world of databases! Look inside and learn how to build, populate, search, and simplify databases. Also discover how to create queries that answer data questions, develop data entry forms, and share your data in targeted reports.
Inside
- Database basics
- Setting data tables
- Defining data types
- Simplifying input with forms
- Grabbing data from elsewhere
- Finding the data you need
- Writing the right queries
- Generating reports
Zusammenfassung
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.
Inhalt
Introduction 1
About This Book 1
Foolish Assumptions 2
Icons Used in This Book 2
Where to Go from Here 3
Part 1: Basic Training 5
Chapter 1: Access 2019 Basic Training 7
What Is Access Good For, Anyway? 8
Building big databases 8
Creating databases with multiple tables 9
Databases with user forms 12
Databases that require special reporting 13
What's New in Access 2019? 16
Reach Out with SharePoint 17
How Access Works and How You Work with it 18
Opening Access 18
Selecting a starting point 19
Now What? 23
Chapter 2: Navigating the Access Workspace 25
Diving Right In 27
Working with Onscreen Tools in Access 29
Clicking tabs 30
Using buttons 31
The File tab and Quick Access tools 31
Accessing panes, panels, and context-sensitive tools 33
Customizing the Access Workspace 34
Repositioning the Quick Access Toolbar 34
Adding buttons to the Quick Access Toolbar 35
Removing buttons from the Quick Access Toolbar 37
Minimizing the Ribbon 37
Working with ScreenTips 38
Mousing Around 41
Navigating Access with the Alt Key 41
Chapter 3: Database Basics 43
Database Lingo 43
Data, no matter how you pronounce it 44
Fields of dreams (or data) 44
Records 45
Tables 45
The database 45
Field Types and Uses 46
Choosing Between Flat and Relational Databases 51
Isolationist tables 51
Tables that mix and mingle 52
Building a Database 53
Adding and Removing Tables 57
One more, please 57
Oops, I didn't mean to do that 59
Part 2: Getting it All on the Table 61
Chapter 4: Sounds Like a Plan 63
Planning Your Database Tables 63
Reviewing fields 64
Determining data types 64
The new normal 66
Understanding normal forms 66
Normalizing your tables 67
Building Tables in Design View 70
Creating fields 70
Setting data types 72
Chapter 5: Table Tune Ups 75
The Primary Key to Success 76
The lowdown on primary keys 76
Creating a primary key 77
Making Tables Get Along 79
Rules of relationships 79
Relationship types 80
Building Table Relationships 82
The Relationships window 82
Table relationships 83
Indexing for Faster Queries 87
Creating your own index 88
Adding and removing indexes 91
Chapter 6: Remodeling Your Data 93
Opening a Table for Editing 94
Inserting Records and Fields 97
Adding a record 97
Inserting a field 98
Deleting a field 101
Modifying Field Content 102
Name-Calling 103
Renaming fields 104
Renaming a table 106
Turn Uh-Oh! into Yee-Hah! 108
Chapter 7: Types, Masks, and Triggers 109
Access Table Settings 110
Field Data Formats 112
Text fields 113
Number and currency fields 115
Date/time fields 118
Yes/No fields 119
Gaining Control of Data Entry 121
You really need to put a mask on those fields 121
To require or not to require 128
Making your data toe the line with validation 129
Give Your Fingers a Mini Vacation by Default 131
Part 3: Data Management Mania