Unofficial Access Stuff

Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Host your Web site with PureHost!

Tuesday, March 15, 2016 – Permalink –

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,

Choose File>Open from the menu bar

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

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 access
Labels: General, Reference, Shortcuts, Tips, Tutorials

<Doug Klippert@ 3:31 AM

Comments: Post a Comment