Willkommen, schön sind Sie da!
Logo Ex Libris

Access 2019 For Dummies

  • E-Book (pdf)
  • 432 Seiten
(0) Erste Bewertung abgeben
Bewertungen
(0)
(0)
(0)
(0)
(0)
Alle Bewertungen ansehen
Easy steps to practical databases People who really know how to build, populate, and simplify databases are few and far between. A... Weiterlesen
E-Books ganz einfach mit der kostenlosen Ex Libris-Reader-App lesen. Hier erhalten Sie Ihren Download-Link.
CHF 28.00
Download steht sofort bereit
Informationen zu E-Books
E-Books eignen sich auch für mobile Geräte (sehen Sie dazu die Anleitungen).
E-Books von Ex Libris sind mit Adobe DRM kopiergeschützt: Erfahren Sie mehr.
Weitere Informationen finden Sie hier.
Bestellung & Lieferung in eine Filiale möglich

Beschreibung

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.



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

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

Produktinformationen

Titel: Access 2019 For Dummies
Autor:
EAN: 9781119513254
Digitaler Kopierschutz: Adobe-DRM
Format: E-Book (pdf)
Hersteller: For Dummies
Genre: Anwendungs-Software
Anzahl Seiten: 432
Veröffentlichung: 08.10.2018
Dateigrösse: 19.6 MB