Improving structure with the table tools


show more Improving structure with the table tools provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 New Features show less
please wait ...

Improving structure with the table tools

Table and field settings that were once buried away are now right up front with Access 2010's new Table Tools Ribbons. Not only will this save you time, but making proper use of the Tables field properties will improve the structure of your database. First, let's click on the Create tab and then click on Tables to create a new table. Look around the right and you'll see contextual table tabs, Fields and Table. When I'm creating a table, I now no longer have to go into Design view. I can do my properties right here from the Datasheet view. If I am working from the Datasheet view, I no longer have to add the field, enter the name and then specify the data type.

Now I can add specific data fields with one click and all I have to do is name it. I'll click right here, I'll tell it I want it to be a Text field, and I'll type in the name of my field and when I hit Tab, the next one automatically opens up and is ready for me. Now I can also pick my field types from up ...

Improving structure with the table tools
Video duration: 4m 21s 36m 35s Intermediate

Viewers:

Improving structure with the table tools provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 New Features

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