Microsoft Access 2010 Inside Out

✍ Scribed by Viescas, John;Conrad, Jeff

• Publisher: Microsoft Press
• Year: 2010
• Tongue: English
• Category: Library

✦ Synopsis

You're beyond the basics, so dive right in and really put your database skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Access 2010 -- and challenge yourself to new levels of mastery!Master essential data management and design techniquesImport and link to data from spreadsheets, databases, text files, and other sourcesUse action queries to quickly insert, update, or delete entire sets of dataCreate custom forms to capture and display dataDesig.;Dedication; Contents at a Glance; Table of Contents; Acknowledgments; About the CD; What's on the CD; Sample Applications; System Requirements; Support Information; Conventions and Features Used in This Book; Text Conventions; Design Conventions; Syntax Conventions; Introduction; Getting Familiar with Access 2010; About This Book; Part 1: Understanding Access; Chapter 1: What Is Access?; What Is a Database?; Relational Databases; Database Capabilities; Access as an RDBMS; Data Definition and Storage; Data Manipulation; Data Control; Access as an Application Development System.

✦ Table of Contents

Dedication
Contents at a Glance
Table of Contents
Acknowledgments
About the CD
What's on the CD
Sample Applications
System Requirements
Support Information
Conventions and Features Used in This Book
Text Conventions
Design Conventions
Syntax Conventions
Introduction
Getting Familiar with Access 2010
About This Book
Part 1: Understanding Access
Chapter 1: What Is Access?
What Is a Database?
Relational Databases
Database Capabilities
Access as an RDBMS
Data Definition and Storage
Data Manipulation
Data Control
Access as an Application Development System. Deciding to Move to Database SoftwareExtending the Power of Access to the Web
Chapter 2: Exploring the Access 2010 Interface
Opening Access for the First Time
Getting Started with Access 2010
Opening an Existing Database
Exploring the Microsoft Office Backstage View
Taking Advantage of the Quick Access Toolbar
Understanding Content Security
Enabling a Database That Is Not Trusted
Understanding the Trust Center
Enabling Content by Defining Trusted Locations
Understanding the Office Fluent Ribbon
Home Tab
Create Tab
External Data Tab
Database Tools Tab
Customizing the Ribbon. Understanding the Navigation PaneExploring Navigation Pane Object Views
Working with Custom Categories and Groups
Sorting and Selecting Views in the Navigation Pane
Manually Sorting Objects in the Navigation Pane
Searching for Database Objects
Using the Single-Document vs. the Multiple-Document Interface
Modifying Global Settings via the Access Options Dialog Box
Chapter 3: Access 2010 Overview
The Architecture of Access
Exploring a Desktop Database--Housing Reservations
Tables
Queries
Forms
Reports
Macros
Modules
What Happened to Project Files (ADP)?
The Many Faces of Access. Part 2: Creating a Database and TablesChapter 4: Designing Client Tables
Creating a New Database
Using a Database Template to Create a Database
Creating a New Empty Database
Creating Your First Simple Table by Entering Data
Creating a Table Using Application Parts
Creating a Table Using Data Type Parts
Creating a Table in Design View
Defining Fields
Understanding Field Data Types
Setting Field Properties
Completing the Fields in the Companies Table
Defining Simple Field Validation Rules
Defining Input Masks
Defining a Primary Key
Defining a Table Validation Rule. Understanding Other Table PropertiesDefining Relationships
Defining Your First Relationship
Creating a Relationship on Multiple Fields
Adding Indexes
Single-Field Indexes
Multiple-Field Indexes
Setting Table Design Options
Creating a Default Template for New Databases
Printing a Table Definition
Database Limitations
Chapter 5: Modifying Your Table Design
Before You Get Started
Making a Backup Copy
Checking Object Dependencies
Deleting Tables
Renaming Tables
Changing Field Names
Moving Fields
Inserting Fields
Copying Fields
Deleting Fields
Changing Data Attributes.

✦ Subjects

Computer science;Data management;Microsoft Access;