Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In Access 2010 Essential Training, Alicia Katz Pollock gives a comprehensive overview of creating databases in Access 2010, whether using predefined database templates or building from scratch. This course covers each step of constructing and modifying databases for custom purposes, as well as working with tables, forms, queries, macros, and reports and charts for record keeping and analysis. Exercise files are included with the course.
The switchboard from previous versions of Access has received a welcome replacement: Navigation forms. When creating a database for others to use, or if you're using the Web SharePoint functionality, navigation forms create buttons to easily view your forms and reports. Click on the Create tab, and choose the Navigation button. Choose whether you'd like a Horizontal Tab set, a Vertical one on the Left or Right, or both. If you have a lot of buttons, choose the Horizontal Tabs 2 Levels. We're going to choose Vertical Tabs, Left.
Drag and drop your desired forms and reports on to the buttons. That's all you have to do. Let's drag down to the bottom of the Navigation Pane, so we can see our Forms and Reports. Start with your Customers Order Form. Pick it up, and drag it to the top of the list. Now down in the Reports, Orders by Customer Report. Also from the Reports, choose Sales Reps and Customers, and the Products Report, the Service Request Form and the Sales Reps Phone List from the Reports.
Now that I have my buttons, we can now work with the appearance. Click on the first button for Customers Order Form, and go to the Format menu. We're going to use a Quick Style. Drop it down, and let's choose this light green with the white outline. We can then change the Shape. Let's make it a Rounded Rectangle. Now let's do the same thing for the other buttons: Orders by Customer Report, Quick Styles > the blue with white outline and the Rounded Rectangle; Sales Reps and Customers, Quick Styles > the tan with the white outline and a Rounded Rectangle; Products Report, Quick Styles > the light tan and the Rounded Rectangle; Service Request Form, Quick Styles > make it pink with the white border and change the Shape to the Rounded Rectangle, and then the Sales Reps Phone List, dropdown the Quick Style > make it the dark green with the white border, change the shape to rounded rectangle.
Now you're not limited to just the Quick Styles. You can also control the appearance with these buttons here. Change the Shape Fill. Instead of green, let's make it this gray right here. I can change the white outline to any other color and width. I can also apply Special Effects: Shadows, Glows, Soft Edges and Bevels. Once you have it, so you like it, go back to the Form Layout Tools > Design tab. Go back to the Form View. Let's close our Navigation Pane, so we can see the form in full.
Click on the different buttons, and it will change to your different objects. Now note that Navigation forms only work for Forms and Reports, not for Tables and Queries. This innovative Navigation Form gives you the ability to easily move from one form or report to another.
Find answers to the most frequently asked questions about Access 2010 Essential Training.
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.