Office 2010 - Visio & Project

Microsoft Office Visio 2010

Microsoft’s diagram creating application Microsoft Office Visio 2010, although not available with Office 2010 Professional it will be included in some versions of Office 2010. Has expected the latest version of Visio been given a Ribbon. Visio is particularly useful when connected to Excel or Access files. It can be used to show representations of the data in an effective way that turns simple facts and figures into a more dynamic visual representation.

Data from most Microsoft Office 2010 applications can be imported into Visio through the Data Selection Wizard and associated with single, groups or all shapes within the diagram.

Visio diagrams should not be confused with PowerPoint or Word static diagrams, they are a means of tracking data in a visual form from any number of sources including Excel spreadsheets, SharePoint sites, Project schedules, Etc.

The Visio Ribbon Tabs and Groups are:

Home:

• Clipboard
• Font
• Paragraph
• Tools
• Shape
• Arrange
• Editing

Insert:

• Pages
• Illustrations
• Diagram Parts
• Links
• Text

Design:

• Page Setup
• Themes
• Background
• Layout

Data:

• External Data
• Display Data
• Show/Hide

Process:

• Subprocess
• Diagram Validation
• SharePoint Workflow

Preview:

• Proofing
• Language
• Comments
• Markup
• Reports

View:

• Views
• Show
• Zoom
• Visual Aids
• Window
• Macros

Office (Visio) Button

Options

General:

General options for working with Visio.

• User Interface options
• Personalise your copy of Microsoft Office

Proofing:

Change how Visio corrects and formats your text.

• AutoCorrect options
• When correcting spelling in Microsoft Office programs
• When correcting spelling in Visio

Save:

Customise how documents are saved.

• Save documents
• Offline editing options for document management server files

Language:

Set Office Language Preferences.

• Choose Editing Languages
• Choose Display and Help Languages

Advanced:

Advanced options for working with Visio.

• Editing options
• Display
• Save/Open
• Shape search
• General

Customise Ribbon:

Customise the Ribbon.

• Choose commands from:
• Customise the Ribbon:
• New Tab
• New Group
• Rename
• Restore Defaults
• Import/Export

Quick Access Toolbar:

Customise the Quick Access Toolbar.

• Choose commands from:
• Customise Quick Access Toolbar:
• Restore Defaults
• Import/Export

Add-Ins:

View and manage Microsoft Office add-ins.

• Add-ins

Trust Center:

Help keep your documents safe and your computer secure and healthy.

• Protecting your privacy
• Security & more
• Microsoft Office Visio Trust Center
• Trust Center Settings

Microsoft Office Project 2010

Office Project 2010 is project management application (MSP) which, until Office 2010, has not appeared as part of any Office suite. It is designed primarily to assist project managers in analysing, budgeting and tracking the progress of a project through the use of network diagrams and Gantt charts. A Gantt chart is timeline illustration chart that shows the projects elements, dependencies, relationships, Etc.

The Project Ribbon Tabs and Groups are:

Task:

• View
• Clipboard
• Font
• Tasks
• Schedule
• Insert
• Properties
• Editing

Resource:

• View
• Assignments
• Insert
• Properties
• Level

Project:

• Insert
• Properties
• Schedule
• Status
• Reports
• Proofing

View:

• Task Views
• Resource Views
• Data
• Zoom
• Split View
• Window
• Macros
• Gantt Chart Tools

Format:

• Format
• Columns
• Bar Styles
• Gantt Chart Style
• Show/Hide
• Drawings

Office (Project) Button

Options

General:

General options for working with Project.

• User Interface options
• Project view
• Personalise your copy of Microsoft Office

Display:

Change how Project content is displayed on the screen.

• Calendar
• Show indications and options for this project:
• Show indications and options buttons for:
• Show these elements

Schedule:

Change options related to scheduling calendars, and calculations.

• Calendar options for this project:
• Schedule
• Scheduling options for this project:
• Schedule Alerts Options:
• Calculation
• Calculation options for this project:

Proofing:

Change how Project corrects and formats your text.

• AutoCorrect options
• When correcting spelling in Microsoft Office programs
• When correcting spelling in Project

Save:

Customise how projects are saved.

• Save projects
• Save templates
• Cache
• Language:
• Set the Office Language Preferences.
• Choose Editing Languages
• Choose Display and Help Languages

Advanced:

Advanced options for working with Project.

• General
• Project Web Access
• Planning Wizard
• General options for this project
• Edit
• Display
• Display options for this project:
• Cross project linking options for this project:
• Calculation options for this project

Customise Ribbon:

Customise the Ribbon.

• Choose commands from:
• Customise the Ribbon:
• New Tab
• New Group
• Rename
• Restore Defaults
• Import/Export

Quick Access Toolbar:

Customise the Quick Access Toolbar.

• Choose commands from:
• Customise Quick Access Toolbar:
• Restore Defaults
• Import/Export

Add-Ins:

View and manage Microsoft Office add-ins.

• Add-ins

Trust Center:

Help keep your documents safe and your computer secure and healthy.

• Protecting your privacy
• Security & more
• Microsoft Office Project Trust Center
• Trust Center Settings

Links to previous posts:

Access Access II (Video) Access - Database

Access - Database II Access - Database III

Excel Excel II Excel - Basics

Installation Office the Movie (Video) InfoPath (Designer/Editor)

Office 2000 OneNote OneNote II (Video) OneNote III

Outlook Outlook II Outlook III Outlook - Import Contacts

Outlook - Import Contacts II (Video) Outlook - Rules

Outlook - Add-Ins

PowerPoint PowerPoint II (Video) PowerPoint III PowerPoint IV

Publisher Publisher II SharePoint Workspace

Technical Preview Templates (Calendar) Templates (Sample)

Tools (Office Tools) Visio & Project Web Browsers

Web Browsers II Windows 7 (Video)

Word Word II (Save/Save As) Word III (Insert/Screenshot)

Word IV (Blog) Word V (Background Removal)

Office 2010 - Access II

Microsoft Office 2010 - Access 14

Next, OneNote

Office 2010 – Access

Part 10 – Access 2010

Access 2010, like its predecessors, (though its official name is Microsoft Office Access) is a database management system. A ‘smart ass’ way to define a database would be “A collection of predicates over a finite set of predicate variables, describing constraints on the possible values and combinations of values”, which to me sounds like a table or chart connected to other tables/charts/lists.

The database model on which Access is based is called the ‘Relational model’. Other database models include Hierarchical, Network and Object-orientated.

Types of Databases

• Operational
• Analytical
• Data Warehouse
• Distributed
• End-User
• External
• Hypermedia

The list of uses for a database are endless, there isn’t an aspect of computer software applications that doesn’t at some point refer to them, it being to most appropriate method of storing, coordinating and accessing large amounts of data.

Access 14, like Excel deserves a book and not a blog entry, but for that I will need to see closer to the release date if it is plausible. For now an overview and later, like Excel, some practical exercises.

The Overview

This is how the main window looks when a database is opened in Datasheet View

The Tabs/Groups on the Ribbon are:

Home:

• Views
• Clipboard
• Sort & Filter
• Records
• Find
• Window
• Text Formatting

Create:

• Templates
• Tables
• Forms
• Reports
• Other

External Data:

• Import
• Export
• Collect Data

Modify Fields:

• Views
• Fields & Columns
• Formatting
• Properties
• Validation
• Table Logic

The Design Tab is only available in Design View

Design:

• Views
• Tools
• Show/Hide
• Field, Record & Table Events
• Relationships

The Office (Access) Button

Info

Recent

New

Print

Share

Access Options

Options

General:

General options for working with Access.

• User Interface options
• Creating databases
• Personalise your copy of Microsoft Office

Current Database:

Options for the current database.

• Application Options
• Navigation
• Ribbon and Tool Options
• Name AutoCorrect Options
• Filter lookup options for
• Caching Web Service and SharePoint tables

Datasheet:

Customise the way datasheets look in Access.

• Gridlines and cell effects
• Default font

Object Designers:

Customise the options for creating and modifying database objects in Access.

• Table design
• Query design
• Forms/Reports
• Error checking

Proofing:

Change how Access automatically corrects and formats the contents of your databases, and how it indicates the errors that if finds.

• AutoCorrect options
• When correcting spelling in Microsoft Office programs
• Custom Dictionaries

Language:

Set the Office Language Preferences.

• Choose editing languages
• Choose display and Help languages

Advanced:

Advanced customisation options for Access.

• Editing
• Display
• Printing
• General
• Advanced
• Default theme

Customise Ribbon:

Customise the Ribbon.

• Choose commands from:
• Customise the Ribbon:
• New Tab
• New Group
• Rename
• Restore Defaults
• Import/Export

Quick Access Toolbar:

Customise the Quick Access Toolbar.

• Choose commands from:
• Customise Quick Access Toolbar:
• Restore Defaults
• Import/Export

Add-Ins:

View and manage Microsoft Office add-ins.

• Add-ins

Trust Center:

Help keep your documents safe and your computer secure and healthy.

• Protecting your privacy
• Secure & more
• Microsoft Office Access Trust Center
• Trust Center Settings

Access the movie (youtube video)

Next, Access continued...