Access 2016: Up To Speed - E-book - ePub

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 DatabasesUsing Database TemplatesThe Access EnvironmentA Look at Tables, Forms, Queries and ReportsCreating a Table using Application PartsEntering Data into a TableAdding New Fields to a TableCreating a Table from ScratchSetting a Primary KeyRearranging, Inserting and Deleting FieldsSetting Validation RulesFormatting FieldsCreating an Input MaskCreating a Lookup FieldCreating & Modifying a Value ListCreating Calculated FieldsCreating Multiple Primary KeysCreating Multiple Field ValuesEditing & Formatting Table DataImporting Excel Data into an Existing TableImporting a Text File into a New TableSelecting, Sorting and Deleting RecordsFinding and Replacing DataFiltering DataCreating a Query in Design ViewAdding Criteria to a QuerySorting Data in a QueryUsing the Query WizardCreating Multi-Table QueriesUsing Calculations in QueriesChanging Query PropertiesCreating a Totals QueryCreating a Parameter QueryPrompting for DatesCreating a Find Duplicates QueryUsing the Form WizardAdding Controls to a FormMoving and Sizing ControlsCreating a Calculated ControlChanging Control PropertiesChanging Form PropertiesChanging the Tab OrderAdding a Lookup ControlCreating a Basic ReportUsing the Report WizardUsing the Label WizardAdding Controls to a ReportSorting and Grouping DataApplying Conditional FormattingEdit Sorting and Grouping Levels in a ReportCreating and Updating Database RelationshipsEnforcing Referential IntegrityCreating a MacroCreating & Using a Macro GroupThe AutoExec MacroCreating an AutoKeys MacroCreating a Make-Table QueryCreating an Append QueryCreating an Update QueryCreating a Delete QueryCreating a SQL QueryImporting DataLinking DataExporting Data Exporting Data to a Microsoft Word Mail MergeUsing Compact and RepairChanging Database PropertiesBacking up a DatabaseSplitting a DatabaseSetting a Database Password....and more