Office 2010

Office 2010 - Suites

2009-08-29T18:58:00.002+01:00

Microsoft Office 2010 - Packaging

Office Professional Plus (Volume licensing only)

Microsoft Access 2010
Microsoft Communicator
Microsoft Excel 2010
Microsoft InfoPath 2010
Microsoft Office Web applications
Microsoft OneNote2010 (New to Office)
Microsoft Outlook 2010 (Includes Business Contact Manager)
Microsoft PowerPoint 2010
Microsoft Publisher 2010
Microsoft SharePoint Workspace 2010 (New to Office)
Microsoft Word 2010

Office Professional 2010

Microsoft Access 2010
Microsoft Excel 2010
Microsoft OneNote 2010 (New to Office)
Microsoft Outlook 2010
Microsoft PowerPoint 2010
Microsoft Publisher 2010
Microsoft Word 2010

Office Home & Business 2010 (New)

Microsoft Excel 2010
Microsoft OneNote 2010
Microsoft Outlook 2010
Microsoft PowerPoint 2010
Microsoft Word 2010

Office Standard 2010 (Volume licensing only)

Microsoft Excel 2010
Microsoft Office Web applications
Microsoft OneNote 2010 (New to Office)
Microsoft Outlook 2010
Microsoft PowerPoint 2010
Microsoft Publisher 2010 (New to Office)
Microsoft Word 2010

Office Home & Student 2010 (Non-commercial license)

Microsoft Excel 2010
Microsoft OneNote 2010
Microsoft PowerPoint 2010
Microsoft Word 2010

Microsoft Office

2009-08-27T09:46:00.010+01:00

A brief chronology of Microsoft Office applications

1983

After the release of Multi-Tool Word the first version of Microsoft Word 1.0 for MS-DOS was released.

1985

Microsoft Word 1.0 and Microsoft Excel for the Mac and also Word 2.0 for MS-DOS are released.

1986

Microsoft Word 3.0 for the Mac and Word 3.0 for MS-DOS are released.

1987

Microsoft buys Forethought, the original company behind PowerPoint.

1988

Microsoft launches PowerPoint 2.0 for the Mac.

1989

Office 1.0 for the Mac is launched It includes Word 4.0, Excel 2.2 and PowerPoint 2.01.

1990

PowerPoint 2.0 for Windows is announced. Office 1.0 for Windows is available and includes Excel 2.0, Word 2.1 and PowerPoint 2.0.

1991

Microsoft announced the availability of Microsoft Excel for Windows 3.0.

1992

Office 3.0 for Windows is available and includes Microsoft PowerPoint 3.0 in combination with Microsoft Word for Windows 2.0 and Microsoft Excel 4.0.

1993

Office 4.0 for Windows ships with updated versions of Excel and Word.

1994

Office 4.3 Professional for Windows is available, featuring Access 2.0.

1995

Office 95 is the first complete package of 32-bit applications available for Windows 95.

1996

Exchange Server 4.0 is released. This is the original version of Exchange Server and was introduced as an upgrade from Microsoft Mail.

1997

Microsoft Outlook 97 and Exchange Server 5.0 are available.

1998

Office 98 the Mac Edition includes Word 98, Excel 98, PowerPoint 98 and Outlook Express.

1999

Access 2000 and Microsoft Office 2000 are launched.

2000

Exchange 2000 Server is released.

2001

Microsoft Office SharePoint Portal Server 2001 and Microsoft Office XP are released.

2003

Microsoft launches Office 2003, with Microsoft Office SharePoint Portal Server 2003. Microsoft Office OneNote and InfoPath have been added the Office line-up. Exchange Server 2003 is released.

2005

Microsoft buys Groove.

2006

Exchange Server 2007 is released.

2007

Microsoft Office 2007 is released, including Office SharePoint Server 2007.

2008

Microsoft announced the worldwide availability of Office Live Workspace beta.

2009

Live@edu services become known as Outlook Live while Exchange 2010 and Office 2010 are launched respectively as Beta and Technical Preview.

PowerPoint - Adding video

2009-08-25T12:34:00.003+01:00

Add video

Details in a later post.

Windows 7 - The Movie

2009-08-24T11:44:00.002+01:00

The best way to take a look at Windows 7 is to actually see it. Although my video making skills could best be described as ‘crap’, adding a bit of music to it does show a slight improvement on earlier attempts.

Windows 7 - Versions

2009-08-23T20:40:00.005+01:00

From Home Basic to Ultimate

Windows 7 will be available in six versions, in reality for most users it will be a choice of two and those with any sense just one. My reasoning being that Home Premium is the version that offers the best deal and the pricier Ultimate offers so few extras that buying Home Premium and, if you wish, manually add the missing extras; namely BitLocker Drive Encryption.

The six Windows 7 versions are:

Windows 7 Home Basic
Windows 7 Starter
Windows 7 Home Premium
Windows 7 Professional
Windows 7 Enterprise
Windows 7 Ultimate

Windows Home Basic

Home Basic is not intended for Microsoft’s main markets therefore it will only be available in countries that come under the underdeveloped category.

Windows 7 Starter

At the bottom end of the Windows 7 spectrum that will be available is Windows 7 Starter, which, to my knowledge will be pre-installed on Netbooks and appear on some low-end computers.

What you get is the basic Windows 7 interface minus the good bits. The ‘good bits’ being the Aero and preview effects which will be covered in detail later. It does include such features as the Action Center, Windows Search, Windows Firewall, Windows Media Player (not Windows Media Center), Windows Gadgets and the usual games and accessories (Paint, WordPad Etc.). Unless you buy a Netbook with Windows 7 pre-installed you can place it safely on the ‘don’t touch with a barge-pole’ list. The unnecessary restrictions on things like changing the desktop image and the absence of the visual effects make it unattractive.

Windows 7 Home Premium

Have a good look at Windows Home Premium because for the next few years this is what you are going to be using. I will cover the features included with Windows 7 Home Premium and other versions in the next post.

Windows 7 Professional

If you need to handle up to 192 gigabytes of ram (in 64 bit version) as opposed to 16 gigabytes and you also need a virtual PC that runs Window XP (licensed version of Windows XP service pack 3 included) for the remaining compatibility issues that will linger, then Windows 7 Professional is for you. Network backup and EFS (Encrypting File System) support are also included.

Windows 7 Enterprise

Like Windows 7 Home Basic there is not much to be said about a product that will not be available. Windows 7 Enterprise contains all the features of Windows 7 Ultimate but is aimed at Microsoft’s corporate customers and is not available for purchase by individuals.

Windows 7 Ultimate

Top of the range is Windows 7 Ultimate which will contain all Windows 7 components, including BitLocker Drive Encryption is the choice for someone who has to have everything. Unfortunately for those who have to have everything is that the ‘everything’ not included in Windows 7 Home Premium can be downloaded from third party software makers.

Try them all

When you buy a Windows 7 disc (any version) and try to install it, it will install the version you bought, obvious really. But if you like playing around with things like that then you will discover that all versions are contained on the disc. To access the other versions and try the 30 day trials for them you need to rip the disc and delete the ei.cfg file. After creating an ISO image (minus the deleted file) and burning it to a new disc the next time you insert the disc there will be a ‘Select the operating system you want to install’ screen showing all versions except Windows 7 Enterprise.

Windows 7

2009-08-23T15:36:00.011+01:00

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

Access 2010 - Forms

2009-08-18T01:15:00.005+01:00

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.

Word 2010 - Navigation Pane

2009-08-11T21:50:00.007+01:00

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.

Office 2010 - Visio & Project

2009-07-27T12:46:00.009+01:00

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 - News

2009-07-26T18:02:00.004+01:00

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

Access 2010 - Database III

2009-07-25T13:50:00.009+01:00

Access 2010 Objects

Queries

Using a Query in Access 2010 allows you to extract database information from Records that meet a certain criteria. Let’s say your database is concerned with holidays in European resorts and the customers who booked them. A query can be asked to filter customers of a given age group, those choosing a particular destination or any combination of factors. Most Reports and Forms are based on the results of Queries.

In Access 2010 Queries can be found on the Create Tab under the Group Other:

Query Wizard

Show the Query Wizard, which helps you create a Simple Query, Crosstab Query, Find Duplicates Query or a Find Unmatched Query

Query Design

New Object Query

Create a new, blank Query in Design view

The Show Table dialogue box is displayed, from which you can choose tables or Queries to add to the Query design.

Reports & Labels

A Report in Access 2010 is a way of exporting, sharing and printing data, it can be all the data or that part which meets the conditions set by a Query. The names and addresses of customers that meet a certain criteria (or several) can be extracted in Report form. Financial Reports based on sales is another example.

Create > Reports:

Report

Create a basic Report to the data in the current Query or Table, to which you can add features such as groups or totals.

New Object: Report

Create a new blank Report in Design view

In Design view, you can make advanced design changes to Reports, such as adding custom control types and writing code.

Blank Report

Create a new blank Report so that you can insert fields and controls and design the Report.

Report Wizard

Show the Report Wizard which helps you to create simple, customised reports.

Labels

Show the Label Wizard to create standard or custom labels.

Forms

Forms in Access 2010 allow users to add data to a table and display data in a more coherent view than the datasheet format. The accuracy of the data can be checked before being added to the Fields. A Form can also be used to display, print and share selective Fields from a Table while restricting access to other Fields.

Create > Forms

Forms

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

New Object: Form

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

Will let you choose which Fields you want on your Form, you can choose from more than one Table or Query.

Navigation

Allow users of your application to get to the Forms and Reports they need.

More Forms

Multiple Items
Datasheet
Split Form
Modal Dialogue
PivotChart
PivotTable

Other Access 2010 Objects are: Create > Other

Module

Class Module

Visual Basic

Create > Templates

Application Parts

Insert or create portions of a database or an entire database application.

Create Tables, Forms and Reports as database parts. Save combinations and use them to form common components. You can also save an entire application.

Create > Tables

Table

Create a new blank Table. You can define the Fields directly in the new Table, or open the Table in Design view.

Table Design

New Object: Table

Create a new blank Table in Design view. You can add Fields, set indexing options and perform other advanced Table design tasks.

SharePoint Lists

Contacts
Tasks
Issues
Events
Custom Existing SharePoint List

Access 2010 - Database II

2009-07-24T20:38:00.010+01:00

Creating a new table

Regardless of what experience you have using Access 2010 or earlier versions there are certain concepts to a database that you need to understand though it must be said that the levels to which you can take that understanding are endless.

When we open Access 2010 the program starts on the Office Button New tab with ‘Blank Database’ selected. Click ‘Create’. Access creates a new database (Table1 : Table) listed in the Navigation Pane on the left. In the main window is the Datasheet.

The Datasheet is not a database object though it is one of the numerous ways of viewing the data contained within the database, for now it is empty and ready for data to be added.

Fields, Records & Values

The data, when added, is displayed in rows and columns much as you would see data in an Excel spreadsheet. The column headings are called ‘Fields’ and the contents of the rows ‘Records’. A row in a database is a single Record consisting of different Fields.

A Field has many properties that can define the specific types of data contained within it, or which can and can’t be added to it. If for example you have a Field called ‘Year’ and its properties have been set to only accept numeric data then it will not accept words, letters or symbols.

The Value is the actual data where the Record meets Field. For example under the Field ‘Year’ on the first Record the Value could be ‘2009’ and, although there will be many instances of 2009, this Value is specific to this Record.

Naming Names

Whilst a database is small in size the names of objects might not seem to have much importance but once it starts to grow it will have. It is important to determine a convention for naming objects in a database even the tables themselves. If you create Reports, Forms, Queries, Etc. Based on a table, changing the name of the table will break the link between the table and the objects that use its information.

Tables and Queries share the same namespace within a database accordingly they need to have different names. Tables, Forms, Macros and Reports may share the same name. My own preference is to precede the name of an object with a shortened description, underscore and its name:

tbl_Name
qry_Name
rpt_Name
frm_Name
mcr_Name
mod_Name

It is always a good idea to give both Fields and Objects clear and descriptive names when you create them, regardless of the fact that most work done using Access 2010 or any other version is usually done on an existing database. The point being that, although AutoCorrect will accept changes, it will not update the name changes in the properties nor in any VBA code or Macros.

Access 2010 - Database

2009-07-23T23:09:00.008+01:00

Microsoft Office Access 2010

Access 1.0, based on the Jet Database Engine was released at the end of 1992 and was intended to be Jet-compatible through its scripting language Access Basic. It became a full member of the Office line-up as Access 95 abandoning Access Basic for VBA (Visual Basic for Applications).

Although Access 2010 will probably be known as Access 14 (Office 13 having been skipped for superstitious reasons) it is actually the tenth full release of the program.

A database is a table based on a filing system that contains data in columns and rows (similar to Excel) and each table constitutes a single entity which enables the data to be manipulated in a logical manner. You can think of it as an automated version of an archive of files that can be retrieved and help turn even large amounts of date into useful information.

Access 14, 10 or 2010 is a relational database management system (RDBMS) and is the overall container for the data associated with it. Some of the more commonly used objects in Access are Tables, Forms, Reports, Queries and Macros. It is my intention to look at all five, if not more, in the following days, weeks.

Outlook 2010 - Add-Ins

2009-07-22T23:57:00.003+01:00

Add-Ins for Outlook 2010

Never having been a big fan of Add-ins, Add-ons, Extensions, Plugins, Etc. It is not surprising that I don’t have many to mention. I was going to look at the two that I do have but one of them (Snagit) added its add-in when I installed the program without asking if I wanted an Outlook 2010 Add-In during the installation.

Snagit 9 is a screen capture application with many useful tools and an excellent image editing program. Unfortunately, for Snagit, the Outlook Add-in is for taking a single screen capture and inserting it into a new Outlook message. The reason it is unfortunate is that Outlook 2010 has that capacity itself.

With the New E-mail window open Insert > Illustrations > Screenshot > Screen Clipping and drag a rectangle/square around the area to capture. If you want to capture a specific window a preview of available widows will appear in the Screenshot dropdown. The tool is most useful for adding webclips and images but in this case I’ve just added my desktop clock to a message!

Twitter on Outlook 2010

The second Add-In I have on Outlook 2010 is TwInBox. It is basically Twitter on Outlook 2010 and has a few useful features including; the mandatory 140 character update, direct message, @, ReTweet. If you intend using the Search/Track/Group feature it’s a good idea to create a separate folder for the results (for example searching/tracking Office 2010 gave 600+ feeds in two days).

After installing you’ll need to create a new folder in the Navigation Pane, before logging into your Twitter account, into which will go your updates.

TinyUrl

If you wish to post links in your updates then the tinyurl creator is a useful tool to have on the Compose Update dialogue box. Although tinyurls are useful in a limited space (140 characters) I would make the point that they are being over used and unless I know and trust the person posting them I wouldn’t touch them. If you have an URL that isn’t that long to begin with then don’t shorten it. An example would be this site is http://officetwoten.blogspot.com and its shortened version is http://tinyurl.com/mt37j9 which would save a full seven characters!

Outlook 2010 - Rules

2009-07-21T21:40:00.013+01:00

Rules in Outlook 2010

Using Rules in Outlook 2010 is a great way to have messages do something specific before you actually read them. Rules also apply to sent messages but for the moment I will deal with received mail. There are many conditions you can apply to your incoming mail, for this example I will redirect some mail to a specific folder.

I get daily updates in my Gmail account from a few sites that I subscribe to. These sites could best be described as technology news sites like TechCrunch, Slashdot TechRepublic Etc. I don’t necessarily want to read them when I first open my inbox but for the moment that is where they appear.

Firstly I create a folder where I want the mail to be sent. After right-clicking on Outlook Data Files (in the left folder pane) and selecting New Folder I give the folder a name.

On the Home Tab, with one of the tech news emails selected click Rules, Create Rule from the Action Group.

In the Create Rule dialogue box the name TechRepublic Daily Digest has been inserted in the list of ‘When I get e-mail with all of the selected conditions’, which I tick. Under ‘Do the following’ I tick ‘Move the item to folder: TechNews.

Clicking Advanced Options will open the Rules Wizard options and give lists of conditions that can be applied.

By selecting ‘Run this rule now on messages already in “Inbox”’, all older/read mail from TechRepublic will be move there.

Office 2010 - Calendar Templates

2009-07-20T20:42:00.009+01:00

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

Outlook 2010 - Import Contacts II

2009-07-19T21:18:00.004+01:00

Outlook 2010 - Import Contacts (the Movie)

Outlook 2010 - Import Contacts

2009-07-19T19:01:00.015+01:00

Office 2010 - Outlook Contacts

To import contacts to outlook 2010 from a webmail account; sign in to your webmail account, click contacts, depending on the account you will either see at the top of the contacts box/list ‘Export’ or Manage > Import/Export. Download the CSV file to your computer/desktop. CSV Comma-Separated Values (sometimes called Comma-Separated Variables) are Excel files used to export data. Basically, each row entry from a table, for example, is separated by a comma enabling data to be passed (as a whole) from one application to another (usually databases to spreadsheets and vice versa).

With the CSV file save somewhere on your computer, I usually download files that will only be used once to the desktop.

Open Outlook 2010, with the Navigation Pane showing, right-click Contacts and from the context menu click new folder. You can, of course add your contacts to an existing folder but I prefer to keep them separate.

Give the folder a name.

There is no File menu in Office 2010 so everything you would usually find there is now on the new, classier Office Button. Office (Outlook) Button > Open > Import. I assume they get well paid for doing this, they should, but I don’t associate open and import in the same context, logically speaking. It can be a good barometer when applications follow a logical sequence. Or, where someone has said something like “yeah, I know where it can go, let's see if it passes the focus group”.

Import and Export Wizard: Import from another file.

Import a File: Make sure Comma Separated Values (DOS) is selected.

Choose the file from your desktop or documents. Duplicates are not an issue if you are importing to a new folder so leave it on ‘Allow duplicates to be created’.

Office 2010 - Office Tools

2009-07-18T20:32:00.011+01:00

Office Tools 2010

Digital Certificate for VBA Projects
Microsoft Clip Organiser
Microsoft Office Language Preferences
Microsoft Office Picture Manager
Microsoft Office Send-a-Smile
Microsoft Office Synchronisation Center

Digital Certificate for VBA Projects

“Microsoft® maintains a list of trusted third-party commercial certificate authorities to enable secure and usable e-commerce for Microsoft® Windows® users. These certificate authorities validate the identity and entitlement of an applicant, and as an output of this process, issue the applicant a digital certificate.

Digital certificates can be used to prove the identity of a remote person or resource, since not all certificate authorities follow the same operational practices. Microsoft uses an independent third-party audit (WebTrust for Certificate Authorities) along with other technical requirements to ensure our customers are have access to trustworthy CAs.

For information on Microsoft Root Certificate Program requirements, see the Microsoft TechNet Web site.”

Microsoft Office Language Preferences

Microsoft Clip Organiser

Microsoft Office Picture Manager

Microsoft Office Send-a-Smile

Microsoft Office Send-a-Frown

Feedback is always a great thing to have though I’m not sure where the Send-a-Smile & Send-a-Frown are leading. I mean imagine being assigned to the Send-a-Frown desk! I suppose our first ‘Frown’ to Microsoft will be; if MS-Paint and Word Pad (in Windows 7) can have Ribbons then why not the Clip Organiser and Picture Manager in Office 2010? As for sending a ‘Smile’ I think I’ll reserve judgment until I see the pricing of Office 2010.

Microsoft Office Synchronisation Center

Thanks to Gleanie for letting me use her photo.

Office InfoPath 2010 – Designer/Editor

2009-07-17T19:37:00.026+01:00

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

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...

SharePoint Workspace 2010

2009-07-16T19:15:00.021+01:00

SharePoint Workspace (Groove)

SharePoint Workspace (successor to Groove 2007) is Microsoft’s collaboration application for individuals and groups to share project information. The collaborative areas are called Workspaces that allow automatic synchronisation from anyone, anytime and anywhere.

Microsoft acquired Groove Networks in 2005 which had been originally developed by the creator of Lotus Notes Ray Ozzie.

You're either invited to join a Workspace or you invite.

After setting up your account the program starts with the Launchbar, an interface from which to launch Workspaces. The two Tabs on the Launchbar are:

Home:

Workspaces
Actions

View:

View

The Workspace Tabs and their Groups are:

Home:

New
Clipboard
Documents
Track
Go To

Workspace:

Tools
Invite
Communicate

View:

Show/Hide
Sort
Arrange
Window

I call it the Office Button, some are calling it Backstage (Either way it’s the old File Menu).

The Office (SharePoint Workspace) Button

Info

New

SharePoint Workspace Options

Groove Options (That's what they're called!)

General:

General options for working with SharePoint Workspace.

User Interface Options
SharePoint Workspace Options

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
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

Trust Center:

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

Protecting your privacy
Security & more
Microsoft SharePoint Workspace Trust Center
Trust Center Settings

Office 2000

2009-07-15T18:15:00.004+01:00

Office 2000 loses its extended support

In the countdown to the launch of Office 2010 Microsoft has ended its support for Office 2000. Launched in 1999 it lasted with full support until 2004 when it entered its extended support period which ended yesterday, ten years after it first appeared. Office 2000 was the successor to Microsoft Office 97 and its longevity will have been some compensation for those who forked out the modest sum of £500 (about $800) for the original package.

Office 2010 - News

2009-07-14T18:21:00.012+01:00

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...

Excel 2010 - Basics

2009-07-13T20:33:00.005+01:00

A Few Basics

Before moving onto the more advanced features of Excel it is always good practice to run through a few basics to see if there are any changes in the general function of the program. I will do a few simple calculations and produce a chart in the same worksheet to show the results.

Having opened Excel I will type January in the cell A2 (I will use the convention of showing cells and formulas in bold i.e. =Sum(A1:A2)). Hit Return and the cell below will be selected. Click on January/A2 again, place the cursor in the bottom right corner of the thick border and drag it down to December, Excel will fill in the months. The same principle applies to any logical sequence, if I type A1; Return, and drag, it will fill in A2, A3, Etc. It also works laterally in rows but not with whole numbers.

Click B2, and type in the formula bar, ‘2005 and hit Return. The apostrophe before the year 2005 will mark the date as a ‘number stored as text’ and not as a number. Otherwise, 2005 as a number at the top of a list of numeric values would be included in any calculations later.

With B2 selected, drag it across to E1 ending in 2008. Three of the last four months in the A column exceed the standard size width of the columns. This can be adjusted manually but, to save time and be more precise, double click the line at the top of the columns separating A & B.

After keying in the numbers shown with B14 selected, click Auto Sum in the Editing Group. Excel will try to determine, in this case rightly, what sum you’re trying to do. It came up with the obvious formula =SUM(B2:B13). Which are B2+B3+B4 Etc.

Drag the bottom right corner of B14 across to E14 and the missing three totals will be added. Check the totals by clicking on them individually and look at the formula bar i.e. with D14 selected it reads =SUM(D2:D13).

With all four totals selected, right click and open Format Cells. On the Number Tab select Currency, 2 Decimal places and the Symbol £.

Select the four headings 2005 to 2008 and, holding the Ctrl key, select the four totals, on the Insert Tab Click Column from the Charts Group. From the Type Group change the chart type to suit your preference.

With the chart selected from Chart Tools > Design > Chart Styles choose one of the styles. In the table click, to select, the Vertical (Value) Axis, right click and open Format Axis. On the Axis Options change the Minimum setting from Auto 0.0 to Fixed 3000.0 and the Maximum from Auto to Fixed 6500.0 (charts will be covered in depth later)

Windows 7

2009-07-12T20:40:00.004+01:00

Widows 7 - Promo video

As a Windows 7 user, for some time now, I will be covering it either on this page or on another page closer to its release date (22 October).

Web Browsers, continued...

2009-07-12T19:31:00.011+01:00

Google Chrome

The Google Chrome Web Browser was September 2008 in beta version. Of the five main browsers in use it is fourth on the table of most popular browsers, Internet Explorer being first and Opera last. Its share of the market is just under 2% compared with Microsoft’s share of 65%. When I see Google Chrome using the Vista/Windows 7 Aero effect I wonder if Google deliberately designed it for this platform.

Of all five browsers it looks the most integrated with Windows 7, apart from one significant feature, there’s no thumbnail preview of individual Tabs; missing also in Firefox and Opera, but available in Safari’s ‘Open in Tabs’.

The Google Chrome interface is nothing short of spectacular, especially for someone like me who wants less of everything. Less of everything that gets in the way that is, I do prefer a ‘hands-on’ approach to advanced setting and options, which Google Chrome lacks.

The user interface has nothing more than back, forward, refresh and Favorites buttons, apparently you can add a homepage button too if you really need one. Combining the search box and address bar is unusual at first but, in my opinion, the way to go.

Google announced last week its intention to release the Google Chrome operating system for netbooks. Although they claim it will be an open source project they haven’t released the code yet. Plans are towards the end of 2009.

If Google Chrome were fully integrated with Windows 7 and had a few more advanced setting then I could stop using Internet Explorer altogether. Until now it hasn’t and I didn’t.

Internet Explorer 8

Regardless of who you are, where you are or what you do, everybody has used Internet Explorer. Since taking over from Netscape Navigator in the mid-90’s it established itself, even controversially, has The Browser with at least 95% usage during its version 5 and 6 days.

The security vulnerabilities that affect all browsers tend to affect Internet Explorer more for the simple fact that it is more widely used so makers of adware, spyware and viruses will have a larger target if they aim specifically at Internet Explorer.

Internet Explorer 8 is slightly slower than other browsers, but we’re talking milliseconds and its integration with Windows 7 (Release Candidate) makes it a must for windows users. There are plans to release a version of Windows 7 (possibly called Windows 7 EU) with no browser?! This is due to the E.U.’s anti-trust regulations and continuing cases between Microsoft and the Opera makers.

It is my understanding that the manufacturers of new computers will be able to pre-install any browser they choose with Windows 7. If you live in Norway then the chances are your new pc will probably come with Opera pre-installed which originates from, let me think... Oh yes, Norway.

I have no way of accurately measuring my browser use in percentages, if I was to make a guess I’d say about 70-30 between Internet Explorer 8 and Google Chrome, though, that may vary due to odd facts like CNN’s live pop-up window is resizable in Google Chrome whilst not with Internet Explorer 8. I have to say that having discovered Safari’s nine news pages simultaneously, which made me laugh when I discovered it, its share could grow from a percentage close to zero to a ‘bit’.

Web Browsers

2009-07-11T20:58:00.008+01:00

A non-Office 2010 moment

Browser makers are falling over themselves these days to come up with the fastest and safest browser on the market. As browser users, who don’t actually pay anything, we can only benefit from the competition.

Browser has we know them today started in 1994 with Netscape Navigator and, although there were alternatives, it was the preferred way to browse the internet (series of tubes). With Windows 95, (Chicago, all Microsoft products have codenames though I’ve never discovered what Internet Explorer’s was although I do know Netscape Navigator’s, Mozilla) Microsoft began its almost complete domination of internet browsing. The Mac didn’t get its own browser, Safari, until around 2003.

There are five browsers today that are worth mentioning and I have all five running on this machine and to be honest there isn’t a slow one that you can just eliminate from the argument. They all load pages in from 2 to 4 seconds. I’ve tested all five with a stopwatch timer on this webpage.

This page is set to show five posts per page, because of the number of images I use, and knowing full well the internet (series of tubes) isn’t the same everywhere, I would prefer less but five is the minimum.

My use of the term ‘series of tubes’ is, of course, a reference to one of the United States’ former internet regulators (Ted Stevens) who shared his profound understanding of internet technology during a radio interview with the following gem:

“Ten movies streaming across that, that Internet, and what happens to your own personal Internet? I just the other day got...an Internet was sent by my staff at 10 o'clock in the morning on Friday. I got it yesterday. Why? Because it got tangled up with all these things going on the Internet commercially.

They want to deliver vast amounts of information over the Internet. And again, the Internet is not something that you just dump something on. It's not a big truck. It's a series of tubes. And if you don't understand, those tubes can be filled and if they are filled, when you put your message in, it gets in line and it's going to be delayed by anyone that puts into that tube enormous amounts of material, enormous amounts of material”.

So, having run the test a few times I have to say there was no clear winner or loser. The times I recorded were from the first run with Google Chrome first at 2.533 and, not surprisingly, last place was Internet Explorer 8 with 3.602, Opera and Firefox were both under 3 seconds while Safari was just over.

Opera 9.6

I downloaded the latest Opera browser for the simple reason that it keeps appearing on lists of favourite or least favourite browsers and I didn’t want to compare the others without it. My last encounter with Opera was back in the day (90’s) when it had an advertisement bar at the top which you could remove by subscription. Opera 9, (9.64) like the other four, does what a browser should so the only criteria I can find to eliminate three of the five are personal preference and appearance.

When I get my hands on a new browser, updated or otherwise, the first thing I do is get rid of all the trimmings. I don’t need or like toolbars, add-ons, buttons and the like. All I need, or want, is the absolute minimum browser interface. With Opera I can’t remove the Menu bar though I can remove the Tabs bar, without which I’d have no idea how many open Tabs there are! The Tabs are not pretty in Opera, in fact they’re ugly as sin, although the Tab review thumbnails their job.

Everyone should have at least two browsers and although I will browse on just about anything, and also the fact that there isn’t anything fundamentally wrong with Opera I can’t see myself using it whilst there are so many exceptional browsers to choose from.

Safari 4

Safari has an uphill struggle too; the first question I asked Safari 4 is “where are the Tabs?” Then I see the folders, I click News dropdown and see ‘Open in Tabs’, there they are. I click ‘Open in Tabs’ and all nine News pages open at once.

The good news is, unlike Google Chrome, Firefox and Opera, the individual Tabs show in the Windows 7 (I assume it’s the same in Vista) preview thumbnails and Windows Peak.

Top Sites looks fine but I really wanted individual Tabs. The Bookmark browser is really cute but unnecessary. A few less gimmicks and a few more basics would put Safari in the top three instead of it being a mostly Mac users browser.

Got News

Firefox 3.5

The problem I have with Firefox is a perception issue. It is a product like any other, if it accepted that I could give it the respect it probably deserves. We needed an alternative to Internet Explorer, and thankfully got more than one. But, the tag/label of being open source, alternative and free makes me suspicious when browsers are free to begin with. Yes, the Netscape Navigator source code, on which it was originally based, was released after AOL bought the Netscape brand name; and yes it’s free and was a much faster, less resource hungry alternative to Internet Explorer when we really needed one. An open source project is, almost by definition, done with passion and usually underfunded.

To date the pricing hasn’t been fixed for Office 2010 but when it is, and however much it is, if you compare it to the OpenOffice project then you’ll see the difference between a commercial venture and an open source project. Mozilla Firefox is a commercial venture.

The people I know who use Firefox say that it works fine until you install too many add-ons and accessories and then it slows. The Firefox 3.5 Menu bar can’t be hidden but apart from that the interface is clean and efficient, worthy of its second place in the browser users’ statistics.

Next, Internet Explorer 8 & Google Chrome...

Office 2010 - The Movie

2009-07-11T01:10:00.007+01:00

Trailer for Office 2010

I try and keep the contents of this page original and first hand. That said, I know my limitations when it comes to video! The official trailer site here.

Office 2010 - Publisher II

2009-07-10T20:46:00.019+01:00

Office Publisher 2010

To demonstrate how Publisher 2010 works I’ve decided to take a piece of text of three short paragraphs in length, use a landscape page layout with three columns. Half of the last column will be used for an image and the top of the first two columns will contain a title. The problem to be resolved is to fit the text perfectly into the remaining space.

The text I will use it taken from the Microsoft Security Essentials home page. There are several reasons for returning to the page (it’s the same page used in PowerPoint IV). Firstly, the program, when it is released, will be free so there is no issue with advertising it. Secondly, the page has lived its short life, it appeared on June 23 to launch the limited (I think it was 75,000 downloads) beta version which in turn was limited to 3 specific countries. And lastly, I have the page bookmarked for later reference.

Open Publisher, the program opens on the New Tab from the Office Button. I will use a landscape format but, for now, I will open the Blank A4 (Portrait). Go to the Page Design Tab > Page Setup > Orientation and select Landscape.

Still on the Page Setup Group, click Margins, at the bottom of the list select Custom Margins.

On the Layout Guides select the Grid Guides Tab > Column Guides > Columns and increase the number to 3, leave the Spacing at 0.5cm, Rows at 1 click and close.

We now have thin blue lines (Guides) separating the columns. Select Insert > Text > Draw Text Box. Drawing objects, in this case a text box, between the guides is quick and easy. Place the cursor anywhere near the blue line and the box will snap to the guides. Insert three boxes using the full size of the columns.

Reduce the height of the first two boxes by about 1.5cm using the side ruler has a guide. Shorten the size of the third column by half, leaving a space at the bottom. We now need to connect the boxes so the text will flow from one to the other.

With box one (left) selected, from the Text Box Tools > Format Tab > Linking, click Create Link, click on the Text Box you want to link to (middle). A pointer will appear on the left of the middle box pointing to the box it is linked to, and vice versa. Click on the middle box, to select it and repeat the process linking it to the box to its right. The reason for linking the boxes is that when we paste the text into box one the overflow will appear in boxes two and three.

I will now go back to the Microsoft website, copy the three paragraphs and paste them into text box one. The text has filled column one and part of column two.

Unfortunately, Publisher has used hyphenation (added hyphens "-", on the ends of lines). With the text highlighted go to Text Box Tools > Format > Text > Hyphenation, in the dialogue box deselect 'Automatically hyphenate this story'.

Returning to box one, highlight the heading ‘Collection and use of your personal information’. Change the size and type of font in the Home Tab to Times New Roman, 26pt bold, highlight the rest of the text and change its size to 12pt and justify the text (excluding the heading).

The intention is to fill the third box fully without adding anymore txt. Highlight the ‘W’ from ‘When’, the first letter of the first sentence, Text Box Tools > Format > Typography > Drop Cap. Click Drop Cap > Custom Drop Cap > Dropped > Size of letters: 4. Repeat the process for the first letter of the other two paragraphs changing the Size of letters: 2. Change the font of the three letters, W, E & M to Times New Roman and their colour to Accent 3 from the Scheme colours Home > Font > Font Colour.

With all three paragraphs highlighted, including the heading, go to the Home Tab > Font > Character Spacing > More Spacing. From the dialogue box Character Spacing > Kerning > Use this option to fine-tune the spacing between two characters. Expand: By this amount: 1.6pt (sometimes you have to play around with it until you get the right size). The text will now have filled the third column.

From the Insert Tab add an image, Insert > Illustrations > Picture, drag the image to the space in the bottom right, resizing if necessary. Insert a text box for the title, Insert > Draw Text Box and type in the title. With the title highlighted set the font size to 36pt. In Drawing Tools > Format > Shape Styles choose an appropriate style, in this case Linear Up Gradient - Accent 1.

See how it looks

Office 2010 - Publisher

2009-07-09T19:32:00.027+01:00

Office Publisher 2010

Microsoft Office Publisher 2010 is a Desktop Publishing software (DTP). By nature DTPs have always been very expensive and, although Microsoft’s Publisher is well known, it has to be said that it is at the low end of the market, a professional publisher is more likely to use a product like Adobe InDesign (and pay the price, Amazon has just informed me that for a mere £637.76 I can be the proud owner of InDesign CS4).

What Microsoft Office Publisher does is put high quality desktop publishing software in the hands of small businesses and ordinary people producing posters, business cards, newsletters and a countless list of other media (actually the list isn’t endless so I’ll be showing a complete list of Publisher templates later). I won’t be using a template for the example that will follow after an overview of the program.

The Ribbon Tabs and their Groups

Home:

Clipboard
Font
Paragraph
Styles
Objects
Editing

Insert:

Pages
Tables
Illustrations
Building Blocks
Text
Links
Header & Footer

In Office Publisher 2007, which didn’t have the Ribbon, Design Gallery Objects were/are accessible from the Insert menu, Insert > Design Gallery Object > Design Gallery. Office Publisher 2010, on the Insert Tab, has the Group Building Blocks. The categories of Building Blocks (Design Objects) are:

Building Blocks Library

Advertisements
Business Information
Calendars
Design Accents
Page Parts

Page Design:

Template
Page Setup
Layout
Pages
Schemes
Page Background

Mailings:

Start
Write & Insert Fields
Preview Results
Finish

View:

Views
Layout
Show
Zoom
Window

When a Placeholder (textbox) is selected the Drawing Tools and Text Box Tools Format Tabs are available.

Drawing Tools

Format:

Insert Shapes
Shape Styles
Shadow Effects
3-D Effects
Arrange
Size

Text Box Tools

Format:

Text
Alignment
Linking
Effects
Typography

In addition, when a picture is added, the Picture Tools Format Tab is available. Its Groups are:

Picture Tools

Format:

Adjust
Swap
Picture Styles
Shadow Effects
Arrange
Size

The Office (Publisher) Button

Info

The Save As options:

Publisher Files
Publisher Template
Publisher 98 Files
Publisher 2000 Files
Unicode Text Files
PostScript
PDF
XPS Document
Plain Text
Single File Web Page
Web Page, Filtered
Rich Text Format
Works 6.0 – 9.0
Word 2007 Macro-enabled Document
Works 6 – 9 Document
Word 2007 Document
Word 97-2003 Document
GIF Graphics Interchange Format
JPEG File Interchange Format
Tag Image File Format
PNG Portable Network Graphics Format
Device Independent Bitmap
Windows Metafile
Enhanced Metafile

Recent

New

These are the ‘out of the box’ Templates included in Office Publisher 2010:

Advertisements
Award Certificates
Banners
Brochures
Business Cards
Business Forms
Calendars
Catalogs
E-mail
Envelopes
Flyers
Gift Certificates
Greetings Cards
Import Word Documents
Invitation Cards
Labels
Letterhead
Menus
Newsletters
Paper Folding Projects
Postcards
Programs
Quick Publications
Resumes
Signs With Compliments Cards

Publisher Options

Options

General:

Change the most Popular options in Publisher.

Top options for working with Publisher
Personalise your copy of Microsoft Office

Proofing:

Change how Publisher corrects and formats text.

AutoCorrect options
When correcting spelling in Microsoft Office programs
When correcting spelling in Publisher

Language:

Set the Office Language Preferences.

Choose editing languages
Choose display land Help languages
Choose ScreenTip Language

Save:

Customise how documents are saved.

Save documents

Advanced:

Advanced options for working with Publisher.

Editing options
Display
General
Print

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:
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 Publisher Trust CenterTrust Center Settings

Next, Publisher II

Office 2010 – PowerPoint IV

2009-07-08T22:47:00.012+01:00

Office PowerPoint 2010 – Continued

Having chosen the slide format from Page Setup, (see Office – PowerPoint III) click on View Tab > Master Views > Slide Master. Formatting the background, Text format and images individually will take time so we use the Slide Master to make a Master Slide whose characteristics will appear in every slide in the presentation.

The Slide Master Tab Groups are:

Edit Master
Master Layout
Edit Theme
Background
Page Setup
Close

It is important to close the Slide Master before adjusting individual slide content otherwise the content will be added to every slide in the presentation.

The subject of the presentation is Microsoft Security Essentials. The program, originally codenamed ‘Moro’ (most Microsoft applications have pre-release names) was released in beta version last month (June 23) in a small handful of countries.

The small handful is in fact three countries, United States (Microsoft’s home base) Israel (where the ‘Morro’ development team are) and Brazil (Microsoft’s target launch market). The version I use was ‘borrowed’ from the internet (series of tubes).

Microsoft Security Essentials (beta version) is a free Anti-virus/Malware/Spyware suite and successor to Windows Live OneCare and will allegedly be released by the end of 2009.

On the Slide Master Tab I prefer to set the background and images before setting the text format, that way you can see how the text will look against the background that will be constant throughout the presentation.

Right-click on the slide, select Format Background

From the Format Background box Fill > Picture or texture fill > Insert from: choose your background image, Apply to All and Close.

Click/Select the textbox at the top of the slide and select/evidence the text ‘Click to edit Master title style’, when an object is selected the Drawing tools are visible, with the text highlighted Drawing Tools > Format > WordArt Styles. I’ve selected the first one:

Fill – Tan, Text 2, Outline – Background 2

In the lower textbox I will delete all but the Third level, change the font to a serif font (serif fonts are the ones with the curly bits on the end of the letters ‘semi-structural details’, sans serif, the title text, are without) the serif font selected is Times New Roman. I will also add two images which will appear on each slide, close the Master Slide.

I will use text directly from the beta website to describe the program, (I will review it fully closer to its release date) and add slides from Home Tab > New Slide when needed.

Having added the text go to the Transitions Tab > Transition to This Slide, my own preference is the Checkerboard. A Transition is the animation which moves from one slide to the next. To keep it simple and to save time (it’s also a nice effect) I will keep the same Transition throughout the presentation by clicking Apply to All. In Effect Options I selected ‘From Top’ (the other option being 'From Left').

In Transitions > Timing > After, set the time to 00:05.00. Click the Slide Show Tab > Start Slide Show > From Beginning. Run the presentation.

Here is how the presentation should look:

Office 2010 – PowerPoint III

2009-07-07T21:15:00.030+01:00

Shop at Amazon.co.uk!

Microsoft Office PowerPoint 2010 – Continued

Before I look at how to create a presentation in PowerPoint here are the options from the Office Button.

The Office (PowerPoint) Button:

Info

Recent

New

PowerPoint Options

Options

General:

General options for working with PowerPoint.

User Interface options
Personalise your copy of Microsoft Office

Proofing:

Change how PowerPoint corrects and formats your text.

AutoCorrect options
When correcting spelling in Microsoft Office programs
When correcting spelling in PowerPoint

Save:

Customise how documents are saved.

Save presentations
Offline editing options for document management server files
File merge options for shared document management server files
Preserve fidelity when sharing this presentation:

Language:

Set the Office Language Preferences.

Choose editing languages
Choose display and Help languages

Advanced:

Advanced options for working with PowerPoint.

Editing options
Cut, copy and paste
Chart
Image Size and Quality
Display
Slide Show
Print
When printing this document
General
Web Options

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 PowerPoint Trust Center
Trust Center Settings

Creating a PowerPoint Presentation

Open PowerPoint from the start menu, here I’m using Windows 7 32bit but the same applies to Windows XP, Vista Etc. Start > All Programs > Microsoft Office > PowerPoint 2010. The program opens with a default 4:3 slide showing the Home Tab.

You can, of course, create a new presentation using an existing template or theme, Office Button > New > Available Templates and Themes. Click on the icons to see a preview (at the moment the online content isn’t active but will be when the application is officially released).

For now I will be starting a presentation from scratch although I can add a theme at any point from the Design Tab.

Save

Before I do anything to anything I will give it a name and save it. Although PowerPoint hasn’t crashed here it has crashed several times whilst running the 32bit version on a 64bit drive. Having crashed, the program restarted itself with a list of last saves and auto saves to choose from.

Regardless of PowerPoint having its own safety net, most Office 2010 applications do; exceptions being OneNote saves everything and Access database entries are automatically updated, I like to know where a document is and its name.

A logical place to keep the file is My Documents > Office > PowerPoint and a descriptive, appropriate name for it is, in this case ‘officetwoten.pptx’. It has been saved with PowerPoint’s default PowerPoint Presentation format.

The complete list of Save As options are:

PowerPoint Presentation
PowerPoint Macro-Enabled Presentation
PowerPoint 97-2003 Presentation
PDF
XPS Document
PowerPoint Template
PowerPoint Marco-Enabled Template
PowerPoint 97-2003 Template
Office Theme
PowerPoint Show
PowerPoint Macro-Enabled Show
PowerPoint 97-2003 Show
PowerPoint Add-In
PowerPoint 97-2003 Add-In
PowerPoint XML Presentation
Single File Web Page
Web Page
Windows Media Video
GIF Graphics Interchange Format
JPEG File Interchange Format
PNG Portable Network Graphics Format
TIFF Tag Image File Format
Device Independent Bitmap
Windows Meta File
Enhanced Windows Metafile
Outline/RTF
PowerPoint Picture Presentation
OpenDocument Presentation

Page Setup

The first thing I would do having saved the presentation is decide the slide format. For me there is no choice to be made, if there is the possibility to present something in 16:9 format, I will use it.

Golden mean

The Golden mean (Golden section/Golden ratio) in both mathematics and art are the proportional qualities of the whole in relation to the section divided from it when the larger (whole section) is the same proportion as the smaller section. There are no, to the best of my knowledge, aesthetic or mathematical values to the 4:3 ratio (unless your screen is that proportion and you want to fill it).

From the Design Tab click Page Setup and from the dropdown list choose the appropriate setting. Slides sized for options are:

On-screen Show (4:3)
On-screen Show (16:9)
On-screen Show (16:10)
Letter Paper (8.5x11in)
Ledger Paper (11x17in)
A3 Paper (297x420mm)
A4 Paper (210x297)
B4 (ISO) Paper (250x353mm)
B5 (ISO) Paper (176x250)
35mm Slides
Overhead
Banner
Custom

I have selected On-screen (16:9) leaving the Slide orientation Landscape and Notes in Portrait, click Ok.

Next, PowerPoint continued...

Shop at Amazon.co.uk!

Office 2010 – PowerPoint II

2009-07-06T02:13:00.007+01:00

Microsoft Office PowerPoint 2010 (Presentation)

A screen recording using PowerPoint 14

Next, PowerPoint continued...

Shop at Amazon.co.uk!

Office 2010 – PowerPoint

2009-07-05T23:29:00.009+01:00

Microsoft Office PowerPoint 2010

Microsoft Office PowerPoint 2010 is a slide presentation program. A presentation program, of which there are many, includes three basic functions. 1. The text editing/formatting capabilities. 2. The graphic and media insertion. 3. A display program to show the presentation.

There are, of course, alternatives to Microsoft Office applications and later I will be comparing them with their Open source counterparts, the most attractive, and probably the only plausible one, being the OpenOffice project. Having previously only produced presentations using Office PowerPoint 2003/07 I’m looking forward to see how OpenOffice Impress compares to PowerPoint, not to mention the other OpenOffice applications.

PowerPoint started its life as Presenter, owned by the Forethought Company in California. In 1987 it was released as PowerPoint for the Mac, later that same year it was acquired by Microsoft and ever since has been used widely and is still considered the most effective form of persuasive technology by many.

One ironic fact about PowerPoint and other presentation software is that they use what are known as ‘slides’. Slides themselves, and slide projectors, were made obsolete by the use of programs like PowerPoint for slide presentations.

The PowerPoint Tabs and Groups are:

Home:

Clipboard
Slides
Font
Paragraph
Drawing
Editing

Insert:

Tables
Images
Illustrations
Links
Text
Symbols
Media

Design:

Page Setup
Themes
Background

Transitions:

Preview
Transition to This Slide
Timing

Animations:

Preview
Animation
Custom Animation
Timing

Slide Show:

Start Slide Show
Set Up
Monitors

Review:

Proofing
Language
Comments
Compare
OneNote

View:

Presentation Views
Master Views
Show
Zoom
Colour/Grayscale
Window
Macros

Add-Ins:

Custom Toolbars

Drawing Tools (Appears when an object is selected)

Format:

Insert Shapes
Shape Styles
WordArt Styles
Arrange
Size

Next, PowerPoint continued...

Shop at Amazon.co.uk!

Office 2010 - Outlook III

2009-07-05T01:01:00.010+01:00

Office 2010 Outlook 14 – Daily Task List Tool

In Calendar View the Daily Task List Tools opens. The Daily Task List Tab Groups are:

Actions:

Open
Move
More Actions

Respond:

Reply
Reply All
Forward

Manage Task:

Mark Complete

Remove from List

Follow Up:

Today
Tomorrow
This Week
Next Week
No Date
Custom

Arrangement:

Arrange By

Tags:

Categorise
Follow Up
Private
High Importance
Low Importance

Tags: Follow Up

Find:

Back to Outlook later...

Office 2010 – OneNote III

2009-07-04T20:54:00.003+01:00

Microsoft Office OneNote 2010 – Continued

Having used Office OneNote 2010 for a couple of days now I can see why many people have already incorporated it into their daily routine. It is easy to see how, some of the time saving features and the convenience of having all your ‘bits’ in one place, make it a useful and powerful tool to have at hand.

I can take a paragraph, from this document for example, select it and drag it to the Side Note and drop it ready to be assigned a location from the Unfiled Notes to whichever Section or Page it is intended for.

Here is the Side Note

A simple table can be created by hitting the Tab key after typing anywhere on the page, continue hitting Tab after each entry to create the column headings. Use the Down Arrow to comple the table.

The ‘hidden’ calculator in OneNote is very useful. Just type the sum anywhere on the page and hit the space bar after the equals sign.

The Office (OneNote) Button

Info

Open

Save As

New

OneNote Options

Options

General:

General options for working with OneNote.

User Interface Options
Default font
Personalise your copy of Microsoft Office

Display:

Change how OneNote looks.

Display

Proofing:

Change how OneNote corrects and formats your text.

AutoCorrect options
When correcting spelling in Microsoft Office programs
When correcting spelling in OneNote

Save & Backup:

Customise how OneNote saves and backs up your notes.

Save
Backup
Optimising files
Cache file location

Send to OneNote:

Customise how OneNote integrates with other applications.

Send to OneNote
Outlook Items
Other content

Audio & Video:

Customise how OneNote makes and plays audio and video recordings.

Audio & Video
Audio Search

Language:

Set the Office Language Preferences.

Choose editing languages
Choose display and Help languages

Advanced:

Advanced options for working with OneNote.

Editing
Linked Notes
Pen
E-mail sent from OneNote
OneNote Mobile
Battery Options
Tags
Passwords
Search
Text recognition in pictures
Other

Customise Ribbon:

Customise the Ribbon.

Choose commands from:
Customise the Ribbon:
Net 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
Legacy Add-ins

Trust Center:

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

Protecting your privacy
Security & more
Microsoft Office OneNote Trust Center
Trust Center Settings

Next Office 2010 PowerPoint...

Office 2010 - OneNote II

2009-07-03T23:50:00.003+01:00

Office 2010 - OneNote (The Movie)

Next OneNote continued...

Office 2010 – OneNote

2009-07-03T21:59:00.003+01:00

Microsoft Office OneNote

OneNote reminds me a bit of the Lotus Organiser, (I know there is a version still available if one form or another but I’m referring to the Windows 95 Lotus SmartSuite version) it’s that place where you can keep those odds and ends all in one place and know exactly where they are.

Microsoft Office OneNote is a multi-user information gathering application most useful when you’re on the move using a Tablet Pc or Laptop.

OneNote opens with a useful Getting Started with OneNote guide from the Notebooks Sections Tabs (listed on the left of the main window).

The default Section Tabs are:

Work Notebook:

Meeting notes
Project A
Project B
Research
Travel
Planning
Miscellaneous

Personal Notebook:

Personal information
Shopping
Books, movies and music
Travel
Recipes
To do
Miscellaneous

OneNote 2010 Guide:

Getting Started with OneNote
More Cool Features

The OneNote Ribbon Tabs/Groups are:

Home:

Clipboard
Basic Text
Styles
Tags
Outlook

Insert:

Tables
Illustrations
Links
Files
Recording
Time Stamp
Symbols

E-mail
Unread
Shared Notebook
History

Draw:

Tools
Insert Shapes
Edit
Convert

Review:

Spelling
Language
Notes

View:

Views
Authors
Page Setup
Zoom
Window

Has a non-OneNote user, but at the same time, has someone who needs an organiser, OneNote is an interesting proposition. An interesting feature is the lack of a save button/icon. Everything is automatically updated and saved.

There is of course, on the Office Button, a Save As option where Notebooks, Sections and Pages can be saved.

The Notebook file format is .onekg (OneNote notebook archived in a single file). Pages and Sections have the .one format. All three can be Saved As:

PDF .pdf
XPS .xps
Single File Web Page .mht

New Notebooks can be created through the Office Button.

Note Containers are the little, or large, bordered windows into which the contents of the page on a Section are; typed, copied, linked, sent, brought, dragged or by whatever means, inserted onto the page. Once there they can be resized and arranged in any order.

If at any point you encounter something you can’t copy, in this case an image from Google Maps, from the Insert Tab select Screen Clipping and drag an area around the map which will be inserted automatically has a Container

Also in this example I will drop a photo and a couple of links. A disadvantage of not having to save anything is you get to keep everything. At the bottom left of the main window, under Notebooks, there are Unfiled Notes. If you lost something that’s where it stays until it is allocated. It is also where any unwanted notes are kept.

Click once on Unfiled Notes, a list of saved Pages/Notes will appear in Tabs on the upper right. New Pages, SubPages and Page Templates can be created from the dropdown.

Next, OneNote continued...

Office 2010 - Access II

2009-07-02T23:52:00.002+01:00

Microsoft Office 2010 - Access 14

Next, OneNote

Office 2010 – Access

2009-07-02T20:41:00.002+01:00

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

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...

Office 2010 - Outlook II

2009-07-01T21:03:00.003+01:00

Part 9 – Outlook (Overview)

Having closed the Setup Wizard (Part – 8) the main Outlook window will open and it will retrieve the contents of your email from your webmail account.

Outlook 2010, like its predecessors is both a complex and controversial piece of software. For the moment I will be sticking to a basic overview of the program structure, returning to advanced features and settings later. Has you can see from the screenshot Outlook 14 has the now familiar Ribbon and tabs. The main window is divided into sections, how many depends on preference and requirement. In this case three: Folders, conversations and the content of the selected item.

The selected (open conversation) email in this case has a link at the top of the page 'To view email has a webpage, go here'. One click will open the convesation in a browser window.

The Ribbon, Tabs and Groups on the Outlook 14 window are:

Home:

New
Delete
Respond
Quick Steps
Actions
Tags
Find

Send / Receive:

Send & Receive
Download
Headers
Preferences

Folder:

New
Actions
Clean Up
Favorites
Properties

View:

Current View
Arrangement
Layout
Window

Add-Ins:

Custom Toolbars

The Office (Outlook) Button:

Info

Open

Saving

Outlook Options

Are there options in Outlook 2010?

General:

General options for working with Outlook

User Interface options
Personalise your copy of Microsoft Outlook
Start Up options

Mail:

Change the settings for messages you create and receive.

Compose messages
Message arrival
Conversation Clean Up
Replies and forwards
Save messages
Send messages
MailTips
Tracking
Message format
Other

Calendar:

Change the settings for calendars, meetings and time zones.

Work time
Calendar options
Display options
Time zones
Scheduling assistant
Resource scheduling

Contacts:

Change how you work with your contacts.

Names and filing
Linking
Contacts index
Online status
Outlook created contacts

Tasks:

Change the settings that track your tasks and to-do items.

Task options
Work hours

Notes and Journal:

Change the settings for Notes and the Journal.

Notes options
Journal options

Search:

Change how items are searched with Instant Search.

Sources
Results

Mobile:

Change the settings for mobile notification and messaging.

Calendar Summary
Mobile Reminder
Mobile Notification
Mobile Options

Language:

Set the Office Language Preferences.

Choose editing languages
Choose display and Help languages

Advanced:

Options for working with Outlook

Outlook panes
Outlook start and exit
AutoArchive
Reminders
RSS Feeds
Send and receive
Developers
Dial-Up connections
International options
Offline editing options for document management server files
Other

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:
Quick Access Toolbar:
Restore Defaults
Import/Export

Add-Ins:

View and manage Microsoft Office add-ins.

Add-in Options
Add-ins

Trust Center:

Help keep your documents safe and your computer secure and healthy

Protecting your privacy
Security & more
Microsoft Outlook Trust Center

Next, Access 2010