Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
With Access 2010's new Quick Start fields, commonly used table fields can also be created in pre-formatted, coordinated sets. Click on Create and then open up the new table and now look under the More Fields button. In addition to the data types that you see above, you also have additional ones including Rich Text, Attachments and Hyperlinks, multiple number formatting including Euros, six different date and time auto formats. There are even four different sets for Yes or No buttons now.
Now below that you'll find the Quick Start field groups. For example, let's add an Address Quick Start group and look. It added Address, City, State, Zip Postal and Country. I'll click over here to add some more. I'm going to go up to More Fields and this time let's do Phone numbers. Check this out. It just did, one, two, three, four, phone number fields all at once. Here we additionally have some other useful practical ones like Payment Types. This will actually give you a drop-down, showing whether they pay with Cash, Credit Card, Checks or In Kind.
You can even create your own Quick Start field sets. To do this, select a field or fields that you would like to have in your set, click back on More Fields again and then at the very bottom, choose Save Selection as New Data Type. It'll ask for the Name and the Description will be your tooltip. You can set the Category. It defaults to the ones that you made yourself or, if you drop it down, you can put it under the other categories as well and I'll click OK.
It will save it and now when I look under More Fields, you'll see it down at the bottom. By using Quick Start field sets, you'll see many steps in setting up your tables, especially for commonly used data.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 98360 Viewers
80 Video lessons · 141468 Viewers
59 Video lessons · 59818 Viewers
52 Video lessons · 73020 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.