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

12. Advanced Query Techniques

In This Chapter

• What are calculated fields, and why would I want to use them?

• What are parameter queries, and why are they important?

• How can I build a query that updates table data?

• How can I build a query that deletes table data?

• How can I build a query that appends data to a table?

• How can I build a query that makes a new table?

• How can I summarize table data?

• What is an outer join, and why would I need one?

You will probably agree from your experience with queries thus far that Access queries are very powerful. This chapter takes Access queries to a whole new level.

You begin by creating calculated fields. You can create calculated fields that multiply the price of an item by the quantity, or ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Microsoft® Access® 2013 Step by Step

Joan Lambert and Joyce Cox

Microsoft® Access® 2010 In Depth

Roger Jennings

Using Microsoft® Publisher 2010

Brien Posey

Using Microsoft® Access® 2010

Alison Balter

Publisher Resources

ISBN: 9780133260939Purchase book