Part II. Defining the Database Schema
In Part 2, you'll create an Access database and define schema elements, such as tables and queries. Because Access makes it easy to add or modify tables, the database design is often done in ad-hoc fashion. Tables and columns are added as needed to support the form or report that is being developed. However, because the data schema forms the basis for the application, I recommend performing a thorough database design upfront.
In Chapter 2, you'll start by designing the tables. Access provides facilities for defining data integrity, such as foreign keys, unique constraints, and field validation. I encourage you to constrain the database design as much as possible. For example, if a column should not contain ...
Get Pro Access 2010 Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
