Planning and Creating a Custom Database
- Introduction
- Creating a Custom Database Template
- Planning Tables
- Creating Tables in a Database
- Creating a Table by Entering Data
- Creating a Table Using a Template
- Importing Data into Tables
- Linking to Data in Tables
- Working with Table Records
- Working with a Table in Design View
- Specifying a Primary Key in Design View
- Planning Table Relationships
- Defining Table Relationships
- Creating and Printing a Table Relationship Report
- Ensuring Referential Integrity
- Identifying Object Dependencies
- Modifying Object Dependencies
What You’ll Do
- Create a Custom Database Template
- Plan Tables
- Create Tables in a Database
- Create a Table by Entering Data
- Create a Table Using a Template
- Import Data into Tables
- Link to Data in Tables
- Working with Table Records
- Work with a Table in Design View
- Specify a Primary Key in Design View
- Plan Table Relationships
- Define Table Relationships
- Create and Print a Table Relationship Report
- Ensure Referential Integrity
- Identify Object Dependencies
- Modify Object Dependencies
Introduction
The Microsoft Office Access 2007 database wizards make creating databases easy, but you may need to create a database that does not fit any of the predefined template choices. In that situation, you may need to create the database “from scratch.”
Creating a database from scratch involves careful planning. You must:
- Determine the purpose and scope of your data base.
- Decide what tables your database will contain and what the content of those tables will be.
- Define how data in one table is related to data in another table.
When you create a database from scratch, you can take advantage of the tools that Access provides. If you don’t plan to create a database from scratch but instead plan to use only existing Access databases, you might not need the information in this chapter. Understanding database design concepts, however, will help you better understand how to create effective queries later on.