Showing posts with label Word 2010. Show all posts
Showing posts with label Word 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.




Tuesday, 11 August 2009

Word 2010 - Navigation Pane


Word 2010 - Navigation Pane

A new feature of Word 2010 is the Navigation Pane which has a series of functions to let you move, with no trouble, around the document. Basically it is the Document Map and Thumbnails Pane combined with search and find options. To open the Navigation Pane go to View > Show > Navigation Pane.

Headings

The first Tab is Headings and lets you browse the headings within the document. One click on the Heading will take you to an insertion point at the beginning of that heading. Whenever a new heading is entered it will show automatically in the Pane and, although the Tabs themselves cannot be edited, they remain synchronised with the rest of the document.

Dragging a Heading up or down will move it, and the contents associated with it, to its new location including any subheadings. Content cannot be dropped onto a Headings Tab though if you drag the content over the Headings it will scroll to that Heading and can be dropped into the document.

When a document has multiple authors a small icon will appear on the right of the Heading to indicate that the document is being edited by a different user. After saving changes in a multi-user document the Headings where the changes have been made will be highlighted the next time the document is reopened. Using the Search Document feature at the top of the Navigation Pane will highlight any of the Headings where the search term has been found.

Browse

The second Tab on the Navigation Pane is ‘Browse the pages in your document’ more or less the same has the Thumbnails Pane of old. The only real difference from the Thumbnails Pane is that it now shows all layout views, Web Layout, Outline, Draft, Etc. Also new to the Thumbnail/Browse is really useful feature whereby the pages are filtered to show only pages containing the terms from a search.

Search

The third and final Tab is ‘Browse results from your current search’ which shows a list of boxes each giving a bit of context to the term.



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




Friday, 17 July 2009

Office InfoPath 2010 – Designer/Editor

InfoPath 2010


InfoPath 2010 is a XML-based (XML, Extensible Markup Language, is the specification for creating custom markup languages, allowing users to define the ‘mark-up’ components) form creating and data gathering application that first appeared in 2003. The purpose of InfoPath is to create/edit XML-based entry forms and transfer data between applications and in some cases even between organisations.

Once a form has been filled-in the data will be incorporated into the ‘back-end’ procedures that understand the particular structure of that form. Yes, it has to be said, that you can build forms with Word and Excel and they both have the capacity for interaction with XML data, though you will need at least some understanding of Visual Basic.Net to do so. Neither Word nor Excel can offer the structural XML editing that InfoPath offers.

The swift adoption of XML technologies in recent years has uncovered the need for an application that allows users (non-developers, anyone using Word or Excel can create a form in InfoPath) to share and interrelate with XML data.

The InfoPath Ribbon Tabs & Groups are:

Home:

  • Clipboard
  • Format Text
  • Font Styles
  • Controls
  • Rules
  • From

Insert:

  • Page Layouts
  • Section Layouts
  • Tables
  • Illustrations
  • Links
  • Page Format
  • Symbols

Page Design:

  • Views
  • Layout Styles
  • Background
  • Header & Footer

Data:

  • Form Data
  • Get External Data
  • Submit Actions
  • Rules
  • Roles

View:

  • Show

Developer:

  • Code
  • Events
  • Control Events

Contextual Tabs;

Control Tools

Properties:

  • Properties
  • Modify
  • Display Text
  • Control Size
  • Rules

Table Tools

Layout:

  • Table
  • Rows & Columns
  • Merge
  • Cell
  • Alignment
  • Borders & Shading
  • Draw

Picture Tools

Format:

  • Adjust
  • Borders & Shading

The Office (InfoPath) Button

Info


Recent


New


Print


Share


InfoPath Options


InfoPath Options

General:

General

  • Top options for working with InfoPath
  • Personalise your copy of Microsoft Office

Language:

Set the Office Language Preferences.

  • Choose editing languages
  • Choose display and Help languages

Customise Ribbon:

Customise the Ribbon.

  • Choose commands from:
  • Customise the Ribbon:
  • New Tab
  • 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
  • InfoPath Editor Trust Center
  • Trust Center Settings

Controls & Fields



Get the best Office Software deals Here...


Pre-order Windows 7. Offer ends midnight on 9th August 2009

Microsoft Windows 7 Home Premium

Microsoft Windows 7 Professional E

Tuesday, 14 July 2009

Office 2010 - News

Technical Preview


The ‘official’ Technical Preview is here

Yesterday, Microsoft began its ‘invitation only’, but none the less impressive, Technical Preview of the Office 2010 package. Still no mention of that underestimated little word, price. The price will be a major concern for anyone who already owns Office 2007 especially considering that it doesn’t do anything fundamentally different and there is also the less glamorous but still functional OpenOffice Suite for free.

Online Office

Office 2010 will also be available in an online version, albeit reduced. The programs that will be available are Word, Excel, PowerPoint and OneNote. Use of the remote Office will also be compatible with Safari and Firefox. The fact that they were not really highlighting of the online version of Office 2010 is more a response to Google docs rather than a shift in emphasis from the software package. As I understand it you will need a Windows Live account to access it but there’s no cost involved even for non-Office users, though one if its main attractions is the ability to collaborate with other Office 2010 licence owners.

The Office 2010 web applications will have a restricted functionality but more than enough to make adjustments to existing documents including using formulas in Excel and adding web clips and the like to OneNote. We will have to wait for the full release of Office 2010 to try out the web-based features which are not available in the Technical Preview though, apparently they will be available later this year. You can read more about it from their site, here.





Next, SharePoint Workspace...

Saturday, 27 June 2009

Office 2010 – Word V

Word 2010 - Part 5 Background Removal

Photoshop comes to Word

A new feature in Word 14 is Background Removal. To access it and its functions open the Insert Tab and either insert an image Insert>Picture or Insert>Screenshot and follow one of the options covered in Part 4.

This time I will use an image from file. When the image opens it will automatically load the Picture Tools Format Tab, select Background Removal.


The Background Removal tool will follow the main lines in the image and try to determine which the likely areas to remove or keep are. In this case it came close but not close enough.

The three options in Background Removal are:

  • Mark to Include
  • Mark to Remove
  • Delete Marks

Selecting 'Mark to Include' I've clicked and dragged four diagonal lines, one on each corner, to show I want to keep some of those areas. Then I tell it the areas to exclude with 'Marks to Remove'. You have to play around with it, adding some areas and removing others, until you're happy with the result.



Hit Return when you're happy with the result


Add a Picture Style>Compound Frame Black and a Picture Effect, Picture Effects>Reflection>Half Reflection 8 pt offset


Or, Picture Effects>Glow>Purple 18 pt glow, Accent colour 4


Thanks to Gleannie for letting me use her photo

Part 6 - Microsoft Office Exel 2010 (14).....



Friday, 26 June 2009

Office 2010 – Word IV

Blog from Word

I am just testing the automatic Blog post document option in Word 14. It took less than 20 seconds to set up.

Now let's see if it posts?

Apparently all I have to do is click Publish

Publish – Publish the post to the blog account so that other people can read it.

Well, I guess it tried. Acually it was uploaded to the Blogger site but was waiting as a draft.

The images were added later.





Next, Word continued...