Access 2019 Bible - Michael Alexander

. .

Auteur(s) : Michael Alexander - Richard Kusleika

Editeur : Wiley

Langue : Anglais

Parution : 01/10/2018

Format : Moyen, de 350g à 1kg

Nombre de pages : 1136

Expédition : 1843

Dimensions : 23.6 x 18.7 x 6.3

ISBN : 9781119514756

Résumé :
Master database creation and management

Access 2019 Bible?is your, comprehensive reference to the world's most popular database management tool. With clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of everything Access 2019 has to offer. Whether you're new to Access or getting started with Access 2019, you'll find everything you need to know to create the database solution perfectly tailored to your needs, with expert guidance every step of the way. The companion website features all examples and databases used in the book, plus trial software and a special offer from Database Creations. Start from the beginning for a complete tutorial, or dip in and grab what you need when you need it.

Access enables database novices and programmers to store, organize, view, analyze, and share data, as well as build powerful, integrable, custom database solutions - but databases can be complex, and difficult to navigate. This book helps you harness the power of the database with a solid understanding of their purpose, construction, and application.

• Understand database objects and design systems objects
• Build forms, create tables, manipulate datasheets, and add data validation
• Use Visual Basic automation and XML Data Access Page design
• Exchange data with other Office applications, including Word, Excel, and more

From database fundamentals and terminology to XML and Web services, this book has everything you need to maximize Access 2019 and build the database you need.

...

Biographie:

Introduction xxxix

Part I: Access Building Blocks 1

Chapter 1: An Introduction to Database Development 3

The Database Terminology of Access 3

Relational Databases 6

Access Database Objects 7

A Five-Step Design Method 9

Chapter 2: Getting Started with Access 17

The Access Welcome Screen 17

How to Create a Blank Database 18

The Access 2019 Interface 20

The Ribbon 24

The Quick Access toolbar 25

Part II: Understanding Access Tables 29

Chapter 3: Creating Access Tables 31

Table Types 31

Creating a New Table 32

Creating tblCustomers 49

Changing a Table Design 50

Understanding tblCustomers Field Properties 68

Setting the Primary Key 71

Indexing Access Tables 73

Printing a Table Design 79

Saving the Completed Table 81

Manipulating Tables 81

Adding Records to a Database Table 84

Understanding Attachment Fields 84

Chapter 4: Understanding Table Relationships 87

Building Bulletproof Databases 88

Data Normalization and Denormalization 90

Table Relationships 102

Integrity Rules 110

Keys 113

Creating relationships and enforcing referential integrity 119

Viewing all relationships 125

Deleting relationships 126

Following application-speci?c integrity rules 126

Chapter 5: Working with Access Tables 129

Understanding Datasheets 130

Looking at the Datasheet Window 131

Opening a Datasheet 135

Entering New Data 135

Navigating Records in a Datasheet 142

Changing Values in a Datasheet 146

Using the Undo Feature 148

Copying and Pasting Values 148

Replacing Values 149

Adding New Records 150

Deleting Records 150

Displaying Records 152

Sorting and Filtering Records in a Datasheet 160

Aggregating Data 165

Printing Records 166

Previewing Records 167

Chapter 6: Importing and Exporting Data 169

How Access Works with External Data 169

Options for Importing and Exporting 173

Exporting to External Formats 202

Chapter 7: Linking to External Data 209

Linking External Data 210

Working with Linked Tables 225

Splitting a Database 229

Part III: Working with Access Queries 237

Chapter 8: Selecting Data with Queries 239

Introducing Queries 240

Creating a Query 241

Working with Query Fields 247

Adding Criteria to Your Queries 252

Printing a Query's Recordset 255

Saving a Query 256

Creating Multi-table Queries 256

Working with the Table Pane 261

Creating and Working with Query Joins 262

Chapter 9: Using Operators and Expressions in Access 269

Introducing Operators 269

Using Operators and Expressions in Queries 283

Entering Single-Value Field Criteria 289

Using Multiple Criteria in a Query 297

Entering Criteria in Multiple Fields 304

Chapter 10: Going Beyond Select Queries 311

Aggregate Queries 311

Action Queries 320

Crosstab Queries 336

Optimizing Query Performance 348

Part IV: Analyzing Data in Microsoft Access 353

Chapter 11: Transforming Data in Access 355

Finding and Removing Duplicate Records 355

Common Transformation Tasks 363

Chapter 12: Working with Calculations and Dates 379

Using Calculations in Your Analyses 379

Using Dates in Your Analyses 392

Chapter 13: Performing Conditional Analyses 405

Using Parameter Quer...

Sommaire:

Michael Alexander is a Microsoft Certified Application Developer (MCAD) and a Microsoft MVP with over 15 years of experience developing reporting solutions for a variety of industries. He is also the principal contributor at datapigtechnologies.com, where he shares video tutorials with the Microsoft Access and Excel communities. Mike has authored several books on advanced business analysis. Dick Kusleika is a 12-time Microsoft Excel MVP, and the principal contributor at the Daily Dose of Excel blog....