From the course: Access 2019 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create a table and set data types

Create a table and set data types

From the course: Access 2019 Essential Training

Start my 1-month free trial

Create a table and set data types

“

- [Instructor] When creating a place for our data to live, we'll define the columns or the fields that'll house the data in the table. Remember that in a properly normalized data table, the fields will represent the smallest piece of information possible, so instead of a single name field, we'll instead break it into a first name, last name, or even add middle name, suffix, or prefix fields as needed. Let's create a table to hold information about the Landon Hotel's guests and I'll do this in a new blank database that we created in the last chapter. Now, there's a couple of different ways to create new tables in Access, and they all start with the Create tab in the Tables group. The last option is to create SharePoint lists on a SharePoint server, which isn't what we're doing right now. The first option is what we're going to do. This'll create a table in data sheet view, but we also have the option to create a table in design view. Let's go ahead and click on the first button to…

Contents