To save time having to navigate folders, it helps to assign a folder as your default file location.
Click the Office Button.
Choose Access Options.
In the left panel of the Access Options Box, Choose Popular.
Next to default database folder, click the Browse button.
Browse to your default folder.
Click OK twice.
Close Access 2007. When you reopen your database, your default location will be selected.
Access 2007 - Avoiding Security Warnings
A student in my Access Database Design Bootcamp recently asked how to get rid of the security warnings when they opened an Access database.
One way to get rid of the security warnings is to place the folder where your database is stored as a trusted location.
Click the Office Button.
Choose Access Options.
Click Trust Center.
Click the Trust Center Settings box.
Click Trusted Locations in the panel on the left hand side of the screen.
Click the Add New Location button.
Browse and select the folder where your databases are stored.
Click OK.
Check the box that says Subfolders of this location are also trusted.
Keep clicking OK until you are back on the Access window.
Exit Access 2007.
One way to get rid of the security warnings is to place the folder where your database is stored as a trusted location.
Click the Office Button.
Choose Access Options.
Click Trust Center.
Click the Trust Center Settings box.
Click Trusted Locations in the panel on the left hand side of the screen.
Click the Add New Location button.
Browse and select the folder where your databases are stored.
Click OK.
Check the box that says Subfolders of this location are also trusted.
Keep clicking OK until you are back on the Access window.
Exit Access 2007.
Outlook 2007 - Increase Efficiency with Quick Parts
In a previous blog post,
Automate your Standard Emails with Outlook Signatures, I explored one of my favorite tips of all time - the ability to use Outlook 2003 create standard email blurbs as signature files, and pop one or more of the signature files in an email when needed. I used this all of the time, to insert class confirmation and directions, my contact information, and much more.
With Outlook 2007, you can only use one signature file per email. This really put a cramp in my style as I was accustomed to inserting multiple signature files in one email.
Instead, Outlook 2007 has Quick Parts. So here are the simple instructions for bypassing Outlook 2007's signature file restriction.
Create and Save your QuickParts Message.
Use your Quick Parts Message
Automate your Standard Emails with Outlook Signatures, I explored one of my favorite tips of all time - the ability to use Outlook 2003 create standard email blurbs as signature files, and pop one or more of the signature files in an email when needed. I used this all of the time, to insert class confirmation and directions, my contact information, and much more.
With Outlook 2007, you can only use one signature file per email. This really put a cramp in my style as I was accustomed to inserting multiple signature files in one email.
Instead, Outlook 2007 has Quick Parts. So here are the simple instructions for bypassing Outlook 2007's signature file restriction.
Create and Save your QuickParts Message.
- Start a new email message.
- Type the text you want to use (ex., directions to your office).
- Click the Insert tab, and then Click Quick Parts.
- Select Save Selection to Quick Part Gallery.
Use your Quick Parts Message
- Start the email you want to type.
- Click Quick Parts under the Insert Tab.
- The Quick Parts you've saved will be on a list. Select the first one you want to use.
- Repeat the process until you've selected all the QuickParts you want to use in your email.
- Address and send your message.
Subscribe to:
Posts (Atom)