CHF23.90
Download est disponible immédiatement
Become a database boss --and have fun doing it--with this accessible and easy-to-follow guide to Microsoft Access
Databases hold the key to organizing and accessing all your data in one convenient place. And you don't have to be a data science wizard to build, populate, and organize your own. With Microsoft Access For Dummies, you'll learn to use the latest version of Microsoft's Access software to power your database needs.
Need to understand the essentials before diving in? Check out our Basic Training in Part 1 where we teach you how to navigate the Access workspace and explore the foundations of databases.
Ready for more advanced tutorials? Skip right to the sections on Data Management, Queries, or Reporting where we walk you through Access's more sophisticated capabilities. Not sure if you have Access via Office 2021 or Office 365? No worries - this book covers Access now matter how you access it.
The book also shows you how to:
Handle the most common problems that Access users encounter
Import, export, and automatically edit data to populate your next database
Write powerful and accurate queries to find exactly what you're looking for, exactly when you need it
Microsoft Access For Dummies is the perfect resource for anyone expected to understand, use, or administer Access databases at the workplace, classroom, or any other data-driven destination.
Auteur
Laurie Ann Ulrich is a professional author and trainer on all things technology. Along with recent editions of Access For Dummies, she's also written books on Excel, Photoshop, and Dreamweaver.
Ken Cook is a professional database developer and author who has written on Access and Excel.
Texte du rabat
Become a data-boss with this one-stop guide
Databases are powerful tools. And they're not just for data science wizards! In this book, you'll learn how to design, create, and organize useful and intuitive Access databases perfect for your office, classroom, or anywhere you need to wrangle data. From navigating the Access interface to creating professional-looking reports, this book walks you through the steps you need to take to unlock the potential of your organization's data. There's nothing standing between you and the insights your data holds! Inside
Résumé
Become a database boss and have fun doing itwith this accessible and easy-to-follow guide to Microsoft Access
Databases hold the key to organizing and accessing all your data in one convenient place. And you don't have to be a data science wizard to build, populate, and organize your own. With Microsoft Access For Dummies, you'll learn to use the latest version of Microsoft's Access software to power your database needs.
Need to understand the essentials before diving in? Check out our Basic Training in Part 1 where we teach you how to navigate the Access workspace and explore the foundations of databases.
Ready for more advanced tutorials? Skip right to the sections on Data Management, Queries, or Reporting where we walk you through Access's more sophisticated capabilities. Not sure if you have Access via Office 2021 or Office 365? No worries this book covers Access now matter how you access it.
The book also shows you how to:
Contenu
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 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 14
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? 24
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 32
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 38
Working with ScreenTips 38
Mousing Around 41
Navigating Access with the Alt Key 42
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 46
Field Types and Uses 46
Choosing Between Flat and Relational Databases 52
Isolationist tables 52
Tables that mix and mingle 52
Building a Database 54
Adding and Removing Tables 58
One more, please 58
Oops, I didn't mean to do that 59
Part 2: Getting It All on the Table 63
Chapter 4: Sounds Like a Plan 65
Planning Your Database Tables 65
Reviewing fields 66
Determining data types 66
The new normal 68
Understanding normal forms 68
Normalizing your tables 69
Building Tables in Design View 73
Creating fields 73
Setting data types 75
Chapter 5: Table Tune-Ups 77
The Primary Key to Success 78
The lowdown on primary keys 78
Creating a primary key 79
Making Tables Get Along 81
Rules of relationships 81
Relationship types 82
Building Table Relationships 84
The Relationships window 84
Table relationships 85
Indexing for Faster Queries 89
Creating your own index 90
Adding and removing indexes 92
Chapter 6: Remodeling Your Data 95
Opening a Table for Editing 96
Inserting Records and Fields 98
Adding a record 99
Inserting a field 100
Deleting a field 103
Modifying Field Content 104
Name-Calling 105
Renaming fields 105
Renaming a table 108
Turn Uh-Oh! into Yee-Hah! 109
Chapter 7: Types, Masks, and Triggers 111
Access Table Settings 112
Field Data Formats 114
Text fields 115
Number and currency fields 118
Date/time fields 121
Yes/No fields 122
Gaining Control of Data Entry 123
You really need to put a mask on those fields 123
To require or not to require 130
Making your data toe the line with validation 132
Give Your Fingers a Mini Vacation by Default 133
Part 3: Data Management Mania 135 Chapter 8: A Form for All Reasons **137</b>...