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

6. Creating Your Own Forms

In This Chapter

• How do I use AutoForm to create my own form?

• How do I use a Form Wizard to build a form?

• What is a Split form and how do I build one?

• How do I create a form with multiple items?

What is a Navigation form and how can I build one? In this chapter, you learn how to create your own forms. You start with the simplest but least flexible method to create a form: the AutoForm feature. You then explore the Form Wizard that provides you with a flexible and powerful method to create forms. After exploring the Form Wizard, you look at three types of forms available to you: Split forms, forms with multiple items, and Navigation forms.