Posts Tagged ‘open’

Open Multiple Files at Once in MS Office

Friday, February 27th, 2009

I am a multi-tasker. I almost always have several applications open at any one time, for instance, when I am creating my newsletter! So, in the interest of saving time, I usually open all of these documents, spreadsheets, etc. all at once.

Follow the steps below to learn how:

  1. Click on File | Open, or in 2007, click the Office button and Open. You can also use the keyboard shortcut CTRL + O.
  2. Find the files you would like to open.
  3. If the files are contiguous, click on the first one to highlight it and then depress your Shift key and while still holding it down, click on the last item in your list.
  4. If the files are NOT contiguous, simply click on the first one and then depress your CTRL key and keep it held down while you select your other files.
  5. Once you have selected your files, click on Open.

NOTE: These files must all reside in the same folder for this method to work.

Tags: , , , , , , , , , ,
Posted in Microsoft Office, Office Productivity | No Comments »

Working with Database Files in MS Access

Thursday, February 5th, 2009

When I first started using MS Access and downloading databases I was really confounded when it came to renaming the database.  When I tried to use File | Save As, it came up with something other than what I expected or wanted!

Well now I have learned how to accomplish this simple task (it’s always simple once you figure it out, isn’t it?) and I will share my knowledge with you.

All you really need to do is change the name of the .mdb file. You can do this from My Computer or Windows Explorer. You can even do it from Access itself!

Follow the steps below to learn how:

  1. Close your database file if it is open.
  2. Click on File | Open.
  3. Navigate to the File in the open dialog box.
  4. Right-click the file and select Rename.
  5. Type a new name for your database.
  6. Click Enter.

Before you set out to rename your database, remember that MS Access does not automatically update links, so if any other database links to a table in the database whose name you would like to change, you will have to open that other database and redo the links. You would, of course, use the Linked Table Manager to accomplish this.

Tags: , , , , , , , , , ,
Posted in Access 2003, Microsoft Office, MS Access | No Comments »