Chapter 18. Creating Schema

IN THIS CHAPTER

Overview 239

Creating Databases 241

Creating Tables 246

Creating Fields 251

Creating Indexes 259

Creating Relationships 262

Creating Queries 266

Case Study: Updating an Existing Database Installation 271

Overview

Chapter 17, “Object Models for Working with Data,” introduced the concept of a database schema. To review, the schema is the set of rules, definitions, and configurations that your data adheres to as it is stored and retrieved from the file (or files) where the raw data is stored, the data source. Rules and definitions can be compared to table definitions and relationships. Configurations can be compared to queries.

At times, we may find ourselves in a situation that requires us to create the ...

Get Microsoft® Office Access 2007 VBA 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.

Start your free trial