Access 2016 Bible: the Comprehensive Tutorial Guide

Rs. 3,355
  • Authors: Michael Alexander, Dick Kusleika
  • ISBN: 9788126559114
  • Publisher: Wiley Publishing
  • Publication Date: January 14, 2016
  • Format: Paperback – 1152 pages
  • Language: English

SKU 9788126559114 Category Tag

Share
Description

Master database creation and management

Access 2016 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 2016 has to offer. Whether you’re new to Access or getting started with Access 2016, 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 2016 and build the database you need.

Table of Contents
  1. Introduction xxxix
  2. Part I: Access Building Blocks 1
  3. Chapter 1: An Introduction to Database Development 3
    1. The Database Terminology of Access 3
    2. Relational Databases 6
    3. Access Database Objects 7
    4. A Five-Step Design Method 10
  4. Chapter 2: Getting Started with Access 19
    1. The Access Welcome Screen 19
    2. How to Create a Blank Desktop Database 21
    3. The Access 2016 Interface 23
    4. The Ribbon 26
    5. The Quick Access toolbar 28
  5. Part II: Understanding Access Tables 31
  6. Chapter 3: Creating Access Tables 33
    1. Table Types 33
    2. Creating a New Table 34
    3. Creating tblCustomers 51
    4. Changing a Table Design 52
    5. Understanding tblCustomers Field Properties 70
    6. Setting the Primary Key 73
    7. Indexing Access Tables 75
    8. Printing a Table Design 81
    9. Saving the Completed Table 83
    10. Manipulating Tables 83
    11. Adding Records to a Database Table 85
    12. Understanding Attachment Fields 86
  7. Chapter 4: Understanding Table Relationships 89
    1. Building Bulletproof Databases 90
    2. Data Normalization and Denormalization 92
    3. Table Relationships 104
    4. Integrity Rules 113
    5. Keys 116
  8. Chapter 5: Working with Access Tables 131
    1. Understanding Datasheets 132
    2. Looking at the Datasheet Window 134
    3. Opening a Datasheet 138
    4. Entering New Data 138
    5. Navigating Records in a Datasheet 145
    6. Changing Values in a Datasheet 148
    7. Using the Undo Feature 150
    8. Copying and Pasting Values 151
    9. Replacing Values 152
    10. Adding New Records 153
    11. Deleting Records 153
    12. Displaying Records 154
    13. Sorting and Filtering Records in a Datasheet 163
    14. Aggregating Data 168
    15. Printing Records 169
    16. Previewing Records 170
  9. Chapter 6: Importing and Exporting Data 171
    1. How Access Works with External Data 171
    2. Options for Importing and Exporting 175
    3. Importing External Data 177
    4. Exporting to External Formats 200
  10. Chapter 7: Linking to External Data 209
    1. Linking External Data 210
    2. Working with Linked Tables 224
    3. Splitting a Database 228
  11. Part III: Working with Access Queries 235
  12. Chapter 8: Selecting Data with Queries 237
    1. Introducing Queries 238
    2. Creating a Query 240
    3. Working with Query Fields 246
    4. Adding Criteria to Your Queries 250
    5. Printing a Query’s Recordset 254
    6. Saving a Query 254
    7. Creating Multi-Table Queries 254
    8. Working with the Table Pane 259
    9. Creating and Working with Query Joins 261
  13. Chapter 9: Using Operators and Expressions in Access 267
    1. Introducing Operators 267
    2. Using Operators and Expressions in Queries 282
    3. Entering Single-Value Field Criteria 288
    4. Using Multiple Criteria in a Query 296
    5. Entering Criteria in Multiple Fields 302
  14. Chapter 10: Going Beyond Select Queries 309
    1. Aggregate Queries 309
    2. Action Queries 318
    3. Crosstab Queries 333
    4. Optimizing Query Performance 345
  15. Part IV: Analyzing Data in Access 349
  16. Chapter 11: Transforming Data in Access 351
    1. Finding and Removing Duplicate Records 351
    2. Common Transformation Tasks 359
  17. Chapter 12: Working with Calculations and Dates 375
    1. Using Calculations in Your Analyses 375
    2. Using Dates in Your Analyses 388
  18. Chapter 13: Performing Conditional Analyses 401
    1. Using Parameter Queries 401
    2. Using Conditional Functions 410
  19. Chapter 14: The Fundamentals of Using SQL 421
    1. Understanding Basic SQL 421
    2. Getting Fancy with Advanced SQL Statements 426
    3. Using SQL-Specific Queries 433
  20. Chapter 15: Subqueries and Domain Aggregate Functions 441
    1. Enhancing Your Analyses with Subqueries 442
    2. Domain Aggregate Functions 455
  21. Chapter 16: Running Descriptive Statistics in Access 467
    1. Basic Descriptive Statistics 468
    2. Advanced Descriptive Statistics 476
  22. Part V: Working with Access Forms and Reports 483
  23. Chapter 17: Creating Basic Access Forms 485
    1. Formulating Forms 486
    2. Working with Controls 498
    3. Introducing Properties 517
  24. Chapter 18: Working with Data on Access Forms 525
    1. Using Form View 526
    2. Changing Values in a Form 531
    3. Printing a Form 538
    4. Working with Form Properties 539
    5. Adding a Form Header or Footer 550
    6. Working with Section Properties 550
    7. Changing the Layout 552
    8. Converting a Form to a Report 556
  25. Chapter 19: Working with Form Controls 557
    1. Setting Control Properties 558
    2. Creating a Calculated Control 565
    3. Working with Subforms 565
    4. Form Design Tips 567
    5. Tackling Advanced Forms Techniques 570
    6. Using the Tab Control 577
    7. Using Dialog Boxes to Collect Information579
    8. Designing a Form from Scratch 582
  26. Chapter 20: Presenting Data with Access Reports 591
    1. Introducing Reports 592
    2. Creating a Report, from Beginning to End 596
    3. Banded Report Design Concepts 614
    4. Creating a Report from Scratch 620
    5. Improving the Report’s Appearance 642
  27. Chapter 21: Advanced Access Report Techniques 649
    1. Grouping and Sorting Data 650
    2. Formatting Data 662
    3. Adding Data 680
    4. Adding Even More Flexibility 682
  28. Part VI: Access Programming Fundamentals 695
  29. Chapter 22: Using Access Macros 697
    1. An Introduction to Macros 698
    2. Understanding Macro Security 702
    3. Multi-Action Macros 706
    4. Submacros 709
    5. Conditions 713
    6. Temporary Variables 716
    7. Error Handling and Macro Debugging 721
    8. Embedded Macros 727
    9. Macros versus VBA Statements 729
  30. Chapter 23: Using Access Data Macros 733
    1. Introducing Data Macros 734
    2. Understanding Table Events 735
    3. Using the Macro Designer for Data Macros 738
    4. Understanding the Action Catalog 740
    5. Creating Your First Data Macro 743
    6. Managing Macro Objects 747
    7. Recognizing the Limitations of Data Macros 749
  31. Chapter 24: Getting Started with Access VBA 751
    1. Introducing Visual Basic for Applications 752
    2. Understanding VBA Terminology 754
    3. Starting with VBA Code Basics 755
    4. Creating VBA Programs 755
    5. Understanding VBA Branching Constructs 770
    6. Working with Objects and Collections 780
    7. Exploring the Visual Basic Editor 785
  32. Chapter 25: Mastering VBA Data Types and Procedures 795
    1. Using Variables 796
    2. Working with Data Types 803
    3. Understanding Subs and Functions824
    4. Creating Functions 830
    5. Simplifying Code with Named Arguments 836
  33. Chapter 26: Understanding the Access Event Model 839
    1. Programming Events 840
    2. Identifying Common Events 843
    3. Paying Attention to Event Sequence 852
  34. Chapter 27: Debugging Your Access Applications 861
    1. Organizing VBA Code 862
    2. Testing Your Applications 863
    3. Traditional Debugging Techniques 870
    4. Using the Access Debugging Tools 876
    5. Trapping Errors in Your Code 889
  35. Part VII: Advanced Access Programming Techniques 895
  36. Chapter 28: Accessing Data with VBA Code 897
    1. Working with Data 897
    2. Understanding ADO Objects 901
    3. Understanding DAO Objects 914
    4. Writing VBA Code to Update a Table 924
  37. Chapter 29: Advanced Data Access with VBA 941
    1. Adding an Unbound Combo Box to a Form to Find Data 941
    2. Filtering a Form 949
  38. Chapter 30: Customizing the Ribbon 959
    1. The Ribbon Hierarchy 959
    2. Editing the Default Ribbon 965
    3. Working with the Quick Access Toolbar 968
    4. Developing Custom Ribbons 971
    5. Creating a Custom Ribbon 974
    6. The Basic Ribbon XML 983
    7. Adding Ribbon Controls 985
    8. Attaching Ribbons to Forms and Reports 994
    9. Removing the Ribbon Completely 996
  39. Chapter 31: Preparing Your Access Application for Distribution 999
    1. Defining the Current Database Options 1000
    2. Developing the Application 1009
    3. Polishing Your Application 1015
    4. Bulletproofing an Application 1029
    5. Securing the Environment 1040
  40. Part VIII: Access and Windows SharePoint Services 1045
  41. Chapter 32: Integrating Access with SharePoint 1047
    1. Introducing SharePoint 1047
    2. Understanding SharePoint Sites 1048
    3. Sharing Data between Access and SharePoint 1051
    4. Using SharePoint Templates 1060
  42. Chapter 33: Deploying Access Applications to SharePoint 1063
    1. Understanding Web Publishing with Access 1064
    2. Examining the Limitations of Access Web Applications 1067
    3. Publishing a Custom Access Application to SharePoint 1070
    4. Index 1091
Authors Biography

Michael Alexander is a Microsoft Certified Application Developer. For more than 15 years, he has been consulting and developing Microsoft Office solutions.

Dick Kusleika has been named a Microsoft MVP for 12 consecutive years. He develops Access- and Excel-based solutions for clients, and has worked with Microsoft Office for more than 20 years.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.