Create Tables In Layout View With Quick Start In Access 2010


show more Creating tables in Layout view with Quick Start provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Creating tables in Layout view with Quick Start

Access 2010's Layout field allows you to create a table quickly and easily. Let's build our second table for our sales reps. First, click on the Create tab and then on the Table button. Now look over on the right. You'll see contextual Table tools, Fields and Table. Right now, we want to be on the Fields tab. We can start adding in our own fields. But first, I want to show you a tool called Quick Start. These are pre-created sets of fields to speed up your table design. Click on this More Fields button and then scroll down to the bottom.

You'll see Quick Start, and we want Name. It will add in Last Name and First Name for you. Next, click inside the field under Click to Add, so that our next fields go after our Name Fields. If I'm still highlighted on First Name, our fields will go in out of order. So let's go back down to Quick Start, and this time choose Address. It adds all of the standard address fields: Address, City, State Province, ZIP code and Country Region.

Righ...

Creating tables in Layout view with Quick Start
Video duration: 3m 59s 3h 30m Beginner

Viewers:

Creating tables in Layout view with Quick Start provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...