Join Alicia Katz Pollock for an in-depth discussion in this video Improving structure with the table tools, part of Access 2010 New Features.
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 here.…The next field I want is Date and Time, so I could do it from here, or when I…
- Working with Application Parts
- Implementing the Table Tools ribbon
- Using Quick Start and calculated fields
- Designing with Layout View formatting tools
- Taking advantage of enhancements to the Conditional Formatting feature
- Automating with macros
- Working with external data
- Integrating SharePoint publishing
Skill Level Intermediate
Q: My macro isn't running correctly. I followed along with the author and I'm not receiving an error message, but the actions are performed correctly.
A: There are several possible reasons why a macro would malfunction. Make sure that the macro is written correctly. Capitalization and punctuation matters. Also make sure to click in all the same places when recording the macro. With enough practice, building macros will become more routine, and spotting errors will becoming easier.