Tuesday, March 15, 2016

Automatically set up a database

Link in a snap

When you're creating a new database that will link to data that isn't in an Access format, you can speed up the setup process.

Rather than creating a new database and then using the File>Get External Data>Link Tables,

  1. Choose File>Open from the menu bar

  2. Select the appropriate data format from the Files Of Type dropdown list

  3. Open the file as you would any Access database
Access will automatically create an MDB file with the same name as the data source you selected and will set up links to the data.

See all Topics

No comments: