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.
When you create a new table, you need to define what type of data each field will hold. There are a variety of ways to this, both as you build and on the fly afterwards. Let's create a new table by going to the Create Tab, then clicking in the Table button. If I click on the Click to Add in the field header, it drops down a list of field types and I can choose the appropriate one. I will choose Text. As soon as I do that, it converts the placeholder into a new field where I enter its name. I will type LastName. When I press Enter or Tab on my keyboard, the next new field automatically drops down that same data types list, ready for me to choose.
This saves me a click every time. I will select Text again and type FirstName. I am going to click underneath the Click to Add for my next demo. I can also go up to the Table tools>Fields Ribbon and pick a data type from up here. I will choose Currency and it will add a new field, and I will call it Salary. I will go back to Salary. If I choose an incorrect data type, I can also change it right here from this dropdown menu. I will click underneath Click to Add again. If I want to refine my data type choice even further, try this More Fields button.
This will not only give you a date field, for example, it will also allow you to select one that already has the specific properties you would set later. For example, I can set a date field that would include a medium date format, and I will title this HireDate. When you are in Design mode, you have a few more data type selection options. I will go to the Home Ribbon and change the view to design. It will ask me to save my table and I will call this Employees. Now that I am here, I will click underneath HireDate, type in Email.
Tab over to the data type, drop it down and choose Hyperlink. And last, Tab or click to a new row. I will give this the field name Notes. And when I tab to the data type, all I have to do is start typing and this will auto-fill for me. All I have to do is type the letter M and Memo appears automatically. You will probably have a favorite of these five techniques that you will use most often, but being able to use the one most handy at the moment will make you a power user.
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.