Lesson11.3.Importing Objects from Another Access Database


Lesson 11.3. Importing Objects from Another Access Database

Figure 11-8. The Import Objects dialog box


Not only does the Import command insert information from other file formats, it also lets you import objects from other Microsoft Access databases. You can import tables, forms, reports, pages, queries, macros, and VBA modules from one Access database into another Access database. Inserting objects from another Access database saves you lots of time: Instead of creating a new object (such as a form) from scratch, you can import an object from another database and then modify it as needed.

In this lesson you will learn how to import an object from another Microsoft Access database.

  1. Select File Tip: Another way to import a database object is to right-click any empty area of the Database window and select Import from the shortcut menu.


    The Import dialog box appears. Here you need to specify the Microsoft Access database that contains the object(s) you want to import into the current database.

  2. Browse to your Practice folder and double-click the Promotions database file.

    The Import Objects dialog box appears, as shown in Figure 11-8. The Import Objects dialog box looks a lot like the Database windowyou click the tab that corresponds to the type of database object you want to import.

    You can insert any type of database objectwe'll try inserting a form.

  3. Click the Forms tab.

    Access displays all the forms in the Promotions database.

  4. Click the frmPromotion form.

    You can import more than one database object at a timesimply click the appropriate object tab(s) and select the database objects you want to select. When you're finished, here's what to do:

  5. Click OK.

    Access imports the frmPromotion form into the current database.

QUICK REFERENCE

TO IMPORT AN OBJECT FROM ANOTHER ACCESS DATABASE:

  1. IN THE DATABASE WINDOW, SELECT FILE

    BROWSE TO THE APPROPRIATE DRIVE AND/OR FOLDER AND DOUBLE-CLICK THE DATABASE THAT CONTAINS THE OBJECT(S) YOU WANT TO IMPORT.

  2. SELECT THE DATABASE OBJECT(S) YOU WANT TO IMPORT AND CLICK OK.




CustomGuide Inc - Access 2003 Personal Trainer
Access 2003 Personal Trainer (Personal Trainer (OReilly))
ISBN: 0596009372
EAN: 2147483647
Year: 2005
Pages: 209

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net