Sunday, 23 August 2009

Windows 7

Windows 7 - 30 day trial (or more?)


October 22 is the release date for Windows 7 and, although I have used the Release Candidate (Evaluation Copy) Build 7100 for some months now, it was my intention to start the 30 day trial period of the RTM version in the run-up to the release date.

Sometime last week a story appeared on the web about a bug in Windows 7 which allows you to extend the 30 day trial period, or as Microsoft call it 'Rearm' it, for another 30 days. The process can be repeated three times in all giving four months (approximately) or 120 days of free use before deciding to buy.

At the moment there are no actual discs available for Windows 7, only downloads, but when they do become available, regardless of which version you buy, you will have access to all versions including a 30 day trial period to try it.

To get the extension to the trial period is simple and is already in built into the system. I would not advise experimenting with it until it is close to expiring because it will reset the clock on the trial regardless of how many days left you have.

The easiest way to check how long is left on the trial is to right-click on Computer from the Start menu and select Properties. At the bottom of the page is Windows activation showing the number of days left before activation is needed.


The Bug

The thing I like about 'The Bug' is that it was built into the system by Microsoft so it is not some hack or crack found on a forum that could screw up your system and/or complicate your license agreement.

Before reaching the end of your trial period (Windows 7 any version) go to the Start menu and in Accessories right-click on the Command Prompt selecting 'Run as administrator'. In the Command Prompt type 'slmgr -rearm' (without quotes) and hit Return. Restart windows and check the properties page which will now show 30 days before activation is required.



Windows Software Licensing Management Tool

Usage: slmgr.vbs [MachineName [User Password]]

MachineName: Name of remote machine (default is local machine)

User: Account with required privilege on remote machine

Password: password for previous account

Global Options:

/ipk

Install product key (replaces existing key)

/ato [Activation ID]

Activate Windows

/dli [Activation ID | All]

Display license information (default: current license)

/dlv [Activation ID | All]

Display detailed license information (default: current license)

/xpr [Activation ID]

Expiration date for current license state

Avanced Options

/cpky

Clear product key from the registry (prevents diclosure attacks)

/ilc

Install license

/rilc

Re-install system license files

/rearm

Reset the licensing status of the machine

/upk [Activation ID]

Uninstall product key

/dti [Activation ID]

Display Intallation ID for offline activation

/atp [Activation ID]

Activate product with user-provided Confirmation ID

Volume Licensing: Key Management Service (KMS) Client Options

/skms [Activation ID] [Activation ID]

Set the name and/or the port for the KMS computer this machine will use. IPv6 address must be specified in the format [hostname]:port

/ckms [Activation ID]

Clear name of KMS computer used (sets the port to the default)

/skhc

Enable KMS host caching

/ckhc

Disable KMS host caching

Volume Licensing: Token-based Activation Options:

/lil

List installed Token-based Activation Issuance Licenses

/ril

Remove installed Token-based Activation Issuance License

/ctao

Clear Token-based Activation Only flag (default)

/stao

Set Token-based Activation Only flag

/ltc

List Token-based Activation Certificates

/fta []

Force Token-based Activation

Volume Licensing: Key Management Service (KMS) Options

/sprt

Set TCP port KMS will use to communicate with clients

/sai

Set interval (minutes) for unactivated clients to attempt KMS connection. The activation interval must be between 15 minutes (min) and 30 days (max) although the default (2 hours) is recommended.

/sri

Set renewal interval (minutes) for activated clients to attempt KMS connection. The renewal interval must be between 15 minutes (min) and 30 days (max) although the default (7 days) is recommended.

/sdns

Enable DNS publishing by KMS (default)

/cdns

Disable DNS publishing by KMS

/spri

Set KMS priority to normal (default)

/cpri

Set KMS priority to low



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