Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 64684 Viewers
80 Video lessons · 124307 Viewers
52 Video lessons · 60246 Viewers
59 Video lessons · 46077 Viewers