book

Access® 2013 Absolute Beginner’s Guide

by Alison Balter

April 2013

Beginner

416 pages

9h 49m

English

Que

Read now

Unlock full access

Who Should Read This BookHow This Book Is OrganizedUsing This Book
What Is a Relational Database?What Types of Things Can I Do with Microsoft Access?A Preview of the Database Components
Creating a Database from a TemplateViewing Database ObjectsCreating a Database from ScratchOpening an Existing DatabaseClosing a DatabaseExiting Access
Working with Table DataEditing Table DataAdding Records to a TableAdd Records to a TableDeleting RecordsFiltering Table Data
What Is a Query and When Should You Use One?Creating a Simple QueryOrdering the Query ResultWorking with Simple CriteriaSaving a QueryClosing a Query
Moving from Record to Record in a FormUndoing Changes Made Within a FormUsing a Form to Delete Records from a TableCopying Records Within a FormFinding a Record That Meets Specific CriteriaSorting RecordsFiltering the Data Underlying a FormClosing a Form
The AutoForm FeatureUsing the Form Wizard to Build a FormCreating Split FormsCreating Multiple Item FormsCreating Navigation Forms
Opening and Viewing a ReportWorking in Layout ViewWorking in Report ViewPrinting a ReportClosing a Report
Using the AutoReport FeatureViewing the Design of a ReportTypes of Reports Available
Building a New TableSelecting the Appropriate Field Type for DataUsing Indexes to Improve PerformanceThe All-Important Primary KeyWorking with Field Properties
Introduction to Relational Database DesignThe History of Relational Database DesignThe Types of RelationshipsEstablishing Relationships in AccessEstablishing Referential Integrity
Everything You Ever Needed to Know About Query BasicsUpdating Query ResultsBuilding Queries Based on Multiple TablesRefining a Query by Using Criteria
Creating Calculated FieldsGetting Help from the Expression BuilderCreating and Running Parameter QueriesCreating and Running Action QueriesUsing Aggregate Functions to Summarize Numeric DataCreating Totals QueriesWorking with Outer Joins
Power Control TechniquesConditional FormattingForm Properties and Why Should You Use ThemControl Properties and Why to Use Them
Working with Combo BoxesThe Command Button Wizard: Programming Without TypingBuilding Forms Based on More Than One Table
The Anatomy of a ReportControl Properties and Why to Use ThemBuilding Reports Based on More Than One Table
Working with Sorting and GroupingReport Properties and Why to Use ThemBasing Reports on Stored Queries or Embedded SQL Statements
Learning the Basics of Creating and Running a MacroRunning an Access MacroModifying an Existing MacroCreating an Embedded Macro
Creating Data MacrosCreating a Drillthrough MacroOther New Features Available in MacrosTesting a MacroDetermining When You Should Use Macros and When You Shouldn’tConverting a Macro to VBA CodeCreating an AutoExec Macro
What Is External Data?Importing, Linking, and Opening Files: When and WhyExporting to Another Access DatabaseExporting to an Excel SpreadsheetExporting to ASCIIImporting from Another Access DatabaseImporting Spreadsheet DataImporting ASCII DataLinking to Tables in Another Access DatabaseLinking to Another Type of DatabaseThe Linked Table Manager
Working with Web DatabasesCreating a Blank Web DatabaseCreating a QueryCreating and Working with FormsUsing a Template to Create a WebsiteViewing Your Website in a Browser
Designing the Tables to Store Your DataBuilding the Forms to Edit Your DataBuilding the Queries to Extract the Data You NeedDesigning the Reports to Display Your Data

Content preview from Access® 2013 Absolute Beginner’s Guide

Dedication

Many people are important in my life, but there is no one as special as my husband Dan. I dedicate this book to Dan. Thank you for your ongoing support, for your dedication to me, for your unconditional love, and for your patience. Without you, I’m not sure how I would make it through life. Thank you for sticking with me through the good times and the bad! There’s nobody I’d rather spend forever with than you.

I also want to thank God for giving me the gift of gab, a wonderful career, an incredible husband, two beautiful children, a spectacular area to live in, a very special home, and an awesome life. Through your grace, I am truly blessed.