Synopsis
This book provides experienced Access users who are novice programmers with frequently overlooked concepts and techniques necessary to create effective database applications. Unlike other Access books, it takes the reader behind the details and focuses on core concepts in three major areas:
- Database design: examines the principles of sound relational database design and shows how to normalize tables to eliminate data redundancy without losing data.
- Queries: examines multi-table queries and shows how to implement them indirectly by using the Access interface or directly by using Access SQL.
- Programming: introduces the Data Access Object (DAO) and Microsoft Access object models, which allow a developer to place a database under program control.
"synopsis" may belong to another edition of this title.
Review
Access Database Design and Programming covers a lot of ground quickly but lucidly. Steven Roman begins with a description of general principles of database design, then describes the "relational algebra" that defines the meaning of such operations as unions and joins, introduces SQL syntax, and finally dives into the details of using VBA (Visual Basic for Applications) to write Access code. The result is a single book that can teach you all the basics of building database applications in Access. Portions of the book are heavy with logical equations whose effects can be hard to visualize, but Roman's judicious use of sample data makes it much easier to follow the operations being described.
About the Author
Steven Roman, Ph.D., is a professor emeritus of mathematics at the California State University, Fullerton. His previous books with O'Reilly include "Access Database Design and Programming", "Writing Excel Macros with VBA", and "Win32 API Programming with Visual Basic".
"About this title" may belong to another edition of this title.
Search results for Access Database Design & Programming
Stock Image
Access Database Design & Programming: What You Really Need to Know to Develop with Access
Published by
O'Reilly Media (edition 1), 1997
ISBN 10: 1565922972
ISBN 13: 9781565922976
Used
Paperback
Seller: BooksRun, Philadelphia, PA, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Fair. 1. The item might be beaten up but readable. May contain markings or highlighting, as well as stains, bent corners, or any other major defect, but the text is not obscured in any way. Seller Inventory # 1565922972-7-1
Stock Image
Access Database Design & Programming: What You Really Need to Know to Develop with Access (Nutshell Handbooks)
Seller: Wonder Book, Frederick, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: Very Good. Very Good condition. A copy that may have a few cosmetic defects. May also contain light spine creasing or a few markings such as an owner's name, short gifter's inscription or light stamp. Seller Inventory # M14Q-00975
Stock Image
Access Database Design & Programming: What You Really Need to Know to Develop with Access (Nutshell Handbooks)
Seller: Wonder Book, Frederick, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: Good. Good condition. A copy that has been read but remains intact. May contain markings such as bookplates, stamps, limited notes and highlighting, or a few light stains. Seller Inventory # X07A-01680
Stock Image
Access Database Design & Programming
Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less. Seller Inventory # G1565922972I3N00
Stock Image
Access Database Design and Programming : What You Really Need to Know to Develop with Access
Published by
O'Reilly Media, Incorporated, 1997
ISBN 10: 1565922972
ISBN 13: 9781565922976
Used
Softcover
Seller: Better World Books, Mishawaka, IN, U.S.A.
Seller rating 5 out of 5 stars
Condition: Good. Used book that is in clean, average condition without any missing pages. Seller Inventory # 38854489-75
Stock Image
Access Database Design and Programming : What You Really Need to Know to Develop with Access
Published by
O'Reilly Media, Incorporated, 1997
ISBN 10: 1565922972
ISBN 13: 9781565922976
Used
Softcover
Seller: Better World Books: West, Reno, NV, U.S.A.
Seller rating 5 out of 5 stars
Condition: Very Good. Used book that is in excellent condition. May show signs of wear or have minor defects. Seller Inventory # 42692223-6
Stock Image
Access Database Design & Programming
Seller: WorldofBooks, Goring-By-Sea, WS, United Kingdom
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged. Seller Inventory # GOR005961194
Buy Used
US$ 3.77
Shipping:
US$ 7.34
From United Kingdom to U.S.A.
Quantity: 2 available
Stock Image
Access Database Design & Programming: What You Really Need to Know to Develop with Access
Published by
O'Reilly Media 11/08/1997, 1997
ISBN 10: 1565922972
ISBN 13: 9781565922976
Used
Softcover
Seller: AwesomeBooks, Wallingford, United Kingdom
Seller rating 5 out of 5 stars
Condition: Very Good. This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. . Seller Inventory # 7719-9781565922976
Buy Used
US$ 6.25
Shipping:
US$ 6.54
From United Kingdom to U.S.A.
Quantity: 2 available
Stock Image
Access Database Design & Programming: What You Really Need to Know to Develop with Access
Published by
O'Reilly Media 11/08/1997, 1997
ISBN 10: 1565922972
ISBN 13: 9781565922976
Used
Softcover
Seller: Bahamut Media, Reading, United Kingdom
Seller rating 5 out of 5 stars
Condition: Very Good. Shipped within 24 hours from our UK warehouse. Clean, undamaged book with no damage to pages and minimal wear to the cover. Spine still tight, in very good condition. Remember if you are not happy, you are covered by our 100% money back guarantee. Seller Inventory # 6545-9781565922976
Buy Used
US$ 6.25
Shipping:
US$ 9.14
From United Kingdom to U.S.A.
Quantity: 2 available
Stock Image
Access Database Design and Programming : What You Really Need to Know to Develop with Access
Published by
O'Reilly Media, Incorporated, 1997
ISBN 10: 1565922972
ISBN 13: 9781565922976
Used
Softcover
Seller: Better World Books Ltd, Dunfermline, United Kingdom
Seller rating 5 out of 5 stars
Condition: Very Good. Ships from the UK. Former library book; may include library markings. Used book that is in excellent condition. May show signs of wear or have minor defects. Seller Inventory # 53010102-20
Buy Used
US$ 5.99
Shipping:
US$ 10.48
From United Kingdom to U.S.A.
Quantity: 1 available