Page 2 of 11PREVNEXT

Create tables for a new database

Ways to create tables

You need to build an asset tracking database and move away from a spreadsheet that's too big to use. The previous course showed you how to design the tables for your new database – the fields, data types, primary keys, and foreign keys. Now it's time to create the tables.

As a reminder, though, in a relational database, tables store your data. Your data doesn't "live" anywhere else, and that makes tables the central component of your database. If you don't have tables, you don't have a database. This course shows you how to use the most common tools for building tables: Datasheet view and Design view.

Callout 1 In Datasheet view, you build a table by clicking a blank field header, selecting a data type, and then entering a field name. All you have to do is click and type, and we’ll show you how.
Callout 2 For some tables, you can also save time by using Quick Start Fields. These are predefined sets of fields that meet several common business needs, such as capturing addresses or starting and ending dates. All you have to do is select a set of fields from a menu.
Callout 3 In contrast to Datasheet view, Design view lets you control every field and property in a table. In this course, you'll use it to create a table and to change the values in a lookup field — a field that contains a list of choices.

Finally, as you go, remember that if you want to publish your database to SharePoint, you have to use Datasheet view to create your tables.

Page 2 of 11PREVNEXT