Access 2019 Bible. (Record no. 5301)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 11050nam a22004933i 4500 |
| 001 - CONTROL NUMBER | |
| control field | EBC5521166 |
| 003 - CONTROL NUMBER IDENTIFIER | |
| control field | MiAaPQ |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20240724113353.0 |
| 006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS | |
| fixed length control field | m o d | |
| 007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION | |
| fixed length control field | cr cnu|||||||| |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 240724s2018 xx o ||||0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9781119514732 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| Canceled/invalid ISBN | 9781119514756 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (MiAaPQ)EBC5521166 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (Au-PeEL)EBL5521166 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (OCoLC)1054245751 |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | MiAaPQ |
| Language of cataloging | eng |
| Description conventions | rda |
| -- | pn |
| Transcribing agency | MiAaPQ |
| Modifying agency | MiAaPQ |
| 082 0# - DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Classification number | 005.7565 |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Alexander, Michael. |
| 245 10 - TITLE STATEMENT | |
| Title | Access 2019 Bible. |
| 250 ## - EDITION STATEMENT | |
| Edition statement | 1st ed. |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Place of production, publication, distribution, manufacture | Newark : |
| Name of producer, publisher, distributor, manufacturer | John Wiley & Sons, Incorporated, |
| Date of production, publication, distribution, manufacture, or copyright notice | 2018. |
| 264 #4 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Date of production, publication, distribution, manufacture, or copyright notice | ©2019. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 1 online resource (1136 pages) |
| 336 ## - CONTENT TYPE | |
| Content type term | text |
| Content type code | txt |
| Source | rdacontent |
| 337 ## - MEDIA TYPE | |
| Media type term | computer |
| Media type code | c |
| Source | rdamedia |
| 338 ## - CARRIER TYPE | |
| Carrier type term | online resource |
| Carrier type code | cr |
| Source | rdacarrier |
| 490 1# - SERIES STATEMENT | |
| Series statement | Bible Series |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 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. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 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 & -- Filter -- Records -- Find -- Window -- Text Formatting. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 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. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 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. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 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. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Creating a crosstab query manually. |
| 588 ## - SOURCE OF DESCRIPTION NOTE | |
| Source of description note | Description based on publisher supplied metadata and other sources. |
| 590 ## - LOCAL NOTE (RLIN) | |
| Local note | Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Microsoft Access-Handbooks, manuals, etc. |
| 655 #4 - INDEX TERM--GENRE/FORM | |
| Genre/form data or focus term | Electronic books. |
| 700 1# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Kusleika, Richard. |
| 776 08 - ADDITIONAL PHYSICAL FORM ENTRY | |
| Relationship information | Print version: |
| Main entry heading | Alexander, Michael |
| Title | Access 2019 Bible |
| Place, publisher, and date of publication | Newark : John Wiley & Sons, Incorporated,c2018 |
| International Standard Book Number | 9781119514756 |
| 797 2# - LOCAL ADDED ENTRY--CORPORATE NAME (RLIN) | |
| Corporate name or jurisdiction name as entry element | ProQuest (Firm) |
| 830 #0 - SERIES ADDED ENTRY--UNIFORM TITLE | |
| Uniform title | Bible Series |
| 856 40 - ELECTRONIC LOCATION AND ACCESS | |
| Uniform Resource Identifier | <a href="https://ebookcentral.proquest.com/lib/orpp/detail.action?docID=5521166">https://ebookcentral.proquest.com/lib/orpp/detail.action?docID=5521166</a> |
| Public note | Click to View |
No items available.