Microsoft® Office AccessTM 2007 Plain & Simple.

Format:

Book

Author/Creator:

Frye, Curtis D.

Contributor:

Frye, Curtis.

Language:

English

Subjects (All):

Microsoft Access.

Database management.

Microsoft Office.

Local Subjects:

Database management.

Microsoft Access.

Microsoft Office.

Physical Description:

1 online resource (0 p.)

Edition:

1st edition

Other Title:

Microsoft Office Access 2007 plain and simple

Office Access 2007

Access 2007

Place of Publication:

Sebastopol : Microsoft Press, 2009.

Language Note:

English

System Details:

text file

Summary:

Here's WHAT You'll Learn Easily navigate the new user interfaceDesign and build your own databaseBuild forms that help you collect informationCreate charts and reportsExchange data with other databases and documentsHelp prevent unauthorized data access Here's HOW You'll Learn It Jump in wherever you need answersEasy-to-follow STEPS and SCREENSHOTS show exactly what to doHandy TIPS teach new techniques and shortcutsQuick TRY THIS! exercises help you apply what

Contents:

Microsoft® Office AccessTM 2007 Plain & Simple; 1. Introduction: About This Book; ...And the Easiest Way to Do Them; A Quick Overview; A Few Assumptions; A Final Word (or Two); 2. What's New in Access 2007; Formatting Database Objects Using New AutoFormats; Creating New Types of Fields; Collecting Data from E-mail Messages; 3. Introducing Access 2007; Storing Data on the Computer; Storing Data in a Database; Starting Access; Create a Shortcut for Access; Surveying the Access Window; Opening a Database; Open a Recently Used Database; Viewing Multiple Database Objects

Scroll within a Database ObjectClosing a Database and Exiting Access; Exit Access; Displaying and Managing Database Objects; Control Object Display in the Navigation Pane; Using the Access Help System; Get Microsoft Access Help; Get Help on the Web; 4. Getting to Know Access Databases; Working with Database Objects; Open an Object; View an Object in Design View; Save an Object; Delete an Object; Examining a Table; Navigate in a Table; Examining a Form; Enter Data Using a Form; Navigating Using a Switchboard; Open a Switchboard; Move Using a Switchboard; Examining a Query; Examining a Report

Using the Database TemplatesFind Database Templates Online; Frequently Used Object Views; 5. Creating a Database; Give Every Table a Primary Key; Include Foreign Keys; Creating a New Database; Create a New Database Based on Another Database; Creating a New Table in Design View; Creating a New Table by Typing; Adding Existing Fields to a Table; Add Fields from Existing Tables; Setting a Primary Key; Getting Data from Other Access Tables; Relationships Explained; Many-to-Many Relationships; Creating Relationships between Tables; Enforcing Referential Integrity; 6. Customizing Fields

Add a FieldArrange Fields; Assigning a Data Type; Viewing or Changing Field Properties; Introducing the Expression Builder; Formatting Field Contents; Creating Input Masks; Edit an Input Mask; Assigning Required Fields and Requiring Data Entry; Disallow Zero-Length Strings; Setting Default Values; Indexing Field Values; Validating Data Entry; Set Validation Text; Creating a Lookup Field; Allow Multiple Selections from a Lookup Field; Draw Lookup Values from a Data List; Creating an Append-Only Memo Field; Creating an Attachment Field; 7. Customizing Tables; Replace Text

Entering Data Using AutoCorrectTurn AutoCorrect On or Off; Add AutoCorrect Values; Adding and Editing Text; Delete Text; Undoing Operations; Copy and Paste Text; Copy and Paste Items with the Office Clipboard; Manipulating Columns; Insert a Column; Rename a Column; Copy a Column; Modifying Columns and Rows; Change Column Width; Viewing a Subdatasheet; Create a Subdatasheet; Filtering Table Records; Filter by Form; Remove a Filter; Filter Records by the Contents of More than One Column; 8. Creating Forms; Creating a Form Using the Form Wizard; Creating a Form in Design View

Creating a Multiple Items Form

Notes:

Description based upon print version of record.

ISBN:

9780735636200

0735636206

OCLC:

609857138