Building Microsoft Access Applications

( 1 )

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 ...
See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (45) from $1.99   
  • New (7) from $13.20   
  • Used (38) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$13.20
Seller since 2014

Feedback rating:

(239)

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.

New
PAPERBACK New 0735620393 XCITING PRICES JUST FOR YOU. Ships within 24 hours. Best customer service. 100% money back return policy.

Ships from: Bensalem, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$13.20
Seller since 2010

Feedback rating:

(640)

Condition: New
PAPERBACK New 0735620393! ! ! ! BEST PRICES WITH A SERVICE YOU CAN RELY! ! !

Ships from: Philadelphia, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$13.24
Seller since 2011

Feedback rating:

(665)

Condition: New
PAPERBACK New 0735620393 SERVING OUR CUSTOMERS WITH BEST PRICES. FROM A COMPANY YOU TRUST, HUGE SELECTION. RELIABLE CUSTOMER SERVICE! ! HASSLE FREE RETURN POLICY, SATISFACTION ... GURANTEED**** Read more Show Less

Ships from: Philadelphia, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$13.24
Seller since 2013

Feedback rating:

(343)

Condition: New
PAPERBACK New 0735620393! ! KNOWLEDGE IS POWER! ! ENJOY OUR BEST PRICES! ! ! Ships Fast. All standard orders delivered within 5 to 12 business days.

Ships from: Southampton, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$13.24
Seller since 2010

Feedback rating:

(858)

Condition: New
PAPERBACK New 0735620393 Friendly Return Policy. A+++ Customer Service!

Ships from: Philadelphia, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$13.24
Seller since 2009

Feedback rating:

(2271)

Condition: New
PAPERBACK New 0735620393 Ships Within 24 Hours. Tracking Number available for all USA orders. Excellent Customer Service. Upto 15 Days 100% Money Back Gurantee. Try Our Fast! ! ... ! ! Shipping With Tracking Number. Read more Show Less

Ships from: Bensalem, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$22.39
Seller since 2008

Feedback rating:

(167)

Condition: New
0735620393 BRAND NEW NEVER USED IN STOCK 125,000+ HAPPY CUSTOMERS SHIP EVERY DAY WITH FREE TRACKING NUMBER

Ships from: fallbrook, CA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

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.

Read More Show Less

Product Details

  • ISBN-13: 9780735620391
  • Publisher: Microsoft Press
  • Publication date: 2/16/2005
  • Edition description: REV
  • Pages: 720
  • Product dimensions: 7.34 (w) x 9.14 (h) x 1.87 (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.

Read More Show Less

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
Read More Show Less

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:

Your Name: Create a Pen Name or

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 identity 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
Sort by: Showing 1 Customer Reviews
  • 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.

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)