Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Access 2010's Quick Start fields allow you to build your tables effortlessly by utilizing common field sets that work well together. First, I'm going to create a brand-new empty database by going to the File tab, clicking on New, and I'll give it the name quickstart. Then I'll click Create. It starts me off on the Table tools Ribbon on the Fields tab. We could start adding in our own fields, but instead, we can take advantage of pre-created sets of fields to speed up the table design. Click on this More Fields button, then scroll down to the bottom to the Quick Start fields.
We'll start with Name and it pops in automatically Last Name and First Name. Now click in the Click to Add box. If we don't, if we left our cursor in the First Name, when we do our next set of fields, it would go in between Last Name, and First Name. So I want to make sure my cursor is here under Click to Add. I'll go back to More Fields, scroll down to the Quick Start again and choose Address. Now I have Address, City, State, Zip, and Country. I'll click under Click to Add again, go back to More Fields, and this time let's say we wanted to have start and end dates for our involvement with this client.
I'll come down to Quick Start, and choose Start and End Dates, and there they are. Last but not least, I really like Payment Type which creates a dropdown with standard forms of customer payment. Also on this More Fields button are a long list of other predefined field options to save you the hassle of defining, naming, and entering the parameters for each field. There are for example six different number formats, six date formats, and four different check box sets.
Taking advantage of Quick Start fields under the More Fields button will save you several steps when creating your tables.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 90769 Viewers
80 Video lessons · 138007 Viewers
59 Video lessons · 56799 Viewers
52 Video lessons · 70422 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.