 2007 |
|
|
New Features by Software
General
Navigation Pane
The Navigation Pane replaces the Database window in previous versions of Access and provides easy access to all of your objects. It appears on the left side as a column.
Want to close it? Click << at the top of the pane or press F11.
Want to open it? Click >> at the top of the pane or press F11.
Click the downward-pointing triangle in a circle at the top of the pane to choose what you want to see in the Navigation Pane.
Object Type is often a useful view.
Quickly Create on the Create Tab
The
Create tab on the Ribbon is the new primary starting place for adding new objects. You can quickly create new forms, reports, tables, queries and macros.
Tabbed Documents
Your tables, queries, forms, reports and macros display as tabbed documents.
If they don't appear as tabbed documents, follow these steps:
1. Click Office Button
2. Click [Access Options]
3. Click Current Database
4. Check box: Display Document Tabs
5. Click [OK]
6. Follow steps on message box (i.e., Close and reopen file)
Table
Table Template
Easy steps to create a table from a template. Do it from a new file or in an existing file.
New File
Receive a screen with two options: New Blank Database and Featured Online Templates
Featured Online Template Categories: Assets, Contacts, Issues, Events, Marketing Projects, Projects, Sales Pipeline, Tasks, Faculty, Students
Box at bottom of that screen refers to other Templates and more information available on Office Online.
Existing File
On the Create tab, in the Tables group, click Table Templates. Select one from these categories: Contacts, Tasks, Issues, Events and Assets.
Date/Time Data Type
Fields and controls with the Date/Time data type automatically display a small calendar button to the right of the date.
Click it to view current month and day calendar. Move to past or future months to select the day. Format: 6/14/2007.
New Format in Memo Fields
New RichText allowed in memo fields to enable common formatting options such as bold, italic, different fonts and colors.
Total Row in Table Datasheet View
Click Totals in the Records category in the Home tab on the Ribbon. You can select sum, average, maximum, minimum, standard deviation or variance within the specific field to get the result.
Create New Field Using Field Templates Pane
You can drag specific fields that you want on the datasheet in the specific column area you want. Go to the Datasheet tab. Click New Field on the Ribbon to access the Field Templates box.
Report
2 New Views for Reports
Report View: View a rich, accurate rendering of your report versus the Print Preview format. Use the Filter feature to view only specific records or use the Find operation to search for matching text.
Layout View: Make design changes as you browse through the report. You can make many of the most common design changes when you view the live report.
Note: Design View still remains for more detailed work to create or modify your report.
Group, Sort and Total Pane
This new feature is a easy and more accessible way to group and sort data in reports and add totals. In the new Layout View, on the Format tab, click the Group & Sort button to access the Group, Sort and Total pane at the bottom. Select the options that you want to do.
Back to top
Larger Worksheet
Excel 2007 has 1,048,576 rows and 16,384 columns.Excel 2003 has 65,536 rows and 256 columns.
Resizable Formula Bar
The formula bar automatically resizes when you use long, complex formulas.
Table Headings Remain
Excel 2007 keeps table headings in view when you scroll with data in a large table.
More Cell Conditional Formating
Excel 2007 has unlimited levels. Use as many as you need.Excel 2003 allows up to 3 levels.
Increased Sorting Levels
Excel 2007 allows 64.Excel 2003 allows 3.
Customize Status Bar
Right-click on the Status Bar to see all the new options. Average, Count and Sum automatically appear at the same time by default.You can also select Numerical Count, Maximum and Minimum to have them all appear at the same time.
New Charting Tools
The new tools easily create professional-looking charts. New special effects include 3-D, transparency and soft shadows.
Change in PivotTables
PivotTables are much easier to use now based on the new PivotTable user interface.
Back to top
New Themes
Theme is a combination of colors, fonts and effects. The theme can be applied to the file as a single selection. When you add any new SmartArt graphics, tables, charts, WordArt or text it automatically matches your existing theme. Any changes that you make in the new Quick Style galleries change to the theme you selected. Learn more about Quick Styles below.
Quick Styles
Quick Styles appears on the Home tab in the Drawing group. Quick Styles are collections of formatting options that allow you to easily format your documents and objects. You can save time and create better presentations by using Quick Styles. Click the specific object, click the Quick Styles button and roll the mouse over the options so you can see it on the slide.
New Effects
You can add new effects to shapes, SmartArt graphics, tables, text and WordArt. The new effects are shadow, reflection, glow, soft edges, bevel and 3-D rotation. Access those effects on the Shape Effects button located on the Home tab in the Drawing group.
Back to top
Live Word Count
The number of words always appear in the lower left as you type.
New Quick Style
You can quickly and easily change the appearance of graphics, tables and text throughout the whole document to match your preferred style or color scheme.
Steps to create a New Quick Style:
1. Select the text.
2. Use the Mini tollbar that appears above your selection. Click the button(s) to format the text.
3. Right-click the selection, go to Styles and click
Save Selection as a New Quick Style.
4. Enter the Style name. Click OK.
Building Blocks
Building Blocks allows you to add frequently used content to your documents. You use select predefined cover pages, pull quotes, headers and footers to make your documents look more professional. Quick Parts is also included in the Building Blocks. It allows you to create your own custom text to frequently use in multiple documents.
Quick Parts Examples: JMU Department contact information, special list style that you regularly use, images, hyperlinks and more. Use the Quick Parts tool to create the Building Blocks.
Easy steps to add to Quick Parts.
1. Select the content to save as a Building Block.
2. Click the
Insert tab. Click
Quick Parts within the Text command set.
3. Click
Save Selectin to Quick Part Gallery to access the
Create New Building Block dialog box.
4. Type a name in the Name: box. Click [OK].
NOTE: The item you added is saved in the Quick Parts gallery so you can insert it in any document by choosing it from the Quick Parts menu.
Contextual Spelling Option
Spelling Checker can find and flag some contextual spelling errors. Example: Wear are you? A blue wavy line appears below Wear. It helps you avoid common mistakes and misuse of similarly spelled words.
Full Screen Reading View
Full Screen Reading View has replaced the Reading Layout View in Word 2003. It provides a full-screen reading option with new navigation controls.
Back to top
