Access Database SQL, Friend or Foe?

comments Comments Off
By Susan, July 22, 2009 9:17 pm

In my ever continuing need to learn and truly master the monster that many think Office 2007 is, I am working on developing my skills more with Access 2007.

I’ve found that most large-scale databases use the Structured Query Language (SQL) to facilitate user and administrator interactions. The language uses a flexible interface for databases of all shapes and sizes, but many people don’t know that you can view and edit the SQL statements that drive every Microsoft Access database query.

When using SQL statements in Microsoft access, you can generally use any SQL syntax. However, there are just a few exceptions to keep in mind:

You can’t use the DISTINCT clause within an aggregate function
You can’t use the LIMIT TO xx ROWS clause
The single character wildcard in Access is ? rather than _.
The zero or more character wildcard in Access is * rather than %

Here is a just brief overview I have learned to edit your SQL statements:

1.Start Microsoft Access 2007.
2.Open the database containing the query you wish to view or edit.
3.Locate the query in Object Explorer and double-click on it to run the query.
4.Pull down the View menu in the upper left corner of the ribbon.
5.Select SQL view. This will display the SQL statement corresponding to the query.
6.Make any edits you wish to the SQL statement in the query tab.
7.Click the Save icon to save your work.

Do you really need to know SQL? It’s not truly necessarily. If you’re comfortable using the front end tools, they might be more than enough to meet your needs. However, if you work with databases often, you should at least have a passing familiarity with this incredibly important language that forms the foundation of relational databases. Take some courses at a local community colleges or go online to Microsoft and search for their tutorials – they offer a wealth of information and support for their products.

I think my next task to tackle will be working with Macro’s and finding out why they fail more often than not.

WHERE are the 2003 Word Options in 2007?

comments Comments Off
By Susan, June 12, 2009 8:29 pm

I don’t know how many times I have fought with Office 2007, more times than I care to admit and what happened to the times when Microsoft put out those lengthy books to walk you through those new programs you spent your precious money on? You don’t get these manuals any longer, most of the time, you can find a smaller version of the manuals included within the files on the CD, or you can walk through the tours in the actual program itself, but who has time to do that? Gone are the days when you could pull the manual from your bookshelf when you needed to look up a certain resolution to a problem that you were having. Its enough to reduce the most seasoned Microsoft Office user to tears.

My family is included in those tears – well, no, not tears, but I am too polite to repeat the words I have heard coming out of their mouths as they try to navigate Office 2007. This has reinforced my decision to continue working on my book of Office Tutorials.

This one centers around all those functions that used to be so readily available in Word, that are now hidden. Why Microsoft found that useful and productive is beyond me, but there you go.

So where are those options? They are still there, you just have to know where to find them. Honest. With Word open, right click on any blank space at the top of the toolbar, next to the tabs would work and select “Customize Quick Access Toolbar”

Screenshot 1

Screenshot 1

This will open a dialog box for all of your Word Options – for now, we will focus on the commands and how to get those within your viewable reach.

Screenshot2

Screenshot2

Instead of selecting the most popular commands in the drop down box, select all commands for a more complete list of the commands, as the command you want may not be listed among the most popular. For the purpose of this tutorial, it isn’t listed among those popular command.

So, what we need is to place an option to email your word document, not as an attachment, but in the body of the email itself – that option used to be listed right at the top of the toolbar – but it isn’t so you will find it among the  all commands.

Scroll down until you find “Send to Email Recipient” and add that command to your toolbar. Now you can send your word document from Word directly to your mail program like Outlook or Outlook Express. The icon will be listed in the top right end of your toolbar.

This example is just one of the many functions that you can find in Word Options. But at least now you know where to find them.

Does the New Office 2007 Have You Confused?

comments Comments Off
By Susan, April 8, 2009 10:42 pm

It does many people. Thankfully, Microsoft expected this and created several guides to help you find your way around the new environments.

For Word, you can download the guide here. This visual, interactive reference guide helps you find your favorite Microsoft Office Word 2003 commands in the new 2007 interface.

For Excel, you can download the guide here. If you are wondering where your favorite Excel 2003 commands are located in the new Excel 2007 interface, or just want to explore the rich, new design with a little guidance they’ve developed a visual, interactive reference guide to help you quickly learn where things are.

More to be updated soon.

Use Word Spell Checker to Save from Embarrasing Spelling Errors

By Susan, July 25, 2007 2:13 pm

Word’s spell checker can help you cut down on spelling errors, but what if you type the word right, and it should be write? Until Word 2007, the spell checker would have ignored the error.

For those of us who consistently type to for too, there for their, or site for sight, Word 2007 has a new feature that not only checks for the correct spelling but also for the correct context. Follow these steps to activate the contextual spell checker:

1. Click the Office Button.

2. Click the Word Options button.

3. Click Proofing.

4. In the When Correcting Spelling And Grammar In Word section, select the Use Contextual Spelling check box.

5. Click OK.

If you type Now is the time for all good people to come to the aid of there country, Word will underline there in blue. You can then right-click the word to select the correct spelling: their.

10 common e-mail habits that waste time and cause problems

By Susan, July 11, 2007 2:48 pm

1. Vague or nonexistent subject line

Professor Woodward, who taught me contracts last year at Temple University Beasley School of Law, gave me one of the most useful pieces of advice I have ever received. “When arguing a case,” he often said, “make it easy for the judge to rule in your favor.”
Apply that same principle to e-mail. That is, make it easy for recipients to know what your message is about. If you’re like most people, you have an in-basket that summarizes your incoming messages, probably by date, sender, and subject. Don’t you love it when you can get the information you need simply from the subject line? The sender has made it easy for you and has saved you time.

On the other hand, how often have you received an e-mail without a subject or one that’s labeled, for example, “Phone number you requested.” Why couldn’t the sender have said, right in the subject line, “The phone number is xxx-xxx-xxxx”?

When sending an e-mail that concerns a particular person, give details in the subject line, along with the name. For example, if Joe Brown has been promoted, make your subject line “Joe Brown has been promoted.” Do not use only the name as the subject. If you send out an e-mail with just the subject “Joe Brown,” recipients may mistakenly believe that Mr. Brown has passed on.

In the event you do need to transmit such sad news, be explicit. For example, say “Joe Brown RIP” or “Passing of Joe Brown” or “Joe Brown [year of birth] – [year of death].”

2. Changing the topic without changing the subject

Have you ever read an advertisement for an item that’s on sale, then gone to the store only to discover that that item is sold out? By law, the store has to give you a rain check, because of abuses in the past. In the old days, the store would simply try to sell you something else instead, a practice known as “bait and switch.”

E-mail users employ bait and switch all too often, usually out of laziness. For example, you send a note to a co-worker about subject 1. That co-worker later needs to send a note to you on subject 2. However, instead of creating a new note and labeling it “subject 2,” he or she simply replies to you, discusses subject 2, but keeps the subject line as “subject 1.” Annoying, isn’t it? When you send e-mail, make sure the subject line matches the actual subject. If you’re going to send a note via a reply, change the subject line to match the actual subject.

A few months ago, during a period of really cold weather, a neighbor sent an e-mail to all the residents of our development regarding a minor matter, such as a neighborhood telephone directory, and titled it “neighborhood directory.” A half hour later, I received a reply-to-all message from another neighbor with the subject “Re: neighborhood directory.” When I accidentally clicked on that message, I read that the sender’s heater had broken and that he was asking to borrow blankets and kerosene heaters. He did get what he needed and did later get his heater fixed. However, had he given his note a better subject heading, he might have had a faster response.

3. Including multiple subjects in one note

Covering multiple topics in one note involves less sending and hence less e-mail traffic and volume. However, your recipient might overlook one or more of those topics. It’s better to keep to one topic per message.

4. Sending before thinking
When you were small, your mother probably told you to count to three before responding to someone (mine told me to count to 10). Why did she say that? She knew that answering before thinking can lead to problems.

Make sure you really mean to say what you’ve written. People can interpret your words differently from what you meant. A statement made in jest to someone via e-mail may have a greater chance of being misinterpreted than one made in person. Also, be careful about reacting and replying too quickly to an e-mail that upsets you. As Proverbs 12:16 says, “A fool shows his annoyance at once, but a prudent man overlooks an insult.”
I’ll talk more about it in a future article, but legal implications offer another reason to think before sending. E-mail can be subject to “discovery” by attorneys for a party that might be suing your employer. That is, the things you write in your e-mail could end up in the hands of those attorneys and could be used as evidence against your company in a trial. So before you send an e-mail, imagine that you’re on a witness stand having to explain it.

5. Inadvertent replying to all

Before hitting Reply To All, make sure you really need to do so. Does everyone need to see your response? Does your response benefit everyone else? Or are you sending merely a private response or addressing a personal issue with the sender? In these situations, it’s better just to do a simple Reply. Otherwise, your private disagreement becomes public (and embarrassing) knowledge.

Be aware that if you receive a message because you’re part of certain message groups (e.g., a Yahoo group), your reply might go to everyone in the group even if you just hit Reply.

6. Omitting the context of a reply

As long as it’s not overdone, including the text of the original message in your reply can help the original sender understand your response. If all you send back, however, is a “Yes” or “That’s right,” it may be difficult for the sender to understand your answer. For that reason, it’s best to indicate the context of your answer by including the original question.

7. Shooting the messenger

Though the practice of shooting the messenger occurs more on message boards than in e-mail, it still deserves mention. Here’s what I mean by shooting the messenger:
Person A posts a message or sends an e-mail that quotes person B
Person C
• Receives the message
• Takes extreme exception to the quotation by person B
• In responding to A, attacks A rather than B

If you’re person C (the recipient), make sure you make the proper distinction when you reply. Just because A posted the comment by B doesn’t mean that A agrees with B. When you reply, address your comments to A. When talking about B, mention B explicitly and do so in the third (rather than the second) person.

Right:
To: A
From: C
Thanks for that note. Yes, I think B is really wrong on that statement.
Wrong:
To: A
From: C
What a ridiculous statement. It’s totally wrong.

9. Misaddressed recipients

A woman and former classmate told me about an incident involving her law school days and then-boyfriend. During a summer job between two of her years in school, she met another young man. One day she wrote a letter to a girlfriend, talking about this new boyfriend. She also wrote a letter to her old boyfriend. You guessed it: A few days later, the girlfriend called and said, “You know, you sent me a letter addressed to Wayne [the old boyfriend].”

Be careful when addressing e-mail, particularly if your software has a “predictive fill-in” feature (as Outlook Express does). As you’re typing in a recipient name, the software will complete the entry for you. If it’s wrong, and you hit Send without noticing, you will have misaddressed your note. I have, in my address book, an entry for Joy Fellowship. It’s a church youth group with whom I have been involved as a leader and to which my daughters belong. I also have an entry for their piano teacher, Joy Kiszely. When I address a note to her, I have to be careful. Because of alphabetization, Joy Fellowship appears before Joy Kiszely does. I haven’t erred yet, but it’s a real possibility.

10. Displaying addresses of recipients who are strangers to each other

Were you ever the recipient of an e-mail that had a gazillion other recipients as well? The message header, which had all of those recipient addresses, probably took up half your screen. Besides annoying you, the sender might have compromised your privacy by revealing your e-mail address to all the other recipients.

Don’t make the same mistake. If you’re POSITIVE that each of your recipients already knows (or could find out anyway) the address of every other recipient (e.g., they’re all in your company), and if the number of recipients is fairly small, go ahead and list them. Otherwise, address the note to yourself and put the recipient addresses in your blind carbon copy (bcc) field. Your recipients will not see who received your note, thus saving space and protecting the privacy of each recipient.

11. Replying vs. forwarding

Didn’t you hate it when you were young and your parents talked about you to their friends while you were present? They’d refer to you in the third person, as if you weren’t even there.

I thought about that situation last week after talking to a prospective client with whom I had spoken a few months earlier. I sent him an e-mail with links to my TechRepublic articles and blogs. Later that day, I received a reply from him. However, when I opened it, here’s what I read:

John,
Despite his claim, I don’t remember talking with Calvin before. It may have happened but wasn’t memorable. When you have time, could you read his article and let me know if it is worth doing anything else with it? Thanks.

Of course, the prospective client meant to forward my note to John (presumably a subordinate). Instead, he hit Reply, sending his note right back to me, not to his subordinate. Be careful that you don’t do the same thing. If you’re writing about person B but sending the note to person C, make sure you do forward (or send) your note to C and that you don’t inadvertently reply to B.

By the way, after getting this note, I replied back to the person, asking whether the note had been meant for someone else and offering to figure out who “John” was and to send him the note directly. The person replied again, apologizing and admitting that he was poor at multi-tasking.

Calvin Sun works with organizations in the areas of customer service, communications, and leadership. In addition to writing this column, he contributes to TechRepublic’s Help Desk Blog. You can contact him at csun@calvinsun.com.

A Different Type of Password Protection

By Susan, July 6, 2007 4:24 pm

Via a Tech report from TechRepublic, it seems that there is a new type of password technology in the making…its called “Passface”.

According to the IT News Digest, Passfaces, a security firm, is laying bets on using the human brain’s innate ability to remember faces as the crux for replacing text-based passwords. The technology lets users choose three face pictures as their password, and the authentication mechanism (BCS) consists of selecting the pictures from an array of seven to nine pictures.

The company claims:

that it’s far easier for humans to recollect faces than passwords. “We know a familiar face within 20 milliseconds,” claims Shaun Frome, managing director of ACAL, the UK distributor for Passfaces.

Evidently the array of pictures (Pocket-lint.co.uk) that are displayed to the user are jumbled around every time they are displayed, making the automation of hacking tougher. Want to try the technology at Passfaces? Just on over to their site.

But is it really new to the world of technology?

There was a similar technology (Help Net Security) at the Web 2.0 Expo at San Francisco by a company Vidoop. Users had to select a sequence of categories such as cars, airplanes, and keys, and then they would be shown pictures of items from these categories mixed with other unrelated pictures. The user had to use the access codes obtained beside the images of their categories for authentication.

These visual password models claim to be able to put a halt to automated password cracking, which plagues text-based passwords. On top of which, there are added advantages of not having to remember lengthy passwords. The Web community is (by and large) used to the concept of text-based passwords, but I don’t know…I think I’ll stick with what I have, its worked for 10 years so far…knock on wood that I don’t have to recall a face to jump in to my domains, or we might all be in trouble.

Prevent Outlook from adding the country field in Word

By Susan, June 23, 2007 7:02 pm

I found a great new site for tips and tricks I thought that I would share.

According to Tech Republic this is a great way to Prevent Outlook from adding the country field in Word

by Mary Ann Richardson | Jun 19, 2007

Takeaway: Writing letters in Word should be a breeze; however, Outlook may throw a snag in the process. Mary Ann Richardson walks you through the steps of how to block Outlook from automatically adding the country field to your letters.

When you write letters in Word, Outlook automatically inserts the country that matches your PC’s regional settings in the Country/Region field for that record (unless you include a country in the address). Consequently, when you click the Insert Address button in the Envelopes And Labels dialog box and choose Outlook as your Address Book, Word automatically inserts the full address, including whatever is in the Country/Region field. For example, if you are located in the United States, Word will insert United States of America. To prevent Word from automatically entering a country in your letters, follow these steps:
Open Outlook.
Open Outlook’s Contacts folder.
Go to View | Arrange By | Current View | By Location.
Scroll down until you see the first record with United States of America in the Country/Region column.
Delete United States of America from the Country/Region cell of that record.
Select all remaining records with United States of America in the Country/Region column.
Click the Country/Region cell of one of the selected records and drag it to the empty Country/Region cell created in step 5.

Now when you insert an address using Word’s Insert Address button, no country name will appear for the records where the field is blank. When adding new records to your Outlook address book, be sure to delete the country name by clearing the contents of the Country/Region field in the Check Address dialog box for that record.

Hello Again!

By Susan, May 6, 2007 5:20 am

And I bet you thought that we were gone for good?

Not on your life!

We are back, better, bigger and stronger than ever!

Give me a moment to catch my breath and for the ibprofin to work and

I’ll tell you all about the wonderful new developments within Mor10sen.com!

See ya soon!

BoxTrapper – Spam

By Susan, September 18, 2006 6:28 am

SpamAssassin is an automated mail filter that uses a wide range of heuristic algorithms on email headers and message bodies to identify “SPAM” (unsolicited email). SpamAssassin is designed to identify and mark emails that score beyond your threshold value. An email’s SpamAssassin score is the sum of values given to certain known spam characteristics.

Due to the continued request on how to keep your inbox clean of the spam that occurs for whatever reason, I had originally thought to place the whole domain on the Spam Assassin feature, and I realized the depth of this action would mean that I would need to go into the domain on a weekly basis to go through all the email and make sure that no true emails were being trapped and then dump the spam folder after sending the email on or deleting it.

I don’t want the headache of this, so instead I would like to offer another choice to help you maintain your spam. The option is called the BoxTrapper. BoxTrapper protects your inbox from spam by forcing all people not on your white list to reply to a verifcation email before they can send mail to you. Seeing how you have yet to create a whitelist, this would pertain to all emails for a period of time.

If you would like more information on this option to help clear out your spam, or if you would like this feature enabled, please contact me and I will send you more information or set up your email account with the BoxTrapper enabled.

Managing Spam – Part 2

By Susan, July 20, 2006 4:27 pm

Steps You Can Take to Eliminate Spam

Here are some steps you can take to significantly cut down the spam that you receive. Some of these steps can help you with at either no charge or at a nominal fee. The fourth step – Spam filtering – is a service that Mor10sen.com offers or that you can purchase from a third-party vendor.

1. Remove email addresses from your website

We recommend not posting any email addresses directly on your website. If you want customers or site visitors to contact you, then we suggest offering them an on-line form that they can fill out and that will direct the email to you without exposing your email address.

2. Remove the default maildrop on your website

This would only pertain to those who have administrative Privileges on this domain.

3. Retire your email address

Probably the most important decision you need to make related to spam is deciding what to do about your current main email address. If you have registered your domain with your email address as the contact address or have your personal email address advertised across your site – or on other sites – you can be sure that spammers have it and are hammering away at it relentessly.

My suggestion is to start a process of transitioning your email to another address, one that you protect closely and that is not generic. If you have an address like “dave@” or “sue@” or something that spammers will send to regardless of whether you advertise it or not, you are a sitting duck.

Most domain registrars now let you register your domain without posting your email address. Removing your email address from your public domain registration is an excellent step.

When posting to email lists, use a secondary address – so you can protect your main address from public exposure and more easily filter the spam coming to your secondary address.

There is often a cost to giving up an email address – perhaps it is printed on business cards or has become part of your personal identity. But if your address is already out there in the public, retiring it might be a necessary step to curbing the flow of spam that is overtaking your life.

4. Employ Spam filtering

Even with the first three steps in place, spammers will find you. If you are sufficiently outraged at the onslaught of disgusting and ridulous messages you receive in your Inbox on a daily basis, I would recommend using spam filtering.

There are many different types of filtering. The options fall into three main categories:

Message Filtering programs that you purchase as add-ons to the email software that runs on your computer. Some of these programs do an excellent job. The downside is that you are still getting all the spam onto your computer and that if you check your mail from more than one location, you will not be able to take advantage of the features unless you load the software at the various locations from which you are doing the checking. Some of the popular programs are:

http://spaminspector.com

http://spamwasher.com

http://www.spambully.com

Programs or services that use what is called a challenge and response system. This setup sends an automated reply to any email that requires the sender to verify who they are. You can then decide to allow these adresses into your approved list on a case-by-case basis. This approach is superb for eliminating spam. The problem is, that challenge-response programs can present a barrier for some people, who will decline to follow through and contact you. If you are running an online store, this approach can be risky because you will lose customers who won’t want to go through the permission process.

Server-Based Spam Filtering (as in administrative control in the web-based email), stops spam before it gets to your own computer. This is a great solution for cutting down on the spam before it reaches your computer. When using a server-based program, you’ll want to check your filtered messages on a regular basis to ensure that you are not missing important emails.

Panorama Theme by Themocracy