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 customize most of your database tables with alternative formatting you can set Access' options so many of these preferences are set by default. Let's start by opening up a new blank database. I'll go to the File tab and down to New. I'll change by Database name to the defaults and press Create. Let's go set Access' options. Go back to the red File tab and then go down to the bottom and choose Options. Go to the third button down for Datasheet.
Here we can set our default Gridlines. Tables by default have both Horizontal and Vertical Gridlines. I am going to go ahead and uncheck Vertical, so that all I have are lines going across. The Default cell effect is Flat, but you could also do a Raised and Sunken. Now be aware that Raised and Sunken will actually do away with the horizontal and vertical lines. Every cell is going to have that effect applied. I'll go ahead and make this Raised. By default, every Table has a 1 inch Column, but if I'd like that to be a little larger I'll change that to 1.5.
The Default font is set to size 11. I'll go ahead and increase that to 12. I can choose different font Weights as well; make them lighter or darker. You could also set the Default font to be Underlined or Italicized. I'll go ahead and make everything Italicized. Now I'll click OK. I am going to close this Table and don't save it. And I am going to go up to the Create ribbon and create a new Table. This will have all my new effects. My font size is a little larger and a little darker and my cells have a very subtle Raised effect to them.
Now do be aware that by changing these settings all the new Tables you'll create will share the formatting so that you won't have to set each one up separately, but this will also carry over to all new databases as well. When you want your databases to go back to the default, you'll need to go back to File and to the Options and reset them again.
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.