Microsoft Office 2010 - Packaging
| Office Professional Plus (Volume licensing only) |
|
| Office Professional 2010 |
|
| Office Home & Business 2010 (New) |
|
| Office Standard 2010 (Volume licensing only) |
|
| Office Home & Student 2010 (Non-commercial license) |
|
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.
Create a form that lets you enter information for one record at a time.
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.
Create a form with no controls or format.
Automatically create a form choosing fields from Tables or Queries
Create a web form that shows multiple records at once.
Enters the Form Tools > Datasheet Tab to create a form directly from the Datasheet.
Create a Modal Dialog from Form Design Tools
Create a PivotChart from the PivotChart Tools > Design Tab
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.
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:
Insert:
Design:
Data:
Process:
Preview:
View:
Office (Visio) Button
Options
General:
General options for working with Visio.
Proofing:
Change how Visio corrects and formats your text.
Save:
Customise how documents are saved.
Language:
Set Office Language Preferences.
Advanced:
Advanced options for working with Visio.
Customise Ribbon:
Customise the Ribbon.
Quick Access Toolbar:
Customise the Quick Access Toolbar.
Add-Ins:
View and manage Microsoft Office add-ins.
Trust Center:
Help keep your documents safe and your computer secure and healthy.
Microsoft Office Project 2010
Task:
Resource:
Project:
View:
Format:
Office (Project) Button
Options
General:
General options for working with Project.
Display:
Change how Project content is displayed on the screen.
Schedule:
Change options related to scheduling calendars, and calculations.
Proofing:
Change how Project corrects and formats your text.
Save:
Customise how projects are saved.
Advanced:
Advanced options for working with Project.
Customise Ribbon:
Customise the Ribbon.
Quick Access Toolbar:
Customise the Quick Access Toolbar.
Add-Ins:
View and manage Microsoft Office add-ins.
Trust Center:
Help keep your documents safe and your computer secure and healthy.
Links to previous posts:
Access Access II (Video) Access - Database
Access - Database II Access - Database III
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
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)
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)
Excel 2010 (Available Templates)
InfoPath 2010 (Available Form Templates)
Popular Form Templates
Advanced Form Templates
InfoPath 2007 Form Templates
Template Parts
PowerPoint 2010 (Available Templates and Themes)
Word 2010 (Available Templates)
Sample Templates
Office Online Templates (Not yet Available)
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
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
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.
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:
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.
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.
With the CSV file save somewhere on your computer, I usually download files that will only be used once to the desktop.
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.
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)
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.
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
