Showing posts with label Excel 2010. Show all posts
Showing posts with label Excel 2010. Show all posts

Tuesday, 18 August 2009

Access 2010 - Forms


Create Forms in Access 2010

Access 2010 is different from other Office 2010 applications in that the basic functions of programs like Word and Excel are fairly obvious and work well ‘out of the box’. Access on the other hand needs a bit more preparation. There are, of course, Wizards to help you through the creation of simple Forms, Queries and Reports though some kind of in-depth knowledge is needed to advance the programs functions any further and get the most out of the application.

Creating Forms

It is possible to create a decent looking form in just a few easy steps from the Tab Create > Forms.

  • Form

Create a form that lets you enter information for one record at a time.

  • Form Design

Create a new blank form in Design View. In Design View, you can make advanced design changes to forms, such as adding custom control types and writing code.

  • Blank Form

Create a form with no controls or format.

  • Form Wizard

Automatically create a form choosing fields from Tables or Queries

  • Multiple Items

Create a web form that shows multiple records at once.

  • Datasheet

Enters the Form Tools > Datasheet Tab to create a form directly from the Datasheet.

  • Split Form
Create a split form that shows a datasheet in the upper section and a form in the lower section for entering information about the record selected in the datasheet.
  • Modal Dialog

Create a Modal Dialog from Form Design Tools

  • PivotChart

Create a PivotChart from the PivotChart Tools > Design Tab

  • PivotTable

Create a PivotTable view. PivotTable views are interactive, making it easy for you to lay out the data in the format that works best for you, view summary data, or to see more detailed data.




Monday, 27 July 2009

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

Sunday, 26 July 2009

Office 2010 - News

Office 2010 - Sample Templates


I was beginning to think that we would have to wait for the full release of Office 2010 to see the support programs up and running. Over the last couple of days I’ve noticed the Office Online has been functional, albeit in a limited manner, though better than nothing.

Also the Sample Templates are now active and, although it is still not possible to search for additional templates, there seems to be quite and extensive list for each application.

Access 2010 (Available Templates)

  • Assets
  • Bugs
  • CharitableContributions
  • Contacts
  • Details_Part
  • Events
  • Faculty
  • Issues
  • MarketingProjects
  • Multiple_Part
  • Northwind
  • Notes_Part
  • Projects
  • SalesPipeline
  • Students
  • Tasks
  • Tasks_Part

Excel 2010 (Available Templates)


  • Billing Statement
  • Blood Pressure Tracker
  • Expense Report
  • Loan Amortization
  • Personal Monthly Budget
  • Sales Report
  • Time Card

InfoPath 2010 (Available Form Templates)

Popular Form Templates

  • SharePoint List
  • SharePoint Document Library
  • Blank
  • E-mail
  • Blank (InfoPath Editor)

Advanced Form Templates

  • Database
  • Web Service
  • XML or Schema
  • Data Connection File
  • Convert Word or Excel Form
  • Document Information Panel

InfoPath 2007 Form Templates

  • Blank
  • Blank (InfoPath Editor)

Template Parts

  • Blank
  • XML or Schema

PowerPoint 2010 (Available Templates and Themes)

  • Apex
  • Aspect
  • Civic
  • Concourse
  • Equity
  • Flow
  • Foundry
  • Median
  • Metro
  • Module
  • Opulent
  • Oriel
  • Origin
  • Paper
  • Solstice
  • Tecknic
  • Trek
  • Urban
  • Verve

Word 2010 (Available Templates)

Sample Templates

  • Equity Fax, Letter, Merge Fax, Merge Letter, Report, Resume
  • Median Fax, Letter, Merge Fax, Merge Letter, Report, Resume
  • New Blog Post
  • Office Word 2003 Look
  • Oriel Fax, Letter, Merge Fax, Merge Letter, Report, Resume
  • Origin Fax, Letter, Merge Fax, Merge Letter, Report, Resume
  • Urban Fax, Letter, Merge Fax, Merge Letter, Report, Resume

Office Online Templates (Not yet Available)

  • Budgets
  • Business Cards
  • Calendars
  • Faxes
  • Forms
  • Gift Certificates
  • Invoices
  • Minutes
  • More Categories (Analysis worksheets, Office document themes, SmartArt Graphics)
  • Planners
  • Plans

Monday, 20 July 2009

Office 2010 - Calendar Templates

Calendar Templates 2010


New Calendar Templates are now available for download from Office Online. The link is here. Here are a few examples.

Word



Excel


OneNote


Publisher