OFFICE 2007 NEW FEATURES
¾ Quick Access Toolbar – contains shortcuts for the most commonly used tools
¾ Microsoft Office Button – contains common file and system commands
¾ Tab Bar – contains tabs that display tools and commands in the ribbon
¾ Ribbon – contains groups of tools for use with Word 2007
¾ Document Pane – displays the currently open document
¾ Status Bar – contains document information and shortcuts
¾ Zoom Slider – on the status bar to zoom in and out of a document quickly
¾ Building Blocks – are preformatted elements such as cover pages, pull quotes, headers, footers, text boxes, Quick Parts and other items that you can insert into a document.
¾ Mini Toolbar – gives you quick access to formatting tools
¾ Quick Style to Text
¾ Enabling or Disabling Contextual Spell Check
¾ Inserting a Smart Art Graphic
¾ Running the Compatibility Checker – checks the document for features that are not supported by earlier versions of Word
¾ Access Keys
¾ Marking a Document as Final – this makes the document read-only
MICROSOFT OFFICE 2007 “RIBBON”
The New Office 2007
Instead of having 30 or so un-displayed toolbars, and commands buried on menus, you now have one control center that's brought the essentials together and made them very visual.
Some commands are not always visible, but instead appear only in response to an action you take. For example, when you insert a
picture in Word, the Picture Tools appear, and the commands you need for working with the picture are displayed on the Format tab.
When you are through working with the picture and click away from it, the Picture Tools and the Format tab and its commands go away. If you need the tab again, you simply click the picture.
MICROSOFT OFFICE BUTTON
What happened to the File menu?
The Microsoft Office Button appears in the upper-left corner of the window in several Microsoft Office programs. You get the same basic commands as appeared before on the File menu to open, save, and print your documents.
But the button offers more commands than the File menu did. For example, you've got support here for checking that files in Word, Excel, and PowerPoint don't contain private information or comments.
The Microsoft Office Button also leads you to the program settings that control things like your preferences for correcting spelling.
Click Excel Options, Word Options, and so on, at the bottom of the menu, and then click any of the categories in the list on the left. For example, in Excel, click Formulas to turn the R1C1 reference style on or off. In Word, click Proofing to turn on or off the feature to check spelling as you type.
In previous versions of Office you could set options in the Options dialog box, which you opened through the Tools menu. Many of those options can now be found when you click the Microsoft Office Button — where they are more visible, and conveniently close at hand when you start work on old files or new ones.
1. Open Word or Excel Options
a. Click on the “Save” – on this option you can select what version to save your document by default and to select the file save location.
i. Select the “Save files in this format”
ii. Select to save the files by default in the “Word (Excel) 97-2003 document
.doc
b. Select the “Customize” – here is one way of editing items on the Quick Access Toolbar
2. Click OK to close the Options menu.
What about the new file formats?
In Word, Excel, and PowerPoint 2007 there's a new file format. Why? Increased security for your files; reduced chance of file corruption; reduced file size; and new features.
You can open a file that was created in Office 95 through 2003.
When you save a file created in a previous version, the default in the Save As dialog box is to save the file as a previous version. You can also select to save the file as a 2007 version.
When you save a file as a previous version, a Compatibility Checker will let you know of any 2007 features that may be disabled, or matched as closely as possible.
Colleagues who have Excel versions 2000 through 2003 (and the latest patches and service packs) can work in your 2007 files. When they click on your document, they will be asked if they want to download a converter that will let them open your document.
ACCESS 2007 COMPATIBILITY
Access also has a new file format: .accdb. New databases you create in Access 2007 automatically use the format. You can open and work with the old .mdb format, if those files were saved in Access 2000 or Access 2002-2003. To use the new Access 2007 features in .mdb files, however, you must first use Save As to convert the database to the new format.
¾ You cannot open the new format with any version of Access except Access 2007.
The new file format in Access 2007, .accdb, supports new product features such as the attachment data type, which lets you store documents and files as compressed
attachments in your database, and multivalued fields. It allows improved encryption for stronger privacy and security.
¾ If you don't plan to use the database with earlier versions of Access (and if you do not use replication or user level security), you should upgrade the database.
Important You cannot open a database in .accdb file format with any version of Access except Access 2007.
There are three basic components to the Ribbon.
Tabs sit across the top of the Ribbon. Each one represents core tasks you do in a given program.
Groups are sets of related commands, displayed on tabs. They pull together all the commands you're likely to need for a type of task, and they remain on display and readily available, giving you rich visual aids.
More options if you need them
When you see a small arrow (called the Dialog Box Launcher) in the lower-right corner of a group, it means there are more detailed or
advanced options available for the commands in the group. Click thearrow to open a dialog box or a task pane where you can work with the
available options.
Commands are arranged in groups. A command can be a button, a menu, or a box where you enter information.
Put your own commands on the toolbar
If you often use commands that are not as quickly available as you would like, add them to the Quick Access Toolbar, which is above the Ribbon when you first start your Office program.
Quick customization
The Quick Access Toolbar can be customized in several different ways:
You can add buttons to it by right-clicking any button you want and then clicking Add to Quick Access Toolbar.
You can click the command Customize Quick Access Toolbar, which appears when you right-click any button. In the dialog box that opens, choose from the commands available.
To move the toolbar to its own row just below the Ribbon, click the arrow on the end of the toolbar, and then click Show Below the Ribbon. To move the toolbar above the Ribbon, follow the same steps but click Show Above the Ribbon.
Delete a button from the Quick Access Toolbar 1. Right-click a button on the toolbar.
2. Click Remove from Quick Access Toolbar.
Minimize the Ribbon
You can minimize the Ribbon by right clicking anywhere on the ribbon and selecting
“Minimize the Ribbon”. To restore the Ribbon you right click on the Ribbon anywhere and deselect “Minimize the Ribbon”. Minimizing the Ribbon will allow more workspace.
It also gives the appearance of the old word with only the Tabs being viewable. Clicking the Tab will open up the menu. By clicking anywhere in the document or selecting any item off the menu will reduce the tab again.
Using the new keyboard shortcuts
The new keyboard shortcuts have a new name: Key Tips. You press ALT to make the Key Tip badges appear. You'll see Key Tips for all Ribbon tabs, the Quick Access Toolbar, and the Microsoft Office Button.
Press the key for the tab you want to display. This makes all the Key Tip badges for that tab's buttons appear. Then, press the key for the button you want.
Keyboard shortcuts of old that begin with CTRL are all still intact. For example, CTRL+C still copies to the clipboard, and CTRL+V still pastes from the clipboard.
Note Most of the old ALT+ menu shortcuts still work. However, you will
