Access Database Design & Programming PDF download by Steven Roman

Access Database Design & Programming

O'Reilly Media
Publication date: September 2007
ISBN: 9780596516598
Digital Book format: PDF (DRM-Free)

Buy PDF

List price:
$31.99
Our price:
$28.99

You save: $3.00 (9%)
GET THIS EBOOK
FOR FREE!
Join our Facebook sweepstake, share and
get 10 likes. Winners
get notified in 24H!

Access Database Design & Programming takes you behind the details of the Access interface, focusing on the general knowledge necessary for Access power users or developers to create effective database applications. When using software products with graphical interfaces, we frequently focus so much on the interface that we forget about the general concepts that allow us to understand and use the software effectively. In particular, this book focuses on three areas:

  • Database design. The book provides an enjoyable, informative overview of database design that carefully shows you how to normalize tables to eliminate redundancy without losing data.
  • Queries. The book examines multi-table queries (i.e.,various types of joins) and shows how to implement them indirectly by using the Access interface or directly by using Access SQL.
  • Programming. The book examines the VBA integrated development environment (IDE). It then goes on to provide an excellent introduction to Data Access Objects (DAO), ActiveX Data Objects (ADO), and ADO Extensions for Data Definition and Security (ADOX). These sections serve as a handy introduction and primer for basic database operations,such as modifying a table under program control, dynamically adding and deleting a record, and repositioning a record pointer. The concluding chapter focuses on common programming problems, such as computing running sums and comparing two sets.
Unlike other Access books that take the long, detailed approach to every topic of concern to Access programmers, Access Database Design &Programming instead focuses on the core concepts, enabling programmers to develop solid, effective database applications. This book also serves as a 'second course' in Access that provides a relatively experienced Access user who is new to programming with the frequently overlooked techniques necessary to develop successfully in the Microsoft Access environment.

Anyone interested in learning Access in depth, rather than just scraping the surface, will enjoy and benefit immensely from reading this book.

Please sign in to review this product.
Format:
PDF
Devices:
Access Database Design & Programming PDF can be read on any device that can open PDF files.

File Size:
6239 Kb
Language:
ENG
Access Database Design & Programming PDF download by Steven Roman
O'Reilly Media, September 2007
ISBN: 9780596516598
EAN:  9780596516598
PDF
List Price: $31.99 eBook price: $28.99
Access Database Design & Programming ePub download by Steven Roman
O'Reilly Media, May 2013
ISBN: 9781449366438
EAN:  9781449366438
ePub
List Price: $31.99 eBook price: $28.99
Other books by Steven Roman
The Umbral Calculus ePub (Adobe DRM) download by Steven Roman
The Umbral Calculus
Steven Roman
Dover Publications, June 2013
ISBN: 9780486441399
Format: ePub
List Price: $14.95 Our price: $11.99
E-Study Guide for: Advanced Linear Algebra ePub (Adobe DRM) download by Cram101 Reviews
Just the FACTS101 e-Study Guide for: Advanced Linear Algebra
Cram101 Reviews & Cram101 Textbook Reviews & Steven Roman
Cram101, January 2012
ISBN: 9781467267618
Format: ePub
List Price: $18.95 Our price: $13.99
VB.NET Language Pocket Reference PDF download by Paul Lomax
VB.NET Language Pocket Reference
Paul Lomax & Ron Petrusha & Steven Roman & PhD Steven Roman
O'Reilly Media, December 2002
ISBN: 9780596004286
Format: PDF, ePub
List Price: $7.99 Our price: $6.99
Writing Excel Macros with VBA PDF download by Steven Roman
Writing Excel Macros with VBA
Steven Roman & PhD Steven Roman
O'Reilly Media, September 2007
ISBN: 9780596003593
Format: PDF, ePub
List Price: $31.99 Our price: $28.99