Watching:

Creating new fields with field templates


show more Creating new fields with field templates provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Creating new fields with field templates

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.

Creating new fields with field templates
Video duration: 2m 9s 3h 43m Intermediate

Viewers:

Creating new fields with field templates provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...