Join Alicia Katz Pollock for an in-depth discussion in this video Using QuickStart fields, part of Access 2010 New Features.
With Access 2010's new Quick Start fields, commonly used table fields can also…be created in pre-formatted, coordinated sets.…Click on Create and then open up the new table and now look under the…More Fields button.…In addition to the data types that you see above, you also have additional ones…including Rich Text, Attachments and Hyperlinks, multiple number formatting…including Euros, six different date and time auto formats. There are even four…different sets for Yes or No buttons now.…
Now below that you'll find the Quick Start field groups.…For example, let's add an Address Quick Start group and look. It added Address,…City, State, Zip Postal and Country.…I'll click over here to add some more.…I'm going to go up to More Fields and this time let's do Phone numbers. Check this out.…It just did, one, two, three, four, phone number fields all at once.…Here we additionally have some other useful practical ones like Payment Types.…This will actually give you a drop-down, showing whether they pay with Cash,…
- 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.