Database Components  «Prev  Next»

Steps for Creating and Using Access Database

Ordering the steps for creating and using an Access database

  1. Open a new database.
  2. Design and create tables.
  3. Tell Access how your tables are related.
  4. Create forms to make data entry easier
  5. Enter your data.
  6. Create queries to give you the information you need.
  7. Create reports to display data and summarized data on paper.

Planning for Database Objects

To create database objects, such as tables, forms, and reports, you first complete a series of design tasks. The better your design is, the better your application will be. The more you think through your design, the faster and more successfully you can complete any system. The design process is not some necessary evil, nor is its intent to produce voluminous amounts of documentation. The sole intent of designing an object is to produce a clear-cut path to follow as you implement it.

Keys

When you create database tables, like those created in Chapter 3, you should assign each table a primary key. This key is a way to make sure that the table records contain only one unique value; for example, you may have several contacts named Michael Heinrich, and you may even have more than one Michael Heinrich (for example, father and son) living at the same address. So, in a case like this, you have to decide how you can create a record in the Customers database that will let you identify each Michael Heinrich separately. Uniquely identifying each record in a table is precisely what a primary key fi eld does. For example, using Collectible Mini Cars as an example, the CustomerID fi eld (a unique number that you assign to each customer placing an order) is the primary key in tblCustomers each record in the table has a different CustomerID number. (No two records have the samenumber.)