New Feature: Playlist Center! Pick a topic and let our playlists guide the way.

Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Working with Application Parts

From: Access 2010 New Features

Video: Working with Application Parts

One of the most useful features in Access 2010 is the new Application Parts, allowing you to save time and effort by building your databases using pre-built components. Click on the Create Ribbon and then the Applications Parts to see the gallery of pre-made forms and other objects as well. I am going to go ahead and click on Contacts and that's going to create a table complete with name fields, address fields and phone number fields, and not only that. It also included associated queries, forms and reports.

Working with Application Parts

One of the most useful features in Access 2010 is the new Application Parts, allowing you to save time and effort by building your databases using pre-built components. Click on the Create Ribbon and then the Applications Parts to see the gallery of pre-made forms and other objects as well. I am going to go ahead and click on Contacts and that's going to create a table complete with name fields, address fields and phone number fields, and not only that. It also included associated queries, forms and reports.

You can even save your own objects as Application Parts for future reuse. To do that, first strip out all the objects that you don't want to see in the Application Part, and then go to the Backstage view File tab and do a Save and Publish and come over here to Template. This sets all the parameters for your Application Part. First, name it. The Description is the tooltips that will show up if you hover your mouse over it.

Right now it defaults to the Category of User Templates but you can even erase this and create your own section in your Application Parts. If you have your own custom icon, you can specify it right here. Now, an Instantiation Form allows you to pick a form in your part that'll be run one time after the part is inserted and then will be deleted when closed. This can be useful as a splash screen, or if you have a more complicated part that requires some setup before it can be used, you can put the instructions there.

I'll click on Application Part to specify that will show in the Application Part Gallery. That also woke up the Primary Table field. If you have more than one table, this will show as your default. If you'd like, you can even include already entered data with your template. And I'll click OK to finish. Now, when I click on Application Parts, my new Customers table is right here and I can also find it in the backstage view under the File tab, under New, under My templates.

It will show there as well. So you can see that by using Application Parts, you can save precious time in setting up commonly used forms, tables, reports and more.

Show transcript

This video is part of

Image for Access 2010 New Features
Access 2010 New Features

18 video lessons · 6656 viewers

Alicia Katz Pollock
Author

 

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold

Are you sure you want to delete this note?

No

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.