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 · 90582 Viewers
80 Video lessons · 137947 Viewers
59 Video lessons · 56691 Viewers
52 Video lessons · 70307 Viewers
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.