Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
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.
In Access 2010 it is now possible to customize your Ribbons, whether it's changing the default Ribbons to your liking or creating brand-new Ribbons for your own frequent commands. First, let's take a look at the terminology that's used. These Ribbons are called the main Ribbons and then when I go into work with different objects, these Ribbons are called the tools. So let's go ahead and make our own Ribbon. I am going to go into backstage view using the File tab and we're going to come down here to Options. About halfway down, you'll find Customize Ribbon and it's broken into two sections.
These are the potential commands for your Ribbon. Over here you'll find the Ribbons themselves. This drop-down menu shows whether you're working with the main tabs or whether you're going to work with the tools tabs. So we're going to come down here to the bottom and make our own new tab. The first thing I am going to do is rename my tab. So, I'll click on the New Tab itself, click on the Rename button and I'll call this Alicia's Commands. I'll click OK, and while I am at it, let's go ahead and rename my first group as well.
Now, whichever one I click on is the one where the commands will go on to, so I do need to add them to this group. It defaults to the Popular Commands, the most common things that you might do. Maybe it's opening up a file or maybe it's saving a table or the report that you're working on. I can also drop this down and get commands specifically from the main tabs. For instance, maybe I create a lot of queries. So I'll come down here and I'll grab both my Query Wizard and my Query Designer.
I can come down and go to the tool tabs as well. For instance, I like to do a lot of conditional formatting. So I'll go to the Form Layout Tools and to Format and then Control Formatting and I'll bring over Conditional Formatting, and then I am also fond of the themes. So I'll come over to Design and Themes and bring over my Themes. Let's take a look and see how this new Ribbon looks. I'll click OK and you'll see right up here, Alicia's Commands, and when I click on it, here are all of my favorite commands.
By customizing your own Ribbons, you can speed up your productivity and improve your workflow.
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.