Access Cookbook

Access Cookbook

eBook - 2008
Rate this:
Not a reference book, and not a tutorial either, the new second edition of the highly regarded Access Cookbook is an uncommonly useful collection of solutions to problems that Access users and developers are likely to face as they attempt to build increasingly complex applications. Although using any single "recipe" in the book will more than pay back the cost of the book in terms of both hours saved and frustration thwarted, Access Cookbook, Second Edition is much more than a handy assortment of cut-and-paste code. Each of the "recipes" examine a particular problem--problems that commonly occur.
Publisher: Sebastopol : O'Reilly Media, Inc., 2008.
Edition: 2nd ed.
ISBN: 9780596552527
0596552521
9780596154387
0596154380
Characteristics: 1 online resource (840 p.)
Additional Contributors: Baron, Andy
Litwin, Paul
Contents: 2.2 Highlight the Current Field in Data-Entry FormsProblem; Solution; Discussion; See Also; 2.3 Restrict the User to a Single Row on a Form; Problem; Solution; Discussion; See Also; 2.4 Use an Option Group to Collect and Display Textual Information; Problem; Solution; Discussion; 2.5 Display Multiple Pages of Information on One Form; Problem; Solution; Discussion; 2.6 Provide Record Navigation Buttons on a Form; Problem; Solution; Discussion; See Also; 2.7 Size a Form's Controls to Match the Form's Size; Problem; Solution; Discussion; 2.8 Make a Simple "Searching" List Box; Problem; Solution.
1.13 Use a Query to Show the Relationship Between Employees and SupervisorsProblem; Solution; Discussion; 1.14 Create a Query That Uses Case-Sensitive Criteria; Problem; Solution; Discussion; 1.15 Use a Query to Create a New Table Complete with Indexes; Problem; Solution; Discussion; 1.16 Save My Queries in a Table for Better Programmatic Access and Security; Problem; Solution; Discussion; 1.17 Create a Recordset Based on a Parameter Query from VBA Code; Problem; Solution; Discussion; Forms; 2.1 Make Custom Templates for Forms and Reports; Problem; Solution; Discussion; See Also.
1.7 Use a VBA Variable to Filter a QueryProblem; Solution; Discussion; See Also; 1.8 Use a Query to Retrieve a Random Set of Rows; Problem; Solution; Discussion; 1.9 Create a Query That Will Show Aging of Receivables; Problem; Solution; Discussion; See Also; 1.10 Create a Join That's Based on a Comparison Other than Equality; Problem; Solution; Discussion; 1.11 Create a Query to Combine Data from Two Tables with Similar Structures; Problem; Solution; Discussion; 1.12 Create a Combo Box That Allows a User to Select N/A; Problem; Solution; Discussion; See Also.
Comments and QuestionsAcknowledgments; Queries; 1.1 Specify Query Criteria at Runtime; Problem; Solution; Discussion; 1.2 Using a Form-Based Parameter Query; Problem; Solution; Discussion; 1.3 Limit the Items in One Combo Box Based on the Selected Item in Another; Problem; Solution; Discussion; See Also; 1.4 Make Formatted Date Columns Sort Correctly in a Crosstab Query; Problem; Solution; Discussion; 1.5 Group Mailing Labels by Address; Problem; Solution; Discussion; See Also; 1.6 Use a Field in One Table to Update a Field in Another Table; Problem; Solution; Discussion.
Table of Contents; Preface; What This Book Is About; Promotes Creative Use of the Product; Uses the Tools at Hand; Follows a Problem-Solution Format; Who This Book Is For; What You Need to Use This Book; How This Book Is Organized; What We Left Out; How Do I Set Control Properties?; How Do I Create a New Module?; How Do I Import an Object?; How Do I Create an Event Macro?; How Do I Create an Event Procedure?; How Do I Place Code in a Form or Report's Module?; How Do I Know What to Do with Code Examples?; How Do I Use Data Access Objects (DAO) in New Databases?; Conventions Used in This Book.
Summary: Not a reference book, and not a tutorial either, the new second edition of the highly regarded Access Cookbook is an uncommonly useful collection of solutions to problems that Access users and developers are likely to face as they attempt to build increasingly complex applications. Although using any single "recipe" in the book will more than pay back the cost of the book in terms of both hours saved and frustration thwarted, Access Cookbook, Second Edition is much more than a handy assortment of cut-and-paste code. Each of the "recipes" examine a particular problem--problems that commonly occur.

Opinion

From the critics


Community Activity

Comment

Add a Comment

There are no comments for this title yet.

Age

Add Age Suitability

There are no ages for this title yet.

Summary

Add a Summary

There are no summaries for this title yet.

Notices

Add Notices

There are no notices for this title yet.

Quotes

Add a Quote

There are no quotes for this title yet.

Explore Further

Browse by Call Number

Recommendations

Subject Headings

  Loading...

Find it at CML

  Loading...
[]
[]
To Top