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 Navigation Pane has a few tricks up at sleeve so that you can use it effectively for your workflow. Let's take a look at the Navigation Pane and all its features. First, you can click this little button to collapse the Navigation Pane, to make more room for your workspace. Click it again to bring it back out. You can also resize it by holding your cursor over the edge and getting this double-headed arrow. Then you can make it narrower and wider. If you double-click on it, it will close completely and open back up again.
You can click on the section headers to open and close them. You can also sort the Navigation Pane so it's useful for you. Click on this little arrow in the circle. Right now, it's sorted by Object Type so that all the tables, the queries, the forms and reports are grouped together. Let's change it to Tables and Related Views. Now, you'll see the Customers : Table and all of the objects that use information from it - they call that dependent on - and here's the SalesReps : Table and all of the objects dependent on it.
This can be practical, but it also makes it sometimes more confusing because you'll see the same objects repeated throughout the column. I can click on that again and see them by Created Date. The most recent objects will be on top. The oldest ones will be on the bottom. Drop it down again, and we can also use the Modified Date. These are the ones that I've worked with today. These are the ones I haven't worked with for a while. Let's bring it back again to Tables and Related Views.
And you also have Filter By Group. Now, if I just want to see everything related to the Customers table, I can filter, and now I just see the Customers Ttable and everything related to that, or the SalesReps table. Let's click on the arrow one more time, and come back to All Tables, and we can see everything. And because it's the most organized, let's bring it back to Object Type. Because the Navigation Pane is so flexible, you can organize it any which way you want, depending on your task at hand.
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.