Hugendubel.info - Die B2B Online-Buchhandlung 

Merkliste
Die Merkliste ist leer.
Bitte warten - die Druckansicht der Seite wird vorbereitet.
Der Druckdialog öffnet sich, sobald die Seite vollständig geladen wurde.
Sollte die Druckvorschau unvollständig sein, bitte schliessen und "Erneut drucken" wählen.

Access For Dummies

E-BookEPUB2 - DRM Adobe / EPUBE-Book
432 Seiten
Englisch
Polityerschienen am16.11.20211. Auflage
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. 



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.mehr
Verfügbare Formate
TaschenbuchKartoniert, Paperback
EUR32,00
TaschenbuchKartoniert, Paperback
EUR30,00
E-BookEPUB2 - DRM Adobe / EPUBE-Book
EUR20,99

Produkt

KlappentextBecome 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. 



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.
Details
Weitere ISBN/GTIN9781119829102
ProduktartE-Book
EinbandartE-Book
FormatEPUB
Format Hinweis2 - DRM Adobe / EPUB
FormatFormat mit automatischem Seitenumbruch (reflowable)
Verlag
Erscheinungsjahr2021
Erscheinungsdatum16.11.2021
Auflage1. Auflage
Seiten432 Seiten
SpracheEnglisch
Dateigrösse15607 Kbytes
Artikel-Nr.8543255
Rubriken
Genre9201

Inhalt/Kritik

Inhaltsverzeichnis
Introduction 1

Part 1: Basic Training 5

Chapter 1: Access Basic Training 7

Chapter 2: Navigating the Access Workspace 25

Chapter 3: Database Basics 43

Part 2: Getting It All on the Table 63

Chapter 4: Sounds Like a Plan 65

Chapter 5: Table Tune-Ups 77

Chapter 6: Remodeling Your Data 95

Chapter 7: Types, Masks, and Triggers 111

Part 3: Data Management Mania 135

Chapter 8: A Form for All Reasons 137

Chapter 9: Importing and Exporting Data 157

Chapter 10: Automatically Editing Data 171

Chapter 11: Access and the Web 183

Part 4: The Power of Questions 197

Chapter 12: Finding, Filtering, and Sorting Your Data -- Fast 199

Chapter 13: I Was Just Asking for Answers 215

Chapter 14: I Want These AND Those OR Them 241

Chapter 15: Number Crunching with the Total Row. 249

Chapter 16: Express Yourself with Formulas 263

Chapter 17: Take Charge with Action Queries 277

Part 5: Simple and Snazzy Reporting. 289

Chapter 18: Fast and Furious Automatic Reporting 291

Chapter 19: Professionally Designed Reports Made Easy 313

Chapter 20: Groups and Page Breaks, Headers and Footers 341

Chapter 21: Mailings to the Masses 363

Part 6: The Part of Tens 371

Chapter 22: Ten Common Problems 373

Chapter 23: Ten Uncommon Tips 385

Appendix A: Getting Help 393

Index 395mehr
Leseprobe


Chapter 1
Access Basic Training

IN THIS CHAPTER

Deciding when to use Access

Discovering what s new in Access

Unlocking the basics of working with Access

Figuring out how to get started

Access, the Microsoft Office database application, has always been a powerful program. Chances are, therefore, that you re reading this book because all that power makes Access an application that s not so easy to learn on your own. If you re hoping to unleash that power for your data, you ll need us. So, good decision to buy this book!

Now, all that power and the need for our book aside, with the very basic parts of Access, the basic functionality that you ll discover in this book, you ll be able to put Access through many of its most important paces, yet you ll be working with wizards and other onscreen tools that keep you at a comfortable arm s distance from the software s inner workings, the things that programmers and serious developers play with. There. Don t you feel better now?

You don t have to use every feature and tool and push the edges of the Access envelope. In fact, you can use very little of everything Access has to offer and still create quite a significant solution to your needs for storing and accessing data - all because Access can really do it all - enabling you to set up a database quickly, build records into that database, and then use that data in several useful ways. Later on, who knows? You may become an Access guru.

In this chapter, you ll discover what Access does best (and when you might want to use another tool instead), and you ll see how it does what it does, and hopefully you ll begin to understand and absorb some basic terminology.

Now, don t panic; nobody s expecting you to memorize tons of complex vocabulary or anything scary like that. The goal here (and in the next two chapters) with regard to terms is to introduce you to some basic words and general concepts intended to help you make better use of Access - as well as better understand later chapters in this book, if you choose to follow us all the way to its stunning, life-altering conclusion.
What Is Access Good For, Anyway?

What is Access good for? That s a good question. Well, the list of what you can do with it is a lot longer than the list of what you can t do with it - of course, especially if you leave things like wash your car and put away the dishes off the can t do list. When it comes to data organization, storage, and retrieval, Access is at the head of the class.
Building big databases

Okay, what do I mean by big database? Any database with a lot of records - and by a lot, I mean hundreds. At least. And certainly if you have thousands of records, you need a tool like Access to manage them. Although you can use Microsoft Excel to store lists of records, it limits how many you can store (no more than the number of rows in a single worksheet), and it wasn t designed to create a true database. Overall, Excel wasn t designed to create the kind of tools - things like forms and reports - that Access can build. So anything with a lot of records and complex data is best done in Access.

Below are some reasons why Access handles big databases so well.
Typically, a big database has big data-entry needs. Access offers not only forms but also features that can create a quick form through which someone can enter all those records. This can make data entry easier and faster and can reduce the margin of error significantly. (Check out Chapter 8 for more about building forms.)
When you have lots and lots of records, you also have lots of opportunities for errors to creep in. This includes duplicate records, records with misspellings, and records with missing information - and that s just for openers. So you need an application such as Access to ferret out those errors and fix them. (Chapter 10 lays out how you can use Access to find and replace errors and search for duplicate entries.)
Big databases mean big needs for accurate, insightful reporting. Access has powerful reporting tools you can use to create printed and onscreen reports - and those can include as few or as many pieces of your data as you need, drawn from more than one table if need be. You can tailor your reports to your audience, from what s shown on the reports pages to the colors and fonts used.
Big databases are hard to wade through when you want to find something. Access provides several tools for sorting, searching, and creating your own specialized tools (known as queries) for finding the elusive single record or group of records you need.
Access saves time by making it easy to import and recycle data. You may have used certain tools to import data from other sources - such as Excel worksheets (if you started in Excel and maxed out its usefulness as a data-storage device) and Word tables. Access saves you from reentering all your data and allows you to keep multiple data sources consistent.
Creating databases with multiple tables

Whether your database holds 100 records or 100,000 records (or more), if you need to keep separate tables and relate them for maximum use of the information, you need a relational database - and that s Access. How do you know whether your data needs to be in separate tables? Think about your data - is it very compartmentalized? Does it go off on tangents? Consider the following example and apply the concepts to your data and see if you need multiple tables for your database.
The Big Organization database
Imagine you work for a very large company, and the company has data pertaining to their customers and their orders, the products the company sells, its suppliers, and its employees. For a complex database like this one, you need multiple tables, as follows:
One table houses the customer data - names, addresses, phone numbers, and email addresses.
A second table contains the customers orders, including the name of the customer who placed the order, the salesperson who handled the sale, shipping information, and the date of the order.
A third table contains information on the products the company sells, including product numbers, supplier names, prices, and the number of items in stock.
A fourth table contains supplier data - about the companies from which the main organization obtains its inventory of products to resell to customers. The table contains the company names, their contact person, and the address, email, and phone-number information to reach them.
A fifth table contains employees data - from the date they were hired to their contact information to their job title - and also contains notes about them, sort of a summary of their resumes for reference.

Other tables exist, too - to keep a list of shipping companies and their contact information (for shipping customer orders), an expense table (for the expenses incurred in running the business), and other tables that are used with the main five tables. The need for and ways to use the main tables and these additional tables are covered later in this book, as you find out how to set up tools for data entry, look up records, and create reports that provide varying levels of detail on all the data you ve stored.

Because you don t have to fill in every field for each record - in any table in the database - if you don t have a phone number or don t know an email address, for example, it s okay to leave those fields blank until you ve obtained that information.
Fail to plan? Plan to fail
If you think carefully about your database, how you use your data, and what you need to know about your employees, customers, volunteers, donors, products, or projects - whatever you re storing information about - you can plan
How many tables you ll need
Which data will go into which table
How you ll use the tables together to get the reports you need

Of course, everyone forgets something, and plans change after a system has already been implemented. But don t worry - Access isn t so rigid that chaos will ensue if you begin building your tables and forget something (a field or two, an entire table). You can always add a field that you forgot (or that some bright spark just told you is needed) or add a new table after the fact. But planning ahead as thoroughly as possible is still essential and will be well worth the effort.

As part of thorough planning, sketch your planned database on paper, drawing a kind of flowchart with boxes for each table and lists of fields that you ll have in each one. Draw arrows to show how they might be related - it s sort of like drawing a simple family tree - and you re well on your way to a well-planned, useful database.

Here s a handy procedure to follow if you re new to the process of planning a database:
On paper or in a word-processing document, whichever is more comfortable, type the following: A tentative name...

mehr