Viewers: in countries Watching now:
In Access 2010 Power Shortcuts, Access expert Alicia Katz Pollock shares hundreds of tips and shortcuts to vastly increase efficiency and get the full power out of Access 2010. The course includes tips for working with the Ribbon and Quick Access toolbar, managing files, customizing and automating Access, rapid data entry and editing, working with tables, queries, forms, and reports, managing your database, and much more. Exercise files accompany the course.
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.
There are currently no FAQs about Access 2010 Power Shortcuts.
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.