Microsoft® Office AccessTM 2007 Inside Out.

Format:

Book

Author/Creator:

Conrad, Jeff.

Contributor:

Viescas, John.

Series:

Inside Out

Inside out

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

Place of Publication:

Sebastopol : Microsoft Press, 2009.

Language Note:

English

System Details:

text file

Summary:

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 2007-and challenge yourself to new levels of mastery! Create tables that support your database design strategyImport and link to data from spreadsheets, text files, databases, and other ODBC data sourcesBuild simple to complex queries to manipulate dataLearn advan

Contents:

Microsoft Office® Access 2007 Inside Out; About the CD; Sample Applications; System Requirements; Support Information; Conventions and Features Used in This Book; Design Conventions; Syntax Conventions; Introduction; About This Book; 1. Understanding Microsoft Access; Database Capabilities; Access as an RDBMS; Data Manipulation; Data Control; Access as an Application Development System; Deciding to Move to Database Software; 2. Exploring the New Look of Access 2007; Getting Started-A New Look for Access; Exploring the Microsoft Office Button; Taking Advantage of the Quick Access Toolbar

Understanding Content SecurityUnderstanding the Trust Center; Enabling Content by Defining Trusted Locations; Understanding the New Ribbon Feature; Create Tab; External Data Tab; Database Tools Tab; Understanding the New Navigation Pane; Working with Custom Categories and Groups; Creating and Modifying a Custom Category; Creating and Modifying Groups in a Custom Category; Creating Object Shortcuts in Custom Groups; Hiding Custom Groups in a Category; Hiding and Renaming Object Shortcuts; Revealing Hidden Shortcuts; Sorting and Selecting Views in the Navigation Pane

Manually Sorting Objects in the Navigation PaneSearching for Database Objects; Using the Single-Document vs. Multiple-Document Interface; Modifying Global Settings via the Access Options Dialog Box; 3. Microsoft Office Access 2007 Overview; Exploring a Desktop Database-Housing Reservations; Table Window in Datasheet View; Queries; Query Window in Datasheet View; Forms; Form Window in Layout View; Form Window in Form View; Reports; Report Window in Print Preview; Report Window in Layout View; Report Window in Report View; Macros; Modules; Exploring a Project File-Conrad Systems Contacts

Views, Functions, and Stored ProceduresThe Many Faces of Access; 2. Building an Access 2007 Desktop Application; Creating a New Empty Database; Creating Your First Simple Table by Entering Data; Creating a Table Using a Table Template; Creating a Table in Design View; Defining Fields; 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 Properties; Defining Relationships; Creating a Relationship on Multiple Fields; Adding Indexes

Multiple-Field IndexesSetting Table Design Options; Creating a Default Template for New Databases; Printing a Table Definition; Database Limitations; 5. Modifying Your Table Design; Checking Object Dependencies; Deleting Tables; Renaming Tables; Changing Field Names; Moving Fields; Inserting Fields; Copying Fields; Deleting Fields; Changing Data Attributes; Changing Data Lengths; Dealing with Conversion Errors; Changing Other Field Properties; Reversing Changes; Using the Table Analyzer Wizard; Taking a Look at Lookup Properties; Working with Multi-Value Lookup Fields

Changing the Primary Key

Notes:

Description based upon print version of record.

Description based on publisher supplied metadata and other sources.

ISBN:

9780735635999

0735635994

OCLC:

609857105