Access 2019 Bible.

Cover -- Title Page -- Copyright -- About the Authors -- About the Technical Editor -- Credits -- Acknowledgments -- Contents -- Introduction -- Is This Book for You? -- Conventions Used in This Book -- How This Book Is Organized -- How to Use This Book -- What's on the Website -- Part I: Access Building Blocks -- Chapter 1: An Introduction to Database Development -- The Database Terminology of Access -- Databases -- Tables -- Records and fields -- Values -- Relational Databases -- Access Database Objects -- Tables -- Queries -- Data-entry and display forms -- Reports -- Macros and VBA -- Planning for database objects -- A Five-Step Design Method -- Step 1: The overall design-from concept to reality -- Step 2: Report design -- Step 3: Data design -- Step 4: Table design -- Step 5: Form design -- Chapter 2: Getting Started with Access -- The Access Welcome Screen -- How to Create a Blank Database -- The Access 2019 Interface -- The Navigation pane -- Custom -- Object Type -- Tables and Related Views -- Created Date -- Modified Date -- The Ribbon -- The Quick Access toolbar -- Part II: Understanding Access Tables -- Chapter 3: Creating Access Tables -- Table Types -- Object tables -- Transaction tables -- Join tables -- Creating a New Table -- Designing tables -- Using the Design tab -- Primary Key -- Insert Rows -- Delete Rows -- Property Sheet -- Indexes -- Working with fields -- Naming a field -- Specifying a data type -- Entering a field description -- Specifying data validation rules -- Creating tblCustomers -- Using AutoNumber fields -- Completing tblCustomers -- Changing a Table Design -- Inserting a new field -- Deleting a field -- Changing a field location -- Changing a field name -- Changing a field size -- Handling data conversion issues -- Assigning field properties -- Common properties -- Format -- Input Mask -- Caption.

Validation Rule and Validation Text -- Required -- AllowZeroLength -- Indexed -- Understanding tblCustomers Field Properties -- Setting the Primary Key -- Choosing a primary key -- Creating the primary key -- Creating composite primary keys -- Indexing Access Tables -- The importance of indexes -- Multiple-field indexes -- When to index tables -- Printing a Table Design -- Saving the Completed Table -- Manipulating Tables -- Renaming tables -- Deleting tables -- Copying tables in a database -- Copying a table to another database -- Adding Records to a Database Table -- Understanding Attachment Fields -- Chapter 4: Understanding Table Relationships -- Building Bulletproof Databases -- Data Normalization and Denormalization -- First normal form -- Second normal form -- Identifying entities -- Less obvious entities -- Breaking the rules -- Third normal form -- Denormalization -- Table Relationships -- Connecting the data -- One-to-one -- One-to-many -- Many-to-many -- Integrity Rules -- No primary key can contain a null value -- All foreign key values must be matched by corresponding primary keys -- Keys -- Deciding on a primary key -- Looking at the benefits of a primary key -- Designating a primary key -- Single-field versus composite primary keys -- Natural versus surrogate primary keys -- Creating primary keys -- Creating relationships and enforcing referential integrity -- Specifying the join type between tables -- Enforcing referential integrity -- Viewing all relationships -- Deleting relationships -- Following application-specific integrity rules -- Chapter 5: Working with Access Tables -- Understanding Datasheets -- Looking at the Datasheet Window -- Moving within a datasheet -- Using the Navigation buttons -- Examining the Datasheet Ribbon -- Views -- Clipboard -- Sort &amp -- Filter -- Records -- Find -- Window -- Text Formatting.

Opening a Datasheet -- Entering New Data -- Saving the record -- Understanding automatic data-type validation -- Knowing how properties affect data entry -- Standard text data entry -- Date/Time data entry -- Number/Currency data entry with data validation -- OLE object data entry -- Long Text field data entry -- Navigating Records in a Datasheet -- Moving between records -- Finding a specific value -- Changing Values in a Datasheet -- Manually replacing an existing value -- Changing an existing value -- Using the Undo Feature -- Copying and Pasting Values -- Replacing Values -- Adding New Records -- Deleting Records -- Displaying Records -- Changing the field order -- Changing the field display width -- Changing the record display height -- Changing display fonts -- Displaying cell gridlines and alternate row colors -- Aligning data in columns -- Hiding and unhiding columns -- Freezing columns -- Saving the changed layout -- Saving a record -- Sorting and Filtering Records in a Datasheet -- Sorting records -- Filtering a selection -- Filtering by form -- Aggregating Data -- Printing Records -- Previewing Records -- Chapter 6: Importing and Exporting Data -- How Access Works with External Data -- Types of external data -- Ways of working with external data -- When to link to external data -- When to import external data -- When to export data -- Options for Importing and Exporting -- Importing External Data -- Importing from another Access database -- Importing from an Excel spreadsheet -- Importing a SharePoint list -- Importing data from text files -- Delimited text files -- Fixed-width text files -- Importing and exporting XML documents -- Importing and exporting HTML documents -- Importing Access objects other than tables -- Importing an Outlook folder -- Exporting to External Formats -- Exporting objects to other Access databases.

Exporting through ODBC drivers -- Exporting to Word -- Merging data into Word -- Publishing to PDF or XPS -- Chapter 7: Linking to External Data -- Linking External Data -- Identifying linked tables -- Limitations of linked data -- Linking to other Access database tables -- Linking to ODBC data sources -- Linking to non-database data -- Linking to Excel -- Linking to HTML files -- Linking to text files -- Working with Linked Tables -- Setting view properties -- Setting relationships -- Optimizing linked tables -- Deleting a linked table reference -- Viewing or changing information for linked tables -- Refreshing linked tables -- Splitting a Database -- The benefits of splitting a database -- Knowing where to put which objects -- Using the Database Splitter add-in -- Part III: Working with Access Queries -- Chapter 8: Selecting Data with Queries -- Introducing Queries -- What queries can do -- What queries return -- Creating a Query -- Adding fields to your queries -- Adding a single field -- Adding multiple fields -- Running your query -- Working with Query Fields -- Selecting a field in the QBD grid -- Changing field order -- Resizing columns in the QBD grid -- Removing a field -- Inserting a field -- Hiding a field -- Changing the sort order of a field -- Adding Criteria to Your Queries -- Understanding selection criteria -- Entering simple string criteria -- Entering other simple criteria -- Printing a Query's Recordset -- Saving a Query -- Creating Multi-table Queries -- Viewing table names -- Adding multiple fields -- Recognizing the limitations of multi-table queries -- Overcoming query limitations -- Updating a unique index (primary key) -- Replacing existing data in a query with a one-to-many relationship -- Updating fields in queries -- Working with the Table Pane -- Looking at the join line -- Moving a table -- Removing a table.

Adding more tables -- Creating and Working with Query Joins -- Understanding joins -- Leveraging ad hoc table joins -- Specifying the type of join -- Deleting joins -- Chapter 9: Using Operators and Expressions in Access -- Introducing Operators -- Types of operators -- Mathematical operators -- Comparison operators -- String operators -- Boolean (logical) operators -- Miscellaneous operators -- Operator precedence -- The mathematical precedence -- The comparison precedence -- The Boolean precedence -- Using Operators and Expressions in Queries -- Using query comparison operators -- Understanding complex criteria -- Using functions in select queries -- Referencing fields in select queries -- Entering Single-Value Field Criteria -- Entering character (Text or Memo) criteria -- The Like operator and wildcards -- Specifying non-matching values -- Entering numeric criteria -- Entering true or false criteria -- Entering OLE object criteria -- Using Multiple Criteria in a Query -- Understanding an Or operation -- Specifying multiple values with the Or operator -- Using the Or cell of the QBD pane -- Using a list of values with the In operator -- Using And to specify a range -- Using the Between...And operator -- Searching for null data -- Entering Criteria in Multiple Fields -- Using And and Or across fields in a query -- Specifying Or criteria across fields of a query -- Using And and Or together in different fields -- A complex query on different lines -- Chapter 10: Going Beyond Select Queries -- Aggregate Queries -- Creating an aggregate query -- About aggregate functions -- Group By -- Sum, Avg, Count, StDev, Var -- Min, Max, First, Last -- Expression, Where -- Action Queries -- Make-table queries -- Delete queries -- Append queries -- Update queries -- Crosstab Queries -- Creating a crosstab query using the Crosstab Query Wizard.

Creating a crosstab query manually.

Description based on publisher supplied metadata and other sources.

Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.