Inside Relational Databases with Examples in Access

By Mark Whitehorn , Bill Marklyn

Inside Relational Databases with Examples in Access Cover Image

  • ISBN13: 978-1-8462-8394-9
  • 388 Pages
  • User Level: Trade
  • Publication Date: April 6, 2007
  • Available eBook Formats: PDF
  • eBook Price: $54.95
Buy eBook Buy Print Book Add to Wishlist

Related Titles

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.
Errata

Please Login to submit errata.

No errata are currently published