From the course: Access Essential Training (Office 365/Microsoft)

Unlock the full course today

Join today to access over 22,700 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 Essential Training (Office 365/Microsoft)

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. 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 down into first name, last name, or even middle name, suffix, or prefix fields as needed. Let's go ahead and create a table to hold information about the Landon Hotel's guests. I'll do this in the new blank database we created in the last chapter. There's a couple of different ways to create a new table in Access. We're gonna go up to the Create tab and take a look at this Tables group here. The last option, SharePoint Lists, will create a table on a SharePoint server. The other two options are what we're looking for to create a table that resides here in our local Access database. We can create a table either in datasheet view with this first button, or in design view with the second…

Contents