Planning and Creating a Custom Access 2013 Database
- Creating a Custom Database Template
- Using a Custom Database Template
- Planning Tables
- Creating Tables in a Database
- Creating a Table by Entering Data
- Creating an Application Part 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
The Microsoft Access 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.