iTunes

Opening the iTunes Store.If iTunes doesn't open, click the iTunes application icon in your Dock or on your Windows desktop.Progress Indicator
Opening the iBooks Store.If iBooks doesn't open, click the iBooks app in your Dock.Progress Indicator
iTunes

iTunes is the world's easiest way to organize and add to your digital media collection.

We are unable to find iTunes on your computer. To download from the iTunes Store, get iTunes now.

Already have iTunes? Click I Have iTunes to open it now.

I Have iTunes Free Download

Access 2016: Up To Speed

This book can be downloaded and read in iBooks on your Mac or iOS device.

Description

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.
    
Some of the topics include:        
        
Understanding Databases
Using Database Templates
The Access Environment
A Look at Tables, Forms, Queries and Reports
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
Setting Validation Rules
Formatting Fields
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
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
Using the Form Wizard
Adding Controls to a Form
Moving and Sizing Controls
Creating a Calculated Control
Changing Control Properties
Changing Form Properties
Changing the Tab Order
Adding a Lookup Control
Creating a Basic Report
Using the Report Wizard
Using the Label Wizard
Adding Controls to a Report
Sorting and Grouping Data
Applying Conditional Formatting
Edit Sorting and Grouping Levels in a Report
Creating and Updating Database Relationships
Enforcing Referential Integrity
Creating a Macro
Creating & Using a Macro Group
The AutoExec Macro
Creating an AutoKeys Macro
Creating a Make-Table Query
Creating an Append Query
Creating an Update Query
Creating a Delete Query
Creating a SQL Query
Importing Data
Linking Data
Exporting Data 
Exporting Data to a Microsoft Word Mail Merge
Using Compact and Repair
Changing Database Properties
Backing up a Database
Splitting a Database
Setting a Database Password

....and more

Access 2016: Up To Speed
View in iTunes
  • $9.99
  • Available on iPhone, iPad, iPod touch, and Mac.
  • Category: Databases
  • Published: Feb 07, 2017
  • Publisher: PCM Courseware, LLC
  • Seller: Draft2Digital, LLC
  • Print Length: 179 Pages
  • Language: English
  • Requirements: To view this book, you must have an iOS device with iBooks 1.3.1 or later and iOS 4.3.3 or later, or a Mac with iBooks 1.0 or later and OS X 10.9 or later.

Customer Ratings

We have not received enough ratings to display an average for this book.