Office 2007 Tips & Tricks - June 5, 2008
|
|
|
|
Learn How to Create Relationships and Master Them in Access 2007
 Building
tables in Access 2007 is fairly simple. Creating relationships between these
tables is a different story.
This is the part that most of us get confused with because Access relationships
(as any other relationships) can get quite complicated.
And let's face it, we all get a little confused when it comes to Access. But
don't worry, help is on the way!
Today I'm giving you step-by-step instructions on creating basic relationships
in Access 2007. Keep in mind that there is much more you can do, and that what's
presented here is just the beginning. Once you have the basics, don't be afraid
to start exploring.
For this example, I am using an already existing database with tables already
created, primary keys assigned, and data types selected.
Nothing however, was setup when it comes to relationships so you should be able
to apply these steps in your situation. Alright, let’s get started.
Get ready to Learn How to Create Relationships and Master Them in Access 2007
|
|
| New Release: Microsoft Access 2007 Training Videos
|
|
| Take Advantage of Special Loyalty Pricing --
Until June 13th Only
|
|
2 Easy Ways to Improve Your Productivity Using Outlook 2007
 People
say that it's the little things that make all the difference.
The same holds true when using Microsoft Outlook. With just a few simple changes
you can increase your productivity in Outlook like you never thought was
possible.
Do you work in a big office where you're part of a large mail group? Does it
always seem that you're getting emails that don’t pertain to you?
Well I'm going to show you how to prioritize those emails so that you only get
the emails that are meant for you.
The next improvement that I'll talk about involves a workaround to allow Outlook
to accept certain file types as safe. This is handy for coworkers who need to
pass a certain file type back and forth over Outlook.
It basically makes sure that you get all of the attachments that your coworkers
are sending to you and that your coworkers are getting the ones you send them.
This article is in the spirit of taking a few hours on a Sunday afternoon and
cleaning your house from top to bottom after a long winter. It takes you until
you're done to realize how out of place and unorganized things were.
That's why today I want you to get out your virtual mop and bucket to do a
little spring cleaning with your Microsoft Outlook.
Get more done with these 2 Easy Ways to Improve Your Productivity Using Outlook 2007
|
|
Check Out Our Best Sellers:
Exchange 2007 | VMware ESX | SharePoint 2007 | Cisco CCNA | Windows Vista |
|
Merging for Dummies: Creating Address Labels in Word 2007
If
you're creating invitations for a wedding or another big event, you think it's
no big deal ... it's only a few hundred, you can knock that out in a couple of
hours right? Type them up in Word, print them out and you’re done.
A couple of months later, you've got another job ahead of you: the thank you
cards. Hopefully you saved the Word doc that you slaved over last time ...
formatting it and making it look just right.
But even if you did save your doc, you've still got plenty of work ahead of you
... going through all of the names one by one, checking them off, making changes
...
it takes some time.
The solution? An Excel spreadsheet that allows you to very easily sort the list,
make any necessary changes and have your labels ready in no time.
Working with an Excel spreadsheet makes the whole process of creating address
labels — as well as other things, such as personalized letters, thank you cards,
etc. — less time consuming and very easy.
Knowing how to merge Excel and Word documents can come in very handy in many
situations. So today I'm going to show you a very easy but very useful time
saver — how to create address labels in Word 2007 using an Excel spreadsheet.
Continue reading Merging for Dummies: Creating Address Labels in Word 2007
|
|
Browse Training by Topic:
Cisco | CompTIA | Microsoft | VMware | Windows Server | Wireless |
|
Get 'Em While They're Hot! New Cisco Videos -- At No Cost To You
 Our last newsletter announced new CCNA videos covering Advanced Switching that have been added to our Free Training Videos page.
Now that you've mastered switching, take a look at three new videos from our best selling Cisco CCNA training focusing on Static Routing and RIP.
These videos are available exclusively to our Newsletter Subscribers so get 'em while they’re hot!
And make sure to come back for more -- we will be adding parts 4 through 6 in the next few days.
Watch the New Cisco CCNA Static Routing and RIP Videos Now
|
|
