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.
Instead of having to create an expression, in a query or report, every time you want to do a calculation, you can now create a field right in your table that will perform calculations based on your data. Let's make one. I'll click on the Create tab and over here to Table. First, I'm going to put in our Company Name and I'm going to add a Currency field for the total that did owe us and I'll create another field for how much they've paid. Now, the last field I want is Amount Due.
So, what I'll do is go up to More Fields and come down here to Calculated Field and over to the right for Currency and my calculation is the Total Amount minus the Amount Paid and I'll name it Total Due. Now, when I fill this in, any amount that they owe us, note that because it's currency, it fills in dollar sign and the commas and the decimals automatically.
They've paid us $2000 and it instantly says that they owe us $8000. Please note however, that this does not work with date fields, because the data would be constantly changing at every moment. So you can see that the new Calculation data type will make life much easier with answers to your mathematical formulas available at all times.
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.