Microsoft® Office Access 2003 inside out.

Format:

Book

Author/Creator:

Viescas, John.

Language:

English

Subjects (All):

Database management.

Databases--Development.

Microsoft Access.

Local Subjects:

Database management.

Databases--Development.

Microsoft Access.

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:

dc:abstract """""" Hey, you know your way around a database-so now dig into Access 2003 and really put your information to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds all in concise, fast-answer format. It's all muscle and no fluff. Discover the best and fastest ways to perform everyday tasks, and challenge yourself to new levels of Access mastery! Build on what you already know about Access and quickly dive into what's new Design your databas

Contents:

Microsoft® Office Access 2003 Inside Out; We'd Like to Hear from You!; About the CD; Sample Applications; Using the CD; 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; Microsoft Access as an RDBMS; Data Manipulation; Data Control; Microsoft Access as an Application Development System; Deciding to Move to Database Software; 2. The Many Faces of Microsoft Access; Exploring a Desktop Database-Housing Reservations

The Table Window in Datasheet ViewQueries; The Query Window in Datasheet View; Forms; The Form Window in Form View; Reports; The Report Window in Print Preview; Data Access Pages; The Data Access Page Window in Page View; Macros; Modules; Organizing Your Objects; Exploring a Project File-LawTrack Contacts; Views, Functions, and Stored Procedures; The Many Faces of Microsoft Access; 3. Designing Your Database Application; Step 2: Charting Task Flow; Step 3: Identifying Data Elements; Step 4: Organizing the Data; Step 5: Designing a Prototype and a User Interface

Step 6: Constructing the ApplicationStep 7: Testing, Reviewing, and Refining; An Application Design Strategy; Selecting the Data; Organizing Tasks; Data Analysis; Mapping Subjects to Your Database; Database Design Concepts; Normalization Is the Solution; Primary Keys; Functional Dependence; Field Independence; Efficient Relationships Are the Result; One-to-Many and One-to-One Relationships; Creating Table Links; When to Break the Rules; Capturing Point-In-Time Data; Creating Report Snapshot Data; 2. Building a Microsoft Access Desktop Application; Creating a New Empty Database

Creating Your First Simple Table by Entering DataCreating a Table Using the Table Wizard; 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 Indexes; Setting Table Design Options; Printing a Table Definition; Database Limitations; 5. Modifying Your Table Design

Checking Object DependenciesDeleting 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; Changing the Primary Key; Compacting Your Database; 6. Importing and Linking Data; Importing vs. Linking Database Files; Importing Data and Databases; Importing Paradox Files; Importing SQL Tables; Importing Access Objects

Importing Spreadsheet Data

Notes:

Description based upon print version of record.

ISBN:

9780735635173

073563517X

9780585486758

0585486751

OCLC:

609856953