Building Microsoft Access Applications

( 1 )
Pick Up In Store

Pick Up in Store

Reserve and pick up in 60 minutes at your local store

Paperback (REV)
$31.67
BN.com price
$49.99 List Price (Save 37%)
Marketplace (New and Used)
from
$2.40
$49.99 List Price (Save 95%)
Usually ships in 1-2 business days
All (20)  
Used (11)  
New (9)  
Close
Sort by
Page 1 of 2
Showing 1 – 10 of 20 (2 pages)
$2.40
(Save 95%)
Elistics
Seller since 2010

Feedback rating:

(252)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

Good
USED We here at Elistics have a 100% satisfaction guarentee. We also ship no later than next business day. Thank you for your business.

Ships from: Vancouver, WA

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
$2.41
(Save 95%)
AtlantaBookCompany
Seller since 2009

Feedback rating:

(8060)

Condition: Good
Book shows minor use. Cover and Binding have minimal wear and the pages have only minimal creases. A tradition of southern quality and service. All books guaranteed at the ... Atlanta Book Company. Our mailers are 100% recyclable. Read more Show Less

Ships from: Atlanta, GA

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$2.41
(Save 95%)
BookJingle
Seller since 2010

Feedback rating:

(866)

Condition: Good
0735620393 Good title in good condition. Pages are clean and tight. Cd included. Covers have minor shelf wear. Satisfaction guaranteed. If item not as described, return for refund ... of purchase price. Read more Show Less

Ships from: Georgetown, KY

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$2.42
(Save 95%)
thriftbooks-com
Seller since 2007

Feedback rating:

(5902)

Condition: Good
Ex-Library book - will contain library markings. Light shelf wear and minimal interior marks. Millions of satisfied customers and climbing. Thriftbooks is the name you can ... trust, guaranteed. Spend Less. Read More. Read more Show Less

Ships from: Auburn, WA

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$6.79
(Save 86%)
Extremely_Reliable
Seller since 2007

Feedback rating:

(3184)

Condition: Good
Excellent customer service. Prompt Customer Service. Buy with confidence.

Ships from: Richmond, TX

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
$7.92
(Save 84%)
Ukazoo Books
Seller since 2006

Feedback rating:

(10413)

Condition: Good
Standard used condition.

Ships from: Baltimore, MD

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$11.74
(Save 77%)
Adsrus Media IA
Seller since 2007

Feedback rating:

(1252)

Condition: Good
2005-02-23 Paperback Book Good. No dust jacket as issued. Hardcover with no dust jacket. X-Library Book with usual markings/attachments. Normal shelf and display wear. Minor ... cover wear... Read more Show Less

Ships from: Des Moines, IA

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$17.95
(Save 64%)
savethetrees
Seller since 2012

Feedback rating:

(37)

Condition: Good

Ships from: Lookout Mountain, GA

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Express, 48 States
  • •Express (AK, HI)
$20.44
(Save 59%)
One Stop Text Books Store
Seller since 2012

Feedback rating:

(1)

Condition: Good
2005-02-23 Paperback Good

Ships from: Saint Louis, MO

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$21.91
(Save 56%)
GIANTBOOKSALE
Seller since 2008

Feedback rating:

(3636)

Condition: New
0735620393 SHIPS TODAY!! GREAT BOOK!!

Ships from: BAY SHORE, NY

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
Page 1 of 2
Showing 1 – 10 of 20 (2 pages)
Close
Sort by

Overview

Get fully functional database samples and table designs for four of the most common Microsoft Access database types—and use them as templates to create your own Access solutions. Database expert and Microsoft MVP John L. Viescas provides the detailed guidance you need to customize your own solutions from these application types:

  • Membership Tracking
  • Inventory Management
  • Customer Support
  • Reservations Management

For each type, you’ll walk through ...

See more details below
Sending request ...

More About This Book

Overview

Get fully functional database samples and table designs for four of the most common Microsoft Access database types—and use them as templates to create your own Access solutions. Database expert and Microsoft MVP John L. Viescas provides the detailed guidance you need to customize your own solutions from these application types:

  • Membership Tracking
  • Inventory Management
  • Customer Support
  • Reservations Management

For each type, you’ll walk through typical usage scenarios, design considerations, and common pitfalls. You’ll examine the logic behind each application’s table design, and learn how to adapt it for your own Access solution.

Get expert insights and examples to help you:

  • Learn specific design techniques to improve your table structures
  • Build forms with an attractive, intuitive, and easy-to-use interface
  • Create queries, forms, and reports specific to each application type
  • Design for client/server from the start-and share data more efficiently
  • Apply best practices to help your application run more smoothly
  • Avoid the 10 most common design problems—and deliver more robust solutions!

Note: This book covers Microsoft Office Access 2003, Access 2002, and Access 2000

CD includes database samples and a fully searchable eBook.

Use the sample databases on CD to model your own solutions for:

  • Membership Tracking: Enter, track, and manage member information and communications.
  • Inventory Management: Track and manage stock and create purchase orders, invoices, and packing lists.
  • Customer Support: Track contacts, enter customer details, identify follow-up items, and create reminders.
  • Reservations Management: Manage course registrations, car rentals, room reservations, and more.

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

Product Details

  • ISBN-13: 9780735620391
  • Publisher: Microsoft Press
  • Publication date: 2/16/2005
  • Edition description: REV
  • Pages: 720
  • Sales rank: 830,663
  • Product dimensions: 7.37 (w) x 9.00 (h) x 1.75 (d)

Meet the Author

John L. Viescas is a database expert who provides consulting and training services to companies around the globe. He is the author of numerous books, including Running Microsoft Access 97, Running Microsoft Access 2000, Microsoft Office Access 2003 Inside Out, Building Microsoft Access Applications, and Microsoft Office Access 2007 Inside Out. John has been recognized as a Microsoft MVP since 1993.

Home Page: Viescas Consulting, Inc.

Table of Contents

Pt. I Designing your application
1 Designing your tables 3
2 Creating the user interface 37
3 Designing a client/server application 57
Pt. II Building a membership tracking application
4 The membership tracking application 115
5 Verifying names 121
6 Tracking member activities 129
7 Tracking member status 137
8 Sending out notices 149
Pt. III Creating an inventory management application
9 The inventory management application 173
10 Ordering items from inventory 183
11 Generating purchase orders 215
12 Posting received items into inventory 241
13 Creating customer invoices 281
14 Designing sales and inventory reports 297
Pt. IV Implementing a customer support application
15 The customer support application 319
16 Organizing customer information 327
17 Capturing support cases 349
18 Tracking reminders 373
19 Reporting and analyzing support cases 391
Pt. V Creating a registration management application
20 The registration management application 413
21 Scheduling courses 423
22 Scheduling students 465
23 Printing and e-mailing schedules 501
24 Producing student invoices 529
App. A Recommended reading 551
App. B Sample database schemas 555
App. C Function reference 581
App. D Understanding SQL 587
App. E Implementing generic features 633

Customer Reviews

Average Rating 4
( 1 )

Rating Distribution

5 Star

(0)

4 Star

(1)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Review Guidelines
Add Recommendations
Your Name: Create a Pen Name or Leave Anonymously

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identiy on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

We're sorry, but penname is already taken.

Please select one of the following:
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

penname is available!

By visiting the BN.com website or marking a purchase on BN.com, a User is deemed to have accepted the Terms of Use.

Continue Anonymously

Welcome, penname

You have successfully created your Pen Name. Start enjoying the benefits of the BN.com Community today.

Sort by: Showing 1 Customer Review

  • Anonymous

    Posted February 20, 2010

    Way beyond basics - good resource

    I don't have knowledge of all the categories in the rankings since I just got this book and have not delved into a lot. Excellent resource for advanced ACCESS users. It does not have basics in it, so if that's what you need you need his earlier book.

    Was this review helpful? Yes  NoThank you for your feedback.   Report this reviewThank you, this review has been flagged.
Sort by: Showing 1 Customer Review
If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)
500 character limit