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.
The Switchboard has received a welcome replacement, navigation forms. When creating a database for others to use or if you are using the web functionality navigation forms create buttons to easily view your forms and reports. Let's make one. I'll go to the Create tab, and over here to the Navigation button. Choose whether you'd like horizontal tabs across the top, vertical tabs down the left or right. You could even have both. If you have a lot of buttons you can do a horizontal two-row set. We are going to go to Vertical Tabs, Left.
Now, drag and drop your desired forms in the order you want them. I'll do make Customers Forms and Reports, and then my Salaries Form and Report. Now, when I click on them it goes from one to the other. I am going to go ahead and close this Field List so you get the full effect. Now, I have four buttons but they all kind of look the same. You have the ability to distinguish them. I am going to go up to Form Layout Tools and to the Format Ribbon. First, I am going to start by changing their shapes.
I am going to click right here on Shape, and I am going to give these an oval look. I'll do that to all four. Now, I am going to change their appearance. I am going to go back to Customers Form, click on Quick Styles, and I am going to use matching color sets to do these. I am going to use green for the Customers, and I am going to use orange for the Salaries.
So now they have a colored appearance as well. When I go back to the Design Ribbon and go back to the Form view, you now have a functional navigation form. Now, please note that the navigation forms only work for forms and reports. They do not work for queries and tables. These innovative navigation forms give you the ability to easily move from one form or report to another.
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.