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

19. Sharing Data with Other Applications

In This Chapter

• What is external data, and why do you care?

• What does it mean to import data versus link to data, and when should you use each?

• How can you export access data?

• How can you import data into Access?

• How do you link to data in other Access databases?

• How do you link to data stored in Microsoft SQL Server?

Microsoft Access can interface with data from other sources. It can use data from any OLE DB or Open Database Connectivity (ODBC) data source and data from FoxPro, dBASE, Paradox, Lotus, Excel, and many other sources. In this chapter, you learn how to interface with other Access databases, Excel, ASCII text files, and ODBC data sources.