- Paperback: 450 pages
- Publisher: McGraw-Hill Inc.,US; UK ed edition (April 2000)
- Language English
- ISBN-10: 0077095855
- ISBN-13: 978-0077095857
- Product Dimensions: 24.6 x 18.6 x 3.2 cm
- Average Customer Review: 4.3 out of 5 stars See all reviews (6 customer reviews)
-
Amazon Bestsellers Rank:
482,562 in Books (See Top 100 in Books)
- #33 in Books > Computers & Internet > Computer Science > Databases > Beginners & Introduction > SQL & Relational Databases
- #64 in Books > Computers & Internet > Computer Science > Databases > SQL
- See Complete Table of Contents
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
|
There is a newer edition of this item:
|
Product details |
More About the Author
Product Description
Product Description
This work provides an introduction to all aspects of the database process, from analysis and design to programming. It enables the reader to learn how to ascertain system requirements, to design Access relational databases, SQL queries and to produce Visual Basic and associated applications. This work makes the important link between VB programs, databases and database programming. It includes many examples and exercises with solutions to reinforce learning.
From the Author
This book will teach you database design, SQL, Access and VB
I wrote this book to answer numerous questions from my second year degree and HND students on how to implement their database applications in Access, and then how to produce workable input and update forms and reports using VB. I identified three problems: 1) incorrect database table and relationship design 2) insufficient knowledge of SQL - the main database language 3) too much reliance on Access wizards. So the three key themes in this book are entity modelling and normalisation to obtain the correct database design, SQL to perform core queries and updates on the database, and Visual Basic database programming in its three forms: data control, DAO and ADO. The feedback from my two previous database books led me to include lots and lots of examples of the things typical database applications will have to do. I have also tried to make the lecturer's life easier by including lots of exercises. If you want to contact me on my email address, please feel free to do so.
I wrote this book to answer numerous questions from my second year degree and HND students on how to implement their database applications in Access, and then how to produce workable input and update forms and reports using VB. I identified three problems: 1) incorrect database table and relationship design 2) insufficient knowledge of SQL - the main database language 3) too much reliance on Access wizards. So the three key themes in this book are entity modelling and normalisation to obtain the correct database design, SQL to perform core queries and updates on the database, and Visual Basic database programming in its three forms: data control, DAO and ADO. The feedback from my two previous database books led me to include lots and lots of examples of the things typical database applications will have to do. I have also tried to make the lecturer's life easier by including lots of exercises. If you want to contact me on my email address, please feel free to do so.
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
25 of 25 people found the following review helpful
Format:Paperback
If you have some experience of Access Databases and want to progress to a more advanced stage using SQL and Visual Basic , then this is the book for you . The various chapters give good examples of how to ( and how not to ) write SQL and give examples of the results. I have found this book is one of the better examples that explains database theory and practice clearly , and is easy to follow . A most useful book to own .
22 of 22 people found the following review helpful
Format:Paperback
Until recently many database texts dwelt among the upper reaches of theory, with few of the established texts concerning themsleves with practical implementation issues. Carter's text provides a useful though limited counterbalance. The text is brisk, precise and replete with step by step instructions on how to do almost anything with ACCESS. It is very much a practical 'how to do' book, more manual in parts than database textbook. It has a very thorough (protracted even) account of SQL in ACCESS which any novice should master reasonably quickly. Other useful parts of the text lie beyond its no frills account of database principles, where form building using both ACCESS features and VB are introduced. Referential integrity is highlighted consistently throughout the text. So there is no excuse for poor design having read it. VB standards have changed over various versions and to his credit the author patiently provides the variations when detailing a coding example. Very helpful.
Despite its definite appeal a few limitations should be flagged. Firstly it is not a complete database course in itself, not for computer science students anyhow. You won't find chapters or even sections on relational algebra, functional dependencies or distributed databases here. Secondly an assessment of a true relational engine such as Sybase's for instance would have been a useful point of comparison with the JET engine. Finally, form building is reached after 290 pages of covering other aspects of design and SQL which is arguably a bit too long given the absence of the sections mentioned above.
Nevertheless a very good text for any novice ACCESS user, and destined to become by far and away one of the more useful ones. Definitely a high usage value text.
11 of 11 people found the following review helpful
Format:Paperback
In short, this book is the kind that I've been looking for a long time. I was fed up with the kind of text that is all about point and click to build pretty databases using wizards, but not explaining what was really going on. This book de-mystifies all the questions that you wanted to ask, but was scared to. Put your hands in your pockets and buy it, if you want an understanding of how databases really work.
Most Recent Customer Reviews
Online support not included
The book has got step by step introduction on the sql querys and all that. the only problem is, to get the database which is needed to write and understand the querys practillay we... Read more
Published on 4 Nov 2009 by Lakmal_SL
Not quite everything it says on the tin!
Being highly inexperienced in the realms of databases in general and Access in particular, I needed a clear and concise treatment of both the basic concepts of database design and... Read more
Published on 4 April 2002 by N. Moran
Excellent layout, a must for any database designer!
This book explains fully the processes of analysis and design required for a successfull database. I have shown the book to a tutor specialising in teaching the processes who has... Read more
Published on 22 Mar 2001
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Beginners & Introduction > SQL & Relational Databases
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Design & Theory
- Books > Computing & Internet > Databases > SQL
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
