Details

Subject(s)

• Database management—Automation [Browse]
• Microsoft Access [Browse]

Author

• Kusleika, Richard [Browse]

Series

Bible [More in this series]

Summary note

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 — this book gives you an expert Access 2016 companion on call 24/7. 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.

Notes

"The comprehensive tutorial resource, design your own relational databases, build powerful analytics and reporting, program and publish your own applications"--Cover.

Source of description

Description based on print version record.

Contents

• Cover
• Title Page
• Copyright
• Contents
• Introduction
• 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
• 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 Desktop Database
• The Access 2016 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 &
• 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 your records with QuickSort
• 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 internal 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 QBE grid
• Changing field order
• Resizing columns in the QBE 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
• 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 QBE 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
• Using the query design grid to create your crosstab query
• Customizing your crosstab queries
• Optimizing Query Performance.
• Normalizing your database design.

Show 318 more Contents items

ISBN

• 9781119086697
• 1119086698
• 9781119086598
• 1119086590

OCLC

• 952493391
• 935677539

Statement on responsible collection description

Princeton University Library aims to describe library materials in a manner that is respectful to the individuals and communities who create, use, and are represented in the collections we manage. Read more...