Start learning with our library of video tutorials taught by experts. Get started
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.
When you create a new table you could build it from scratch, or you can use a feature called Application Parts as your starting point. Application Parts are pre-created table and form templates that I can further modify to suit my own needs. First, I'm going to create a brand-new empty database by going to the File tab and then down to New. I'll make the name of my database appparts and I'll click Create. It started with a blank table, but I actually want to close this and don't save it. Now that I have a blank file I'll go up to the Create tab and the first buttons says Application Parts. I'll click on it.
At the top there are some sample forms, but first, let's take a look at Quick Start. There are several options here; a Contacts database, Issues tables, Tasks. Let's go ahead and click on Contacts. It prepares the templates and then it preloads several different objects all ready to go. I'll enable the Content and let's take a look. I have an empty Contacts table with examples of just about every field that I could possibly want. I have a ContactsExtended query. I'll open that in Design View and it's ready for you to fill in with your own parameters.
If I open up ContactDetails, there is that form, a ContactList, even several reports including mailing Labels. Now I can delete any unneeded components from these objects, modify them, or add my own, but by starting with Application Parts, my database has been set up correctly saving me a lot of time and ensuring my accuracy. Then let's go up to Create and Application Parts again. In the top part I have several pre-created forms. Let's take a look at a few of them. There is a 2-Column List view.
I got a message saying All open objects must be closed before instantiating this application part. Let's go ahead and close those objects. I'll say Yes. Here is my new form. Let's go ahead and close that one. I'll right-click on the form name, and close. I'll go back up to Application Parts. Here is one I like, Tabs. When I open up my SingleTwoColumnTabsLabels it gives me a form already ready with tabs waiting for me to fill. Using pre-built Access objects can save a lot of time and effort in creating databases for contact and project management.
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.