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.
If you're working on a Tables Datasheet View it can be handy to see instant calculations at the bottom of my Table. I have opened my Orders Table, and up on the Home ribbon, about the middle, there is a stigma with the word Totals on it, I'll click on it and a new row appears at the bottom of my data. Note that it is not part of my Table; it stays at the bottom of my screen as I scroll. When I click in the cell at the bottom of each column a dropdown arrow appears, click on it and you'll see a number of choices appropriate to that type of data.
For our dates I can find the Average date of the order, the Count of how many orders there were, Maximum will give me the most recent date, Minimum would give me my earliest date. I'll choose Minimum-- and my first order was placed in January 10, 2006. The dropdown underneath the Customer column only allows me to Count how many orders there are, and there are 47. Underneath Product, I also only have those same choices. My Count is again, 47. Now under the Quantity it gets a little more interesting, when I drop down the arrow I can Sum up the number of bottles that I have sold, I can find the Average quantity in all my orders, again, I can Count how many orders that were, I can find my largest order or find my smallest order.
Standard Deviation and Variants are advanced statistics. Standard Deviation would find the median order and tells me how far off of that average each of my orders are and Variance squares that number. If I click on Minimum, and scroll through my data, it will also put in boldface any of the orders that have that quantity. What's also nice is that if I turn off my Totals and then turn again the settings that I had chosen previously still remain.
Having instant calculations at my fingertips prevents me from having to run Queries or create Reports in order to do basic statistical analysis.
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.