Access 2007 training courses: Chapter 1: Get familiar with Access

Confused about whether to use Access or Excel? Learn how to choose the right program for your needs. Don’t have the 2007 Office release? You can download a free 60-day trial or buy it now.

GOALS After completing this course you will be able to: Choose the right program — Microsoft Office Access 2007 or Microsoft Office Excel 2007. Know whether to use a relational or flat data structure.

ABOUT THIS COURSE This course includes: One self-paced lesson. A short test at the end of each lesson; tests are not scored. A Quick Reference Card you can take away from the course. Links in the Quick Reference Card take you to information about getting started with both programs.

AUDIO TEXT Confused about when to use Access or Excel? That's understandable. On the surface, both programs look alike. After all, they store data, and you can enter that data in a grid of cells, right? So how do you choose between the two? One way is to answer a few simple questions about how you want to organize your data, and about related issues such as the amount of data you want to store and manage. Your answers to those questions can help you get more done in less time, so keep an open mind! To learn more about this course, read the text in Goals and About this course, or look at the table of contents. Then click Next to start the first lesson.

BEFORE YOU BEGIN You'll need a bit of experience with Excel, an open mind, and a willingness to try something new.

Top 10 benefits of Word 2010

1 Discover an improved search and navigation experience. Locating the information you need is faster and easier in Word 2010. With the new and improved Find experience, you can now view a summary of search results in a single pane, and click to access any individual result. The improved Navigation Pane provides you a visual outline of your document so you can browse, sort, and find what you need quickly.

2 Work with others without having to wait your turn. Word 2010 redefines the way people can work together on a document. With co-authoring, you can edit papers and share ideas with others at the same time.1 You can also view the availability of others who are authoring a document with you and can easily initiate a conversation without leaving Word.2

3 Access and share your documents from virtually anywhere. Post your documents online and then access, view, and edit them from most any computer or your Windows Mobile-based smartphone.3 With Word 2010, you can take advantage of a best-in-class document experience across multiple locations and devices.

4 Add visual effects to your text. With Word 2010, you can apply formatting effects such as shadow, bevel, glow, and reflection to your document text as easily as applying bold or underline. You can spell-check text that uses visual effects, and add text effects to paragraph styles. Many of the same effects used for images are now available to both text and shapes, enabling you to seamlessly coordinate all of your content.

5 Turn your text into compelling diagrams. Word 2010 offers you more options to add visual impact to your documents. Choose from dozens of additional SmartArt® Graphics to build impressive diagrams just by typing a bulleted list. Use SmartArt to transform basic, bullet-point text into compelling visuals that better illustrate your ideas.

6 Add visual impact to your document. New picture-editing tools in Word 2010 enable you to add special picture effects without additional photo-editing software. You can easily adjust pictures with color saturation and temperature controls. You also get improved tools for easier and more precise cropping and image correction, to help you turn a simple document into a work of art.

7 Recover work you thought was lost. After working on that document for awhile, did you accidentally close it without saving? No problem. Word 2010 lets you recover draft versions of recently edited files as easily as opening any file, even if you never saved the document.

8 Transcend communication barriers. Word 2010 helps you work and communicate effectively across different languages.4 Translate a word, phrase, or document more easily than before. Set separate language settings for ScreenTips, Help content, and displays. And, get additional assistance for English as a second language with English text-to-speech playback.

9 Insert screenshots and handwriting into your documents. Capture and insert screenshots directly from Word 2010 to quickly and easily incorporate visual illustrations into your work. When you use a tablet-enabled device such as a Tablet PC or Wacom tablet, you get improved tools for formatting ink as easily as you format shapes.

10 Accomplish more with an enhanced user experience. Word 2010 simplifies how you access features. The new Microsoft Office Backstage™ view replaces the traditional File menu to let you save, share, print, and publish your documents with just a few clicks. With the improved Ribbon, you can access your favorite commands even more quickly by customizing tabs or creating your own to personalize the experience to your work style.

12 Ways to Make Sure Your Internet Marketing Really Works

Everyone loves the Internet, but not everyone is ready to buy. There can be a level of scepticism you may have to overcome and one way to do that is let them see your face. Use online video and you have an advantage over your competitors when dealing with customers.

Successful marketing is all about establishing a relationship; and that is so much easier when they can see and hear you. You may be very comfortable online, but some people are still sceptical about doing business with you over the Internet and you need to persuade them to trust you before they will buy from you.

These are my top 12 direct marketing principles you can use to make sure your Internet marketing really works for you:

1. History.

People want to know you are not going to disappear overnight so if you’ve been in business for any length of time then this will add credibility to you and your offers.

2. Statistics.

Use genuine statistics to give you more credibility by listing number of customers served, money saved, profits made, and so on.

3. Testimonials

I can’t overestimate the importance of these so get them from your Customers and Clients saying how you and/or your products have helped them. Get experts in your market to validate and endorse your products and services and if appropriate get celebrities who you either ‘rent’ for your marketing, feature at your events or use by association.

4. Demonstrations.

With the use of online video and ‘how To’ DVDs it is very ease to show a demonstration of your product both on and offline. You can even demo an ebook by printing it out and talking through what it contains live on screen. Camtasia is free software that lets you make a screen capture video where you can demonstrate your website talking though the sales letter or giving a demo of how easy it is to download your ebook. If you are in a market that isn’t really familiar with online buying this works really well.

What better proof that your product or service works than by showing an example of before and after. Many markets and products lend themselves to this treatment and it is very effective.

In our own business we use video to show how to confirm emails when signing up to our email lists, when demonstrating how to use our Membership site and examples of results in a number of our ebook markets.

5. Credentials.

What credentials do you have in your market? They don’t have to be academic, but can awards, accomplishments, membership to organisations that are relevant to your market. Both I and Neil Travers my business partner are CIPD qualified which is a training qualification we attained while working at the Bank.

This is ‘proof’ of our ability to run workshops that are designed to aid the learning and intake and retaining of information by attendees and gives us increased credibility in their eyes.

6. Publicity.

Reprints of articles about you in the press, or your articles being published in the media that lend weight to your credibility as the expert or authority in your market are highly valuable to you. Show your market that you are in demand, and have status as an expert.

7. Celebrity Spokesperson.

To be used with caution. It can be effective but can also backfire when the market remembers the celebrity and the advert, but not what it was advertising.

8. Guarantee.

If you can’t guarantee the product you’re selling then find something else to sell that you can guarantee. To really make your potential customers feel safe to buy from you you need to offer an ironclad guarantee.

9. Accessibility.

On your website have your full contact detail if possible as this will give a big boost to your potential customer confidence in you and your company. Using just an email contact is the worst and an email, phone and address the best.

Never give a PO Box as your address as it immediately makes people suspicious.

10. The Personal Touch.

Being visible in the business to your customers is a confidence booster for them. Make it personal so you are a real individual, anecdotes about you and your business, pictures and videos all make your customer more comfortable as if they have already met you.

11. Make A Damaging Admission.

No matter how good your product is it will have a disadvantage somewhere. Admit it up front and honestly comment on this fact.

Answer Questions and objections up front and when a customer asks them via email or the phone. People can call our office throughout the week and email at any time with questions and that makes them feel safe to buy from us.

12. Excess.

Use a combination of as many of the examples above in your marketing! What may seem like overkill to you may not be enough to overcome some people’s scepticism!

---

This article courtesy of SiteProNews.com

5 Tips for Joining Your First Social Media Site

Getting started on social media can often be deceptively simple – What’s the big deal? You sign up. – or intimidating – Why am I being asked for my date of birth? – or overwhelming – How do I find people to friend or follow?

In actuality there are official and unofficial rules. It is easier if you start out knowing what’s what, and this is probably especially important if you’re more of an introvert.

Let’s imagine you already use email, search for information on Google, and read blog posts. But you’ve never joined any social media sites. How do you start?

1. Decide how comfortable you are sharing information about yourself. And the corollary to this – how wide a sharing of this information are you willing to do.

If you’re a book author and want people to buy your book, it’s a good idea to decide that you will share personal (although not private) information to as wide an audience as possible. If you only want to connect online with former high school friends, your target audience is much smaller.

If sharing information makes you somewhat nervous, think about what it means to be personal as opposed to private. Personal is a good marketing book you just read that you can recommend to help others; private is a fight you had with your business partner over implementing the marketing steps recommended in the book.

2. Ask online savvy friends that, based on your goal, which popular site they would recommend you first join. (And do start with just one while getting your feet wet in this brave new world.)

• If your goal, for example, is to have a wide audience, then Twitter may be the best choice because of its “open to everyone” format. – If you only want to search for high school friends, then Facebook may be the best choice as you can confine your information to a very small circle and can search by name for those long-lost friends.


• If you want to make connections to help with a future job search, then LinkedIn, whose format is set up for such a process, may be the best choice for you.

3. Once you have chosen the site you’ll start on, do a Google search for information on effectively using that site. That’s right, before you ever sign up, read some blog posts that provide guidance on effectively using the site.

Now this isn’t a research project that serves as an excuse for postponing actually joining the site. Just learn a few of the basic “rules.” And if you do this step, you’ll be way ahead of most other people who start on social media without first doing any research.

And why not learn this on the site itself? Because most of these sites have inadequate information for newcomers or an abundance of information that overwhelms newcomers.

Plus, to encourage you to sign up, the site’s home page says something like: To join now just do this. And it’s only after you’ve provided your name, email, password, etc. that you’re left wondering “What do I do next?”

4. If you’re starting on a site that doesn’t require your real name, choose a username carefully. You want to think about seeing this name used all across cyberspace as lots of social media sites pull information from other social media sites (with your permission, of course).

You may initially think, for example, of choosing the name of your first book. But what happens when you write a second book? Or perhaps using the name of the book won’t work well for a site that is focused on a non-book arena.

Keep in mind that whatever you do on the Internet can live forever. So this choice of a username should be considered carefully and for continued use in the long-run. (Once you’ve established a good online reputation with one username you don’t want to start at square one again with a new username.)

5. Immediately post a photo of yourself – a headshot in which sunglasses and a baseball cap are not blocking people from totally seeing your eyes. (This does not have to be professional-photographer quality but should not be blurry.)

This photo should be one that will also work on social media sites you will join in the future because you want consistency across these sites. You want consistency to help people recognize and connect with you on more than one site. (The same for your username).

Keep in mind that the photos for Twitter are quite small. And even if you’re starting on Facebook, only include a headshot of yourself. Do not include other people and preferably not animals and other props.

By posting a good headshot of yourself you’re signaling that you’re interested in connecting with people – real people such as yourself – and you’ll be off to a good start on your first social media site.

Now that you’ve read these five tips for starting on your first social media site, what are you waiting for? Join the cyberspace social media community today.

---

This article courtesy of SiteProNews.com

Microsoft starting major improvements for Windows 8 soon

Microsoft starting major improvements for Windows 8 soonMicrosoft already entered the planning stages of Windows 8 last year in March when Windows 7 was still in Milestone 1. The Redmond company recently revealed in a job opening post for the Lead Software Development Engineer position that it will soon begin working on major improvements on Windows 8:

For the upcoming version of Windows, new critical features are being worked on including cluster support and support for one way replication. The core engine is also being reworked to provide dramatic performance improvements. We will also soon be starting major improvements for Windows 8 where we will be including innovative features which will revolutionize file access in branch offices

The following innovative features are some of the many features that we could be seeing in Windows 8:

* Distributed File System Replication (DFSR) service: A multi-master replication engine set up for folder synchronization across multiple servers. This may be something we will be seeing in Windows 8 Server.
* Major improvements in BranchCache: BranchCache was a new feature developed in Windows 7. Basically when data from an intranet website or file server is accessed, it caches those files locally so the next user can access them more quickly. Major improvements can be expected for BranchCache.

These were some of Microsoft’s comments on the upcoming features:

DFSR is Microsoft’s premier file replication engine and is an integral part of our branch office strategy and File Server role. It can scale to thousands of servers and replicate hundreds of terabytes of data. We have shipped the technology that powers file sharing in Windows Live Messenger, Windows Meeting Spaces (Vista) and Branch Office replication in Windows Server 2008 which has strong customer deployment. DFSR technology saves MS-IT and our customers more than 80% WAN bandwidth by using advanced On-The-Wire differential compression,” the software giant adds in the job posting.

Windows 8 to be 128-bit compatible?

As we’ve known for some time, Microsoft had already begun work on Windows 8 before Windows 7 was completed. The reason being that different teams work on different aspects of the operating system, which is why Microsoft was able to do this. Microsoft previously shed some light on what we can see in Windows 8 through a job description.

It appears though, that one specific Microsoft employee was not too careful with their LinkedIn profile, and had accidentally leaked some interesting details regarding Windows 8. According to his LinkedIn profile, which seems to have had many of its details removed, Robert Murdon has been working at Microsoft since January 2002. Windows 8 News managed to catch this on the Microsoft employee’s LinkedIn profile before it disappeared:

“Robert Morgan is working to get IA-128 working backwards with full binary compatibility on the existing IA-64 instructions in the hardware simulation to work for Windows 8 and definitely Windows 9.”

“Robert Morgan is using Hestia (custom software package) for experimenting with the processor for scientific analysis and 3D graphics. Error: Memory Latency? Always gotta be a challenge barrier, it’s gotta be a bug in Hestia. right?!”

“Robert Morgan is frustrated with process standards and regulations! Delays Delays!”

Murdon seems certain that we will see 128-bit compatibility with Windows 9, while it appears that whether we will see it in Windows 8 or not is still uncertain. Coincidentally, many do believe that Windows 7 will be Microsoft’s last 32-bit OS. So could this mean we will see Windows 8 come in 64-bit and 128-bit flavors? Let us know what you think in the comments.

Video SEO Exposes A Neglected Path To Higher Search Rankings

Video SEO is an underutilized search engine marketing strategy. Even as videos continue to gain significant traction in the search engines’ natural listings, most companies either ignore them, or remain completely unaware of their potency. That oversight represents a valuable edge your company can use to leapfrog your competitors in the organic rankings.

The strategy blends traditional search optimization tactics with a relatively new platform. With the rise of YouTube, Revver, Blip, and similar video sites, consumption patterns have driven the search engines to provide these sites with greater ranking authority. As long as your primary objective is clearly established, a video SEO campaign can have a dramatic effect on your exposure in Bing, Google and Yahoo.

In this article, we’ll explain why you should integrate video SEO into your current search marketing strategy. We will also provide a few ingredients that will help you avoid potential pitfalls along the way. Last, you will learn what to look out for when choosing a video SEO company that can drive traffic and conversions.

How Video SEO Improves Your Search Exposure

Before Google released their Universal Search platform in May 2007, their natural listings were dominated by text-based pages. Videos were rare in the top positions. Universal Search changed the way Google displayed their primary index. Google, Yahoo, and Bing now include entries from their respective video search platforms. What’s more, popular video-sharing sites have been given higher ranking authority and increased link weight (we’ll describe this latter point in a moment).

Video SEO gives you greater exposure in the search engines through two levers. First, it caters to the algorithm used for Universal Search. By syndicating your videos to authoritative video-sharing sites, you’ll enjoy more exposure through their increased ranking authority. In effect, those sites will rank higher, drawing more people to your videos.

Second, videos that are placed on your site (as opposed to syndicating them) attract links – both directly and indirectly. As your videos gain popularity, direct links will naturally build, pointing to the pages on your site that host the videos. Indirect links will point from other sites whose owners have embedded your videos. As a result, your inbound link profile will continue to grow and strengthen, lifting your site higher within the search engines’ organic listings.

3 SEO Video Tips To Capture Higher Search Positions

Your video SEO campaign can only be effective if you recognize the limitations of the search engines. First, their algorithms cannot read lips. In order to rank for your target keywords, they must be available to the search engines’ spiders in text form. If you’re placing videos on your site, optimize your titles and surrounding text, and include an edited transcript of the video. If you’re syndicating them, optimize your external titles and tags.

Second, focus on inbound links. An effective video SEO campaign relies on contextually related links pointing from a wide breadth of sites. Videos that spark a groundswell of attention – whether through entertainment, information, or controversy – can achieve this easily.

Third, integrate a social media sharing component. You want viewers to share your videos with their friends on Facebook. You want them to “Tweet” about your videos on Twitter. You want them to bookmark your videos on StumbleUpon, Digg and Delicious. These social media sites can form the backbone of your video SEO campaign, driving waves of inbound links to your site.

Key Factors In Choosing A Video SEO Company

Traditional search optimization is a mature strategy. SEO specialists have honed their craft for more than a decade. By contrast, video SEO is still an evolving science. Even though it leverages the core tenets of a traditional SEO campaign, the rise of social media and video-sharing sites have infused video SEO with enormous complexity. Hiring a video SEO company removes the need to keep up with the roiling landscape. The key is using the right criteria to identify a proficient firm.

A professional video SEO company should have an established track record that shows a keen grasp of the search engines’ organic algorithms. That track record should also demonstrate an ability to evolve as the algorithms change. Many search optimization experts were completely unprepared for the debut of Universal Search. By extension, so too, were their clients.

Leveraging Video SEO For More Traffic And Higher Conversions

A carefully executed video SEO campaign can sharply increase your exposure within the search engine’s natural listings. When implemented as a key component of a multi-pronged search marketing campaign, it can drive more targeted traffic to your site. Targeted traffic translates into higher conversions. If you are not yet utilizing video SEO for your site, your current organic rankings may be more vulnerable than you realize.

---

This article courtesy of SiteProNews.com