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

4. Using Queries to Retrieve the Data You Need

In This Chapter

• What is a query?

• Why would you want to use a query?

• How do you create a simple query?

• What’s the difference between the And condition and the Or condition?

• How do I use wildcards in the queries that I build?

• Are query results updateable?

In this chapter, you learn what queries are and why they are important. You learn how to work with queries in both Datasheet view and Design view. You explore the basics of working with queries such as selecting fields, ordering the query result, and using basic criteria. You become comfortable with the process of using And and Or conditions in the queries that you build. You also learn about comparison operators and wildcards.