Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In Access 2010 New Features, author Alicia Katz Pollock explains each new and enhanced feature in Microsoft Access 2010. This course covers the Backstage view that replaces the File menu in Office 2010, shortcuts for building tables, new layout tools and navigation controls, the macro designer featuring IntelliSense, as well as exporting to and collaborating in SharePoint. Exercise files accompany the course.
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.
Find answers to the most frequently asked questions about Access 2010 New Features.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
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.