Back soon…

Command Name                  Shortcut Keys

   ———————————————–

 

   All Caps                      CTRL+SHIFT+A

   Annotation                    ALT+CTRL+M

   App Maximize                  ALT+F10

   App Restore                   ALT+F5

   Apply Heading1                ALT+CTRL+1

   Apply Heading2                ALT+CTRL+2

   Apply Heading3                ALT+CTRL+3

   Apply List Bullet             CTRL+SHIFT+L

   Auto Format                   ALT+CTRL+K

   Auto Text                     F3 or ALT+CTRL+V

   Bold                          CTRL+B or CTRL+SHIFT+B

   Bookmark                      CTRL+SHIFT+F5

   Browse Next                   CTRL+PAGE DOWN

   Browse Previous               CTRL+PAGE UP

   Browse Sel                    ALT+CTRL+HOME

   Cancel                        ESC

   Center Para                   CTRL+E

   Change Case                   SHIFT+F3

   Char Left                     LEFT

   Char Left Extend              SHIFT+LEFT

   Char Right                    RIGHT

   Char Right Extend             SHIFT+RIGHT

   Clear                         DELETE

   Close or Exit                 ALT+F4

   Close Pane                    ALT+SHIFT+C

   Column Break                  CTRL+SHIFT+ENTER

   Column Select                 CTRL+SHIFT+F8

   Copy                          CTRL+C or CTRL+INSERT

   Copy Format                   CTRL+SHIFT+C

   Copy Text                     SHIFT+F2

   Create Auto Text              ALT+F3

   Customize Add Menu            ALT+CTRL+=

   Customize Keyboard            ALT+CTRL+NUM +

   Customize Remove Menu         ALT+CTRL+-

   Cut                           CTRL+X or SHIFT+DELETE

   Date Field                    ALT+SHIFT+D

   Delete Back Word              CTRL+BACKSPACE

   Delete Word                   CTRL+DELETE

   Dictionary                    ALT+SHIFT+F7

   Do Field Click                ALT+SHIFT+F9

   Doc Close                     CTRL+W or CTRL+F4

   Doc Maximize                  CTRL+F10

   Doc Move                      CTRL+F7

   Doc Restore                   CTRL+F5

   Doc Size                      CTRL+F8

   Doc Split                     ALT+CTRL+S

   Double Underline              CTRL+SHIFT+D

   End of Column                 ALT+PAGE DOWN

   End of Column                 ALT+SHIFT+PAGE DOWN

   End of Doc Extend             CTRL+SHIFT+END

   End of Document               CTRL+END

   End of Line                   END

   End of Line Extend            SHIFT+END

   End of Row                    ALT+END

   End of Row                    ALT+SHIFT+END

   End of Window                 ALT+CTRL+PAGE DOWN

   End of Window Extend          ALT+CTRL+SHIFT+PAGE DOWN

   Endnote Now                   ALT+CTRL+D

   Extend Selection              F8

   Field Chars                   CTRL+F9

   Field Codes                   ALT+F9

   Find                          CTRL+F

   Font                          CTRL+D or CTRL+SHIFT+F

   Font Size Select              CTRL+SHIFT+P

   Footnote Now                  ALT+CTRL+F

   Go Back                       SHIFT+F5 or ALT+CTRL+Z

   Go To                         CTRL+G or F5

   Grow Font                     CTRL+SHIFT+.

   Grow Font One Point           CTRL+]

   Hanging Indent                CTRL+T

   Header Footer Link            ALT+SHIFT+R

   Help                          F1

   Hidden                        CTRL+SHIFT+H

   Hyperlink                     CTRL+K

   Indent                        CTRL+M

   Italic                        CTRL+I or CTRL+SHIFT+I

   Justify Para                  CTRL+J

   Left Para                     CTRL+L

   Line Down                     DOWN

   Line Down Extend              SHIFT+DOWN

   Line Up                       UP

   Line Up Extend                SHIFT+UP

   List Num Field                ALT+CTRL+L

   Lock Fields                   CTRL+3 or CTRL+F11

   Macro                         ALT+F8

   Mail Merge Check              ALT+SHIFT+K

   Mail Merge Edit Data Source   ALT+SHIFT+E

   Mail Merge to Doc             ALT+SHIFT+N

   Mail Merge to Printer         ALT+SHIFT+M

   Mark Citation                 ALT+SHIFT+I

   Mark Index Entry              ALT+SHIFT+X

   Mark Table of Contents Entry  ALT+SHIFT+O

   Menu Mode                     F10

   Merge Field                   ALT+SHIFT+F

   Microsoft Script Editor       ALT+SHIFT+F11

   Microsoft System Info         ALT+CTRL+F1

   Move Text                     F2

   New                           CTRL+N

   Next Cell                     TAB

   Next Field                    F11 or ALT+F1

   Next Misspelling              ALT+F7

   Next Object                   ALT+DOWN

   Next Window                   CTRL+F6 or ALT+F6

   Normal                        ALT+CTRL+N

   Normal Style                  CTRL+SHIFT+N or ALT+SHIFT+CLEAR (NUM 5)

   Open                          CTRL+O or CTRL+F12 or ALT+CTRL+F2

   Open or Close Up Para         CTRL+0

   Other Pane                    F6 or SHIFT+F6

   Outline                       ALT+CTRL+O

   Outline Collapse              ALT+SHIFT+- or ALT+SHIFT+NUM -

   Outline Demote                ALT+SHIFT+RIGHT

   Outline Expand                ALT+SHIFT+=

   Outline Expand                ALT+SHIFT+NUM +

   Outline Move Down             ALT+SHIFT+DOWN

   Outline Move Up               ALT+SHIFT+UP

   Outline Promote               ALT+SHIFT+LEFT

   Outline Show First Line       ALT+SHIFT+L

   Overtype                      INSERT

   Page                          ALT+CTRL+P

   Page Break                    CTRL+ENTER

   Page Down                     PAGE DOWN

   Page Down Extend              SHIFT+PAGE DOWN

   Page Field                    ALT+SHIFT+P

   Page Up                       PAGE UP

   Page Up Extend                SHIFT+PAGE UP

   Para Down                     CTRL+DOWN

   Para Down Extend              CTRL+SHIFT+DOWN

   Para Up                       CTRL+UP

   Para Up Extend                CTRL+SHIFT+UP

   Paste                         CTRL+V or SHIFT+INSERT

   Paste Format                  CTRL+SHIFT+V

   Prev Cell                     SHIFT+TAB

   Prev Field                    SHIFT+F11 or ALT+SHIFT+F1

   Prev Object                   ALT+UP

   Prev Window                   CTRL+SHIFT+F6 or ALT+SHIFT+F6

   Print                         CTRL+P or CTRL+SHIFT+F12

   Print Preview                 CTRL+F2 or ALT+CTRL+I

   Proofing                      F7

   Redo                          ALT+SHIFT+BACKSPACE

   Redo or Repeat                CTRL+Y or F4 or ALT+ENTER

   Repeat Find                   SHIFT+F4 or ALT+CTRL+Y

   Replace                       CTRL+H

   Reset Char                    CTRL+SPACE or CTRL+SHIFT+Z

   Reset Para                    CTRL+Q

   Revision Marks Toggle         CTRL+SHIFT+E

   Right Para                    CTRL+R

   Save                          CTRL+S or SHIFT+F12 or ALT+SHIFT+F2

   Save As                       F12

   Select All                    CTRL+A or CTRL+CLEAR (NUM 5) or CTRL+NUM 5

   Select Table                  ALT+CLEAR (NUM 5)

   Show All                      CTRL+SHIFT+8

   Show All Headings             ALT+SHIFT+A

   Show Heading1                 ALT+SHIFT+1

   Show Heading2                 ALT+SHIFT+2

   Show Heading3                 ALT+SHIFT+3

   Show Heading4                 ALT+SHIFT+4

   Show Heading5                 ALT+SHIFT+5

   Show Heading6                 ALT+SHIFT+6

   Show Heading7                 ALT+SHIFT+7

   Show Heading8                 ALT+SHIFT+8

   Show Heading9                 ALT+SHIFT+9

   Shrink Font                   CTRL+SHIFT+,

   Shrink Font One Point         CTRL+[

   Small Caps                    CTRL+SHIFT+K

   Space Para1                   CTRL+1

   Space Para15                  CTRL+5

   Space Para2                   CTRL+2

   Spike                         CTRL+SHIFT+F3 or CTRL+F3

   Start of Column               ALT+PAGE UP

   Start of Column               ALT+SHIFT+PAGE UP

   Start of Doc Extend           CTRL+SHIFT+HOME

   Start of Document             CTRL+HOME

   Start of Line                 HOME

   Start of Line Extend          SHIFT+HOME

   Start of Row                  ALT+HOME

   Start of Row                  ALT+SHIFT+HOME

   Start of Window               ALT+CTRL+PAGE UP

   Start of Window Extend        ALT+CTRL+SHIFT+PAGE UP

   Style                         CTRL+SHIFT+S

   Subscript                     CTRL+=

   Superscript                   CTRL+SHIFT+=

   Symbol Font                   CTRL+SHIFT+Q

   Thesaurus                     SHIFT+F7

   Time Field                    ALT+SHIFT+T

   Toggle Field Display          SHIFT+F9

   Toggle Master Subdocs         CTRL+\

   Tool                          SHIFT+F1

   Un Hang                       CTRL+SHIFT+T

   Un Indent                     CTRL+SHIFT+M

   Underline                     CTRL+U or CTRL+SHIFT+U

   Undo                          CTRL+Z or ALT+BACKSPACE

   Unlink Fields                 CTRL+6 or CTRL+SHIFT+F9

   Unlock Fields                 CTRL+4 or CTRL+SHIFT+F11

   Update Auto Format            ALT+CTRL+U

   Update Fields                 F9 or ALT+SHIFT+U

   Update Source                 CTRL+SHIFT+F7

   VBCode                        ALT+F11

   Web Go Back                   ALT+LEFT

   Web Go Forward                ALT+RIGHT

   Word Left                     CTRL+LEFT

   Word Left Extend              CTRL+SHIFT+LEFT

   Word Right                    CTRL+RIGHT

   Word Right Extend             CTRL+SHIFT+RIGHT

   Word Underline                CTRL+SHIFT+W

                                               

Note Some keyboard shortcuts in earlier versions of Microsoft Word no longer work as expected in Microsoft Office Word 2007. 

 
 

The following table lists the keyboard shortcuts that have changed in Word 2007. Additionally, the table describes the behavior of the keyboard shortcut in an earlier version of Word and describes the new behavior of the keyboard shortcut in Word 2007.

Keyboard shortcut	Old behavior	New behavior
CTRL+SHIFT+F	Selects the Font list on the Formatting toolbar. If the Formatting toolbar cannot be seen, CTRL+SHIFT+F displays the Font dialog box.	Displays the Font dialog box.
CTRL+SHIFT+G	Displays the Word Count dialog box. If the Word Count toolbar is displayed, the Word Count Statistics list is selected.	Displays the Word Count dialog box.
CTRL+SHIFT+P	Selects the Font Size list on the Formatting toolbar. If the Formatting toolbar cannot be seen, CTRL+SHIFT+P displays the Font dialog box.	Displays the Font dialog box.
CTRL+SHIFT+S	Selects the Style list on the Formatting toolbar. If the Formatting toolbar cannot be seen, CTRL+SHIFT+S displays the Style dialog box.	Displays the Apply Styles task pane.
ALT+N	If the AutoText toolbar is displayed and text is selected, ALT+N displays the Create AutoText dialog box. Also, an AutoText entry name is suggested in the Create AutoText dialog box.	Triggers the KeyTip that starts with N on the active tab.
ALT+R	Changes the view to Reading Layout. If Reading Layout is active, ALT+R displays the Research task pane.	Displays the Review tab. If the Review tab is active, ALT+R displays the Research task pane.

 

  

I found an interesting article that I thought you would like…  

  

About the Author

Luke Chung is the president and founder of FMS, Inc., a database consulting firm and the leading developer of Microsoft Access add-in products. He is the designer and co-author of several Access add-ins including Total Access Analyzer, Total Visual CodeTools, Total Access Detective, Total Access Emailer, Total Visual SourceBook, Total Access Statistics. He has spoken at a variety of conferences and user groups across North American and Europe.

Introduction

The ability to analyze data in Access is a fundamental skill that all developers must master. The better you are at organizing your data and knowing how to analyze it, the easier your application development will be. There are lots of ways to analyze data and different techniques must be used depending on your goal. However, there are a few fundamentals that must be understood:

• Data Normalization
• Separate Databases for the Application and Data

---

Data Normalization Overview

There are lots of articles and books on data normalization. They usually scare people including me. I am not going to get into a theoretical discussion of the pros and cons of data normalization levels. Basically, it comes down to this: how to store and retrieve data efficiently. This differs depending on the database used, so the more you understand how to manipulate data in Access, the more obvious the way you should store data in tables and fields.

A primary goal of good database design is to make sure your data can be easily maintained over time. Databases are great at managing more records. They are terrible if fields need to be added since all its queries, forms, reports, and code are field dependent.

Spreadsheet Gurus

Data normalization is a particularly difficult concept for spreadsheet experts. Having been a spreadsheet developer prior to using databases, I sympathize with those struggling to make the transition. The main reason you’re using a database rather than a spreadsheet is probably because have so much data you can’t manage it properly in Excel. The fundamental advantage of a database is that it allows your data to grow without causing other problems. The big disaster in most spreadsheets is the need to add new columns or worksheets (for new years, products, etc.) which cause massive rewrites of formulas and macros that are difficult to debug and test thoroughly. Been there. Designed properly, databases let your data grow over time without affecting your queries or reports. You need to understand how to structure your data so your database takes advantage of this. How you store your data is totally different from how you show it. So, stop creating fields for each month, quarter or year, and start storing dates as a field. You’ll be glad you did it:

 

 

Non-Normalized “Spreadsheet” Data

 

 

 

Normalized Data

Both tables in the example above contain the same data, but they are distinctly different. Notice how the normalized table lets you easily add more records (years) without forcing a restructuring of the table. In the non-normalized table, adding next year’s data would require adding a field. By avoiding the need to add a field when you get more data, you eliminate the need to update all the objects (queries, forms, reports, macros, and modules) that depend on the table. Basically, in databases, new records are “free” while new columns are “expensive”. Try to structure your tables so you don’t need to modify their fields over time.

for more info, visit his website… http://www.fmsinc.com/TPapers/datanorm/index.html

Okay, I know this is in German, I just liked the pic… 

Here’s some good Access 2007 info…

Navigating through a desktop database

After you know something about the major objects that make up an Access database, a good next step is to spend some time exploring the desktop database in greater detail.

As you begin to navigate through an existing database, keep in mind that the Navigation Pane is always the same width as it was when you last set it. The title bar of the window normally shows the name of the database that you have open. You can set options in the database to change the title bar of the main Access window to show the name of your application instead of Microsoft Access as shown in Figure 1.

Figure 1 The Navigation Pane displays the objects defined in an existing database.

The Ribbon has four main tabs that are displayed at all times. As you explore Access 2007, you’ll see that the Ribbon provides several contextual tabs that appear and disappear as you work with specific database objects and areas of the program. These contextual tabs make available commands that are useful only within the context of the object that has the focus and that object’s current view. For example, it wouldn’t make sense to show you table design commands when you have a table open to display its data (Datasheet view). Likewise, you don’t need datasheet commands when you have a query open in Design view.

 Note    You can rest your mouse pointer on any command or option on the various Ribbon tabs for a second (without clicking the button), and Access displays a ScreenTip to help you discover the purpose of the button.

You can change how Access displays the list of objects in the database by using one of the built-in navigation categories (Object Type, Tables And Related Views, Created Date, and Modified Date) or by defining your own custom navigation category. You can filter each navigation category to limit what group Access displays within each category so that you don’t have to wade through a long list to find what you want.

You can explore each of the types of database objects by clicking the Navigation Pane menu at the top of the Navigation Pane and then clicking Object Type under Navigate To Category. Next, open the menu again and be sure that you have clicked All Access Objects under Filter By Group, as shown in Figure 2. You can collapse an entire group of objects by clicking on the group’s header bar. If you defined names of some custom groups under Navigate To Category, then you will see these names when you open the Navigation Pane.

Figure 2 Select Object Type under Navigate To Category and then All Access Objects under Filter By Group to see all objects organized in groups by object type.

More info:

http://office.microsoft.com/en-us/access/HA102326851033.aspx

http://accessjunkie.com/IO2007.aspx

I found a great article that might help…

Working With Sections

Or:	Why Word appears to behave so illogically when you delete or move a section break
Or:	How to preserve section formatting when pasting between documents

Article contributed by Dave Rado

1.	How Word sections work
2.	Preserving section formatting when pasting between documents
3.	If you really want to delete the temporary section break …
4.	Preserving section formatting when using Insert + File
5.	Merging sections (to return to top, press Ctrl+Home, or use Alt + Left Arrow to Go Back)

How Word sections work

Section breaks store the following information:

1.	The Headers and Footers (and their properties) for the section.
2.	The Page Setup for the section.
3.	The Columns settings for the section.

When you delete a section break, or move an entire section to another part of the document, you get what seem to be very strange results. For instance, deleting a Continuous section break causes the preceding Next Page section break to convert to a Continuous one, or deleting a section break causes an important Header to disappear from the document, or causes the entire document to become landscape..

I agree it’s confusing, but it’s “by design”. These are the rules to remember:

1.	A section break stores the formatting (page setup, header/footers etc.) of the preceding section.
2.	The final paragraph of the document contains an invisible section break
3.	When you delete a section break, the properties stored in the section break are deleted, and the text which formerly preceded the section break takes on the properties stored in the next section break.
4.	A section break displays the “Continuous” or “Next Page” property of the following section!

So let’s say you have 3 sections.

	Section 1 has “Section Start Continuous” defined under Page Setup. The properties of section 1 are stored in the first section break. So the section break at the end of Section 1 stores the information “Section Start Continuous”.
	Section 2 has “Section Start Next Page” defined under Page Setup. So the section break at the end of Section 1 displays the information “Section Break Next Page”. Meanwhile the section break at the end of section 2 stores the information “Section Start Next Page”.
	Section 3 has “Section Start Continuous” defined under Page Setup. So the section break at the end of Section 2 displays the information “Section Break Continuous” and the invisible section break at the end of the document stores the information “Section Start Continuous”.

Now if you delete the second section break, the text which preceded it will take on the formatting of the next section (formerly Section 3, now Section 2), which has “Section Start Continuous” defined. So the first section break will now display “Section Break Continuous” whereas before it displayed “Section Break Next Page”.

more on the article… http://word.mvps.org/faqs/Formatting/WorkWithSections.htm

The ever on going debate for us who came from the typewriter days. One space or two after periods now with word processing ?????

Here are some thoughts…

Writing Tip: January 18, 2003

One or Two Spaces after a Period?

Those of us who use word processing software are no longer typists but typographers. While our typewriter keyboards limited our capabilities in creating text, our word processors allow us to do what professional typesetters have been doing for centuries. Consequently, many of the rules we learned as typists do not apply in the world of word processing.

Here are a few rules of typography (word processing) that differ from those we learned to use for the typewriter:

(A) Use one space after all punctuation, including periods, question marks, exclamation points, and colons. Putting two spaces after these marks of punctuation is a convention that evolved because typewriters were equipped only with monospaced fonts, which made it difficult to see where sentences ended. Professional typographers have always used only one space because they use proportionally spaced fonts, which do not require the extra spaces in order for a series of sentences to be readable. Because most of the fonts in today’s word processing software programs are proportional, in other words, we do not need to put an additional space after end punctuation or colons when we use our computers to compose.

more? 

http://www.getitwriteonline.com/archive/011803TypographySpacePeriods.htm

http://www.webword.com/reports/period.html

http://www.evolt.org/node/213

WAN Technologies

By JoAnne Woodcock
Chapter 8 from Step Up to Networking, published by Microsoft Press

WANs are all about exchanging information across wide geographic areas. They are also, as you can probably gather from reading about the Internet, about scalability—the ability to grow to accommodate the number of users on the network, as well as to accommodate the demands those users place on network facilities. Although the nature of a WAN—a network reliant on communications for covering sometimes vast distances—generally dictates slower throughput, longer delays, and a greater number of errors than typically occur on a LAN, a WAN is also the fastest, most effective means of transferring computer-based information currently available.

 

The Way of a WAN

To at least some extent, WANs are defined by their methods of transmitting data packets. True, the means of communication must be in place. True, too, the networks making up the WAN must be up and running. And the administrators of the network must be able to monitor traffic, plan for growth, and alleviate bottlenecks. But in the end, part of what makes a WAN a WAN is its ability to ship packets of data from one place to another, over whatever infrastructure is in place. It is up to the WAN to move those packets quickly and without error, delivering them and the data they contain in exactly the same condition they left the sender, even if they must pass through numerous intervening networks to reach their destination.

Picture, for a moment, a large network with many subnetworks, each of which has many individual users. To the users, this large network is (or should be) transparent—so smoothly functioning that it is invisible. After all, they neither know nor care whether the information they need is on server A or server B, whether the person with whom they want to communicate is in city X or city Y, or whether the underlying network runs this protocol or that one. They know only that they want the network to work, and that they want their information needs satisfied accurately, efficiently, and as quickly as possible.

Now picture the same situation from the network’s point of view. It “sees” hundreds, thousands, and possibly even tens of thousands of network computers or terminals and myriad servers of all kinds—print, file, mail, and even servers offering Internet access—not to mention different types of computers, gateways, routers, and communications devices. In theory, any one of these devices could communicate with, or transmit information through, any other device. Any PC, for instance, could decide to access any of the servers on the network, no matter whether that server is in the same building or in an office in another country. To complicate matters even more, two PCs might try to access the same server, and even the same resource, at the same time. And of course, the chance that only one node anywhere on the network is active at any given time is minuscule, even in the coldest, darkest hours of the night.

So, in both theory and practice, this widespread network ends up interconnecting thousands or hundreds of thousands of individual network “dots,” connecting them temporarily but on demand. How can it go about the business of shuffling data ranging from quick e-mails to large (in terms of bytes) documents and even larger graphic images, sound files, and so on, when the possible interconnections between and among nodes would make a bowl of spaghetti look well organized by comparison? The solution is in the routing, which involves several different switching technologies.

Switching of any type involves moving something through a series of intermediate steps, or segments, rather than moving it directly from start point to end point. Trains, for example, can be switched from track to track, rather than run on a single, uninterrupted piece of track, and still reach their intended destination. Switching in networks works in somewhat the same way: Instead of relying on a permanent connection between source and destination, network switching relies on series of temporary connections that relay messages from station to station. Switching serves the same purpose as the direct connection, but it uses transmission resources more efficiently.

WANs (and LANs, including Ethernet and Token Ring) rely primarily on packet switching, but they also make use of circuit switching, message switching, and the relatively recent, high-speed packet-switching technology known as cell relay.

for more info: http://technet.microsoft.com/en-us/library/bb727043.aspx

07 April 2009

By Gregg Keizer, Computerworld (US)

Microsoft has admitted that Windows XP’s new lease of life is to be continued well into next year.

A leaked memo from HP has revealed that the venerable operating system will not only be offered as a downgrade from Vista but also from the forthcoming Windows 7. Microsoft has acknowledged that it has “broadened the options” for PC makers regarding Vista, although the company would not confirm specific reports that HP had been given the green light to sell new PCs with Windows XP Professional preinstalled until the end of April 2010.

“Based on feedback, Microsoft is further broadening the options provided to Direct OEMs to help customers facilitate End User downgrade rights included in the product licence terms of a new system with either Windows Vista Business or Windows Vista Ultimate,” said a Microsoft spokeswoman. “This option is designed to help Direct OEMs further support customers, primarily small business customers, looking for Windows XP Professional due to application compatibility concerns.”

The Microsoft comments follow reports on AppleInsider, citing a leaked HP memo, that the company had given HP the okay to offer Windows XP as a downgrade until the end of April next year.

more:  http://www.techworld.com/opsys/news/index.cfm?newsid=113949&pagty

Yes, yet another pesky virus that needs to be sprayed.

Here is the link to get rid of it from Microsoft…

http://www.microsoft.com/protect/computer/viruses/worms/conficker.mspx

Want to view notes on your laptop and have just the presentation on your projector?

click here: http://office.microsoft.com/en-us/help/HA100673831033.aspx

also here: http://officeone.mvps.org/powershow/tips_view_notes_slideshow.html

It may require the “Power Show” add-in and definitly two monitors but still…