Access 2016: Up To Speed
Access 2016: Up To Speed by R.M. Hyttinen
English | 7 Feb. 2017 | ASIN: B01MZIMI3U | 269 Pages | PDF (conv) | 19.81 MB
English | 7 Feb. 2017 | ASIN: B01MZIMI3U | 269 Pages | PDF (conv) | 19.81 MB
The Access 2016: Up To Speed guide helps you to get up and running quickly with the world's most popular database program. This handy step-by-step guide is written from scratch, starting with basic Access and database topics and moving on to more advanced features of application, designed to help you to become more productive more quickly. Though comprehensive, the information in this book is presented in a clear, consise manner with screenshots providing helpful visual guidance all along the way.
In no time at all you're be creating, storing and managing databases, creating forms, generating reports, updating data using queries, maintaining databases and much more.
Understanding Databases
Using Database Templates
The Access Environment
A Look at Tables, Forms, Queries and Reports
Creating a Blank Database
Setting Access Options
Creating a Table using Application Parts
Entering Data into a Table
Adding New Fields to a Table
Creating a Table from Scratch
Setting a Primary Key
Rearranging, Inserting and Deleting Fields
Changing Field Properties
Designing in Datasheet View
Setting Validation Rules
Formatting Fields
Indexing Fields
Requiring Data Entry
Creating an Input Mask
Creating a Lookup Field
Creating & Modifying a Value List
Creating Calculated Fields
Creating Multiple Primary Keys
Creating Multiple Field Values
Editing & Formatting Table Data
Importing Excel Data into an Existing Table
Importing a Text File into a New Table
Selecting, Sorting and Deleting Records
Finding and Replacing Data
Filtering Data by Selection & Form
Using Common Filters
Hiding/Unhiding Columns
Freezing & Rearranging Columns
Creating a Query in Design View
Adding Criteria to a Query
Sorting Data in a Query
Using the Query Wizard
Creating Multi-Table Queries
Using Calculations in Queries
Changing Query Properties
Creating a Totals Query
Creating a Parameter Query
Prompting for Dates
Creating a Find Duplicates Query
Creating a Find Unmatched Records Query
Using the Form Wizard
Adding a Field to a Form
Changing Control Properties
Using Layout View
Adding Controls to a Form
Moving and Sizing Controls
Creating a Calculated Control
Changing Control Properties
Changing Form Properties
Adding a Lookup Control
Adding a Subform using the Subform/Subreport Tool
Aligning Controls to Each Other
Creating an Option Group
Creating a Basic Report
Applying a Theme to a Report
Using the Report Wizard
Modifying Report Setup
Printing Reports
Using the Label Wizard
Working with Report Sections
Adding Controls to a Report
Changing a Control’s Data Source
Changing a Report’s Data Source
Sorting and Grouping Data
Applying Conditional Formatting
Edit Sorting and Grouping Levels in a Report
A Look at Database Relationships
Creating a One-to-One Relationship
Creating a One-to-Many Relationship
Creating a Many-to-Many Relationship
Enforcing Referential Integrity
Cascade Update Related Fields
Cascade Delete Related Records
Creating a Macro
Running a Macro Step-by-Step
Assigning a Macro to a Command Button
Creating & Using a Macro Group
Using Macro Conditions
The AutoExec Macro
Creating an AutoKeys Macro
About Action Queries
Creating a Make-Table Query
Creating an Append Query
Creating an Update Query
Creating a Delete Query
Creating a SQL Query
Importing Data from a Text File
Importing Data from Excel
Importing Data from another Access Database
Linking Data
Exporting Data to Other Formats
Exporting Data to a PDF File
Exporting Data to another Access Database
Exporting Data to Excel
Exporting Data to Microsoft Word
Exporting Data to a Microsoft Word Mail Merge
Creating & Modifying a Switchboard
Using Compact and Repair
Changing Database Properties
Documenting a Database
Analyzing a Database
Viewing Object Dependencies
Backing up a Database
Splitting a Database
Setting a Database Password
….and more
Using Database Templates
The Access Environment
A Look at Tables, Forms, Queries and Reports
Creating a Blank Database
Setting Access Options
Creating a Table using Application Parts
Entering Data into a Table
Adding New Fields to a Table
Creating a Table from Scratch
Setting a Primary Key
Rearranging, Inserting and Deleting Fields
Changing Field Properties
Designing in Datasheet View
Setting Validation Rules
Formatting Fields
Indexing Fields
Requiring Data Entry
Creating an Input Mask
Creating a Lookup Field
Creating & Modifying a Value List
Creating Calculated Fields
Creating Multiple Primary Keys
Creating Multiple Field Values
Editing & Formatting Table Data
Importing Excel Data into an Existing Table
Importing a Text File into a New Table
Selecting, Sorting and Deleting Records
Finding and Replacing Data
Filtering Data by Selection & Form
Using Common Filters
Hiding/Unhiding Columns
Freezing & Rearranging Columns
Creating a Query in Design View
Adding Criteria to a Query
Sorting Data in a Query
Using the Query Wizard
Creating Multi-Table Queries
Using Calculations in Queries
Changing Query Properties
Creating a Totals Query
Creating a Parameter Query
Prompting for Dates
Creating a Find Duplicates Query
Creating a Find Unmatched Records Query
Using the Form Wizard
Adding a Field to a Form
Changing Control Properties
Using Layout View
Adding Controls to a Form
Moving and Sizing Controls
Creating a Calculated Control
Changing Control Properties
Changing Form Properties
Adding a Lookup Control
Adding a Subform using the Subform/Subreport Tool
Aligning Controls to Each Other
Creating an Option Group
Creating a Basic Report
Applying a Theme to a Report
Using the Report Wizard
Modifying Report Setup
Printing Reports
Using the Label Wizard
Working with Report Sections
Adding Controls to a Report
Changing a Control’s Data Source
Changing a Report’s Data Source
Sorting and Grouping Data
Applying Conditional Formatting
Edit Sorting and Grouping Levels in a Report
A Look at Database Relationships
Creating a One-to-One Relationship
Creating a One-to-Many Relationship
Creating a Many-to-Many Relationship
Enforcing Referential Integrity
Cascade Update Related Fields
Cascade Delete Related Records
Creating a Macro
Running a Macro Step-by-Step
Assigning a Macro to a Command Button
Creating & Using a Macro Group
Using Macro Conditions
The AutoExec Macro
Creating an AutoKeys Macro
About Action Queries
Creating a Make-Table Query
Creating an Append Query
Creating an Update Query
Creating a Delete Query
Creating a SQL Query
Importing Data from a Text File
Importing Data from Excel
Importing Data from another Access Database
Linking Data
Exporting Data to Other Formats
Exporting Data to a PDF File
Exporting Data to another Access Database
Exporting Data to Excel
Exporting Data to Microsoft Word
Exporting Data to a Microsoft Word Mail Merge
Creating & Modifying a Switchboard
Using Compact and Repair
Changing Database Properties
Documenting a Database
Analyzing a Database
Viewing Object Dependencies
Backing up a Database
Splitting a Database
Setting a Database Password
….and more