Apress NBA

Inside Relational Databases with Examples in Access

By Mark Whitehorn , Bill Marklyn

  • eBook Price: $39.95
Buy eBook Buy Print Book

Inside Relational Databases with Examples in Access Cover Image

  • Add to Wishlist
  • ISBN13: 978-1-8462-8394-9
  • 388 Pages
  • User Level: Trade
  • Publication Date: April 6, 2007
  • Available eBook Formats: PDF
Full Description
The first two editions of Inside Relational Databases have both been best sellers. These new editions will also cover the relational database model but will use different engines to illustrate the model. In doing so, readers will be able to apply the model using their preferred database engine. Initially three versions are planned starting with Access, SQL Server and my SQL. The books show just how simple and useful databases can be. No prior knowledge is required i.e. real world examples show how to manage data efficiently. A significant amount of new material is included in the core of the book and particular emphasis is given to showing how to make a database run faster and more efficiently.
Table of Contents

Table of Contents

  1. From the contents Part 1
  2. A simple, single
  3. table database.
  4. Introduction to Part 1.
  5. Tables.
  6. Forms.
  7. Queries/Views.
  8. Reports.
  9. Tables.
  10. Rows and columns.
  11. Records and fields.
  12. Numbers of rows and columns.
  13. Field Names.
  14. Table structures.
  15. Building a table.
  16. Types of data.
  17. Meaningful operations.
  18. Excluding certain errors.
  19. Making storage more efficient.
  20. Making data recall more rapid.
  21. Field size.
  22. General notes on table design.
  23. Think first.
  24. Context
  25. PC or not PC? That is the question.
  26. Controlling data entry.
  27. Field names.
  28. Splitting names, addresses etc.
  29. Don’t store redundant information.
  30. Base tables
  31. not defined here.
  32. Queries/Views.
  33. Queries usually find subsets of the data.
  34. Queries, answer tables and base tables finally defined properly and closure mentioned briefly.
  35. Summarizing data.
  36. Other useful queries.
  37. Update.
  38. Append.
  39. Delete.
  40. Graphical querying tools.
  41. SQL and Views.
  42. Forms.
  43. Multiple forms per table.
  44. Text boxes can be made read only.
  45. Text boxes don’t have to present data from just one field.
  46. it isn’t necessary for each field in a table to appear on the form.

If you think that you've found an error in this book, please let us know by emailing to editorial@apress.com . You will find any confirmed erratum below, so you can check if your concern has already been addressed.
No errata are currently published