Friday, July 31, 2015

Script Bling

Page spice


Would you like to add an animation to your web page but don't know how to script?
SimplyTheBest.Net has a nice selection that can be easily pasted into your code.

Here are a few examples:
Animated page title script
A script that lets you animate the page title in the browser.
Animated message page
This script displays text messages on an introduction page before redirecting it to another page.
Bouncing image script
A script with which you can make an image bounce across the page.
Circling images
A script that will draw a circle consisting of a set of images around your mouse pointer.
Dynamic animation
This script can be used to fly text or images onto the browser screen from different directions.
Falling images
With this script you can make images fall down and then disappear from your page.
Floating images
A script that will float one or several images around the screen.
Search light
This DHTML script creates a search light effect on images using a start/stop link.
Transition effects
A script you can use to create transitions between images.
Text animation
A script to animate and fade in and/or fade out with text.

See:
Daniel Eden: Animate CSS



See all Topics

Thursday, July 30, 2015

Edit Open With

Pruning tips


"When you right click certain files, you'll see a selection to "open with," and when you click it, you'll see a list of programs to choose from. You can remove some of the applications from this list if you will never use them to open this type of file, or you can clear the list completely, by editing the registry.
  1. Open the registry editor.
    (Start>Run Regedit will do it)
  2. Go to the following key: HKEY CURRENT USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts
  3. Scroll down the list of file extensions to the one for which you want to edit or clear the list.
  4. Click the + to expand OpenWithList
  5. In the right pane, you should see a list of programs (for example, Word.exe, notepad.exe, etc.).
  6. Click the one(s) you want to remove. Press the Delete key.
If this doesn't remove the program(s) you want to remove,
  • Go to: HKEY CLASSES ROOT
  • Scroll to the desired file extension
  • Click OpenWithList, and remove the program there
(The settings under HKEY CURRENT USER apply only when your user account is logged on. The ones under HKEY CLASSES ROOT apply to all users).


See all Topics

Wednesday, July 29, 2015

Jagged Text on Chart

Animation problem


"The text in a graph may appear jagged and less defined if you apply a custom animation to a Microsoft Graph chart object in a Microsoft Office PowerPoint 2003 slide show. The affected text includes the axis text, the legend text, and other text labels.

This problem occurs because PowerPoint 2003 converts the various graph elements to screen-resolution bitmaps. Therefore, PowerPoint 2003 can independently animate the graph elements during a slide show. If the graph elements are converted without a background color applied to them, the text appears jagged."


Some solutions:
  • Apply a background color to the chart area
  • Apply a background color to the graph elements
  • Change the color of the graph font to white
Knowledge Base article 891826

Also see:
Ungroup and Animate



See all Topics

Tuesday, July 28, 2015

Data Comparison

No formulas


The Data Consolidation technique allows you to compare lists quickly and easily.

With the Consolidation technique, you can identify the number of duplicate entries in two or more lists without using a formula.
(not that it's easier, just that there are no formulas)

Example:

In the sheet there are two lists: List 1 is in column A (in cells A2:A10), and List 2 is in column C (in cells C2:C10).

  1. In Cell B1 type "List number".
  2. In Cells B2:B10, enter the number 1.
  3. In Cells D2:D10, enter the number 2.
  4. Cut Cells C2:D10 and paste them into Cell A11.
  5. Press Ctrl+*, then press Ctrl+F3, and enter a name for the list (such as Compare).
  6. Select cell D4 or another worksheet.
  7. From the Data menu, select Consolidate.
  8. Select Count as the Function.
  9. In the Reference box, press F3 and paste the Name you defined for the list.
  10. Click Add.
  11. Select both Top row and Left column "Use labels in" checkboxes.
  12. Click OK.


The numbers appears in Column B are the totals of the list number in Column B. If the result = 1, the name appears in List 1 and does not appear in List 2. If the result = 2, the name appears in List 2 and does not appear in List 1. If the result = 3, the name appears in both lists (1+2=3). The action is not dynamic, so if you make changes, the Consolidation must be rerun.

From: "Mr Excel ON EXCEL"

Also see: John Walkenbach:
Comparing Two Lists With Conditional Formatting

Chip Pearson:
Duplicate And Unique Items In Lists

Here's a more complex method: Microsoft Office Online:
Use Excel to compare two lists of data

Also: BetterSolutions.com:
What are Consolidated Worksheets ?



See all Topics

Monday, July 27, 2015

Access Data-Excel Spreadsheets

Distribute to everyone


Many times an office will provide Excel for all users, but not want or need to also install Access on every desk.

Helen Feddema has laid out a method to use the data in an Access database to create Excel workbooks. These workbooks can then be e-mailed to employees to be used to record time spent on projects.

The code provided is above the entry level user, but understandable.

There is a downloadable file that includes the instructions and samples of the Access and Excel files.

Go to Access Archon Columns from Woody's Office Watch.

The pertinent file is down near the bottom of the page. Look for article 127 and download accarch127.zip.



See all Topics

Sunday, July 26, 2015

Coin Pictures

Will not fit in vending machines


Would you like to use a very good coin graphic with your project or report?



Here's a collection of images of most all the well known coins in multiple resolutions.

The Coin Page

"Welcome to the Coin Page. This site is intended to provide high quality coin and coin related images for public use. So if you offer an image of a coin you must agree to allow public use of the image. You may reserve the right to forbid the sale of your image in any form."




Also:
MoneyInstructor.com:
Printable Play Money



See all Topics

Saturday, July 25, 2015

Video Tutorials

Free instructions


Michael Alexander has produced a collection of about 60 online video demonstrations of some interesting Excel maneuvers.

Topics include:

Basic Excel Concepts

  • Using "Paste Special"
  • Using Text to Columns
  • Tips on Filtering with "AutoFilter"
All About Pivot Tables
  • Create a Basic Pivot Table
  • Sorting in a Pivot Table
  • Create a Drill Down Effect with a Pivot Table
All About Charts
  • Create Dynamic Chart Labels
  • Create a Thermometer Effect in your Column Charts


And More:
DataPig Technologies



See all Topics

Friday, July 24, 2015

Forward My Email

Let it follow you around



By using a rule that you create, Outlook can examine each message that you receive for certain characteristics and then automatically forward or redirect any message that matches the characteristics to another email account.

There are a couple of ways of doing it: forwarding and redirecting.


Message forwarding
When a rule automatically forwards a message you receive, it leaves a copy of the message in your Inbox or in the folder to which the message was originally delivered. The rule then adds the designation "FW:" to the beginning of the Subject line, changes the message formatting, and then forwards the message to the account specified by the rule. The recipient represented by the account also sees that the message came from you.
Message redirection
When a rule automatically redirects a message you receive, it also leaves a copy in your Inbox or in the folder to which the message was originally delivered. The rule then sends the message, unchanged, to the account specified by the rule. To the recipient, the message appears as though it came directly from the original sender. There is no indication that the message was delivered by way of your account.

Indiana University:
Automatically forward all of my mail to another address

Also:

Office.Microsoft.com:
Automatically forward messages to another email account

James S. Huggins' Refrigerator Door has this information:
Creating Another Email Address

Slipstick.com:
Automatic Message Processing Tools



See all Topics

Thursday, July 23, 2015

Free Fonts

More choices


Windows no longer has a maximum number of fonts that can be installed. (Windows Me and before was limited to about 1000 or 64 KB.) The problem is that your machine will slow down if you go overboard. It's better to install the most used typefaces, and then move the fonts into and out of the C:\Windows\Fonts or C:\WINNT\Fonts folder.

Here's one site that provides over 5,000 fonts. You can enter a short piece of text to see what it will look like:
"The fonts presented on this website are their authors' property, and are either freeware, shareware, demo versions or public domain, most of the time for non-commercial use. Look at the readme-files in the archives or check the indicated authors' website for details, and contact him if in doubt."


Dafont.com
 

Also:
Free Fonts




6-17-2005 - Bill Reid comments:
"One little known fact about Windows' font handling. You don't necessarily have to move fonts into the Fonts directory to make them usable. If you store extra fonts in another directory, you can double click it, bringing up a dialog that demonstrates the font's usage. If you open your application at this point, it will recognize the font as being installed."




See all Topics

Wednesday, July 22, 2015

Statistics and Excel

What are the chances


"Excel is the widely used statistical package, which serves as a tool to understand statistical concepts and computation to check your hand-worked calculation in solving your homework problems. The site provides an introduction to understand the basics of and working with the Excel. Redoing the illustrated numerical examples in this site will help improving your familiarity and as a result increase the effectiveness and efficiency of your process in statistics."

Dr. Hossein Arsham

The site is very clearly written. While some of the concepts are advanced, Dr. Arsham explains them in simple terms. It is a good introduction to the Analysis ToolPak.

Here are some of the subjects covered:

  • Descriptive Statistics
  • Normal Distribution
  • Confidence Interval for the Mean
  • Test of Hypothesis Concerning the Population Mean
  • Difference Between Mean of Two Populations
  • ANOVA: Analysis of Variances
  • Goodness-of-Fit Test for Discrete Random Variables
  • Test of Independence: Contingency Tables
  • Test Hypothesis Concerning the Variance of Two Populations
  • Linear Correlation and Regression Analysis
  • Moving Average and Exponential Smoothing
The University of Baltimore: Statistical Data Analysis



See all Topics

Tuesday, July 21, 2015

List All Files

All files in a folder


Here is a macro that will produce a list of all the files in a selected folder.
  • The folder name for the listed files
  • The file names of the files found
  • The file sizes of the files found
  • The dates and times of the files found
  • The total number of files listed
Macro to List All Files in a Folder



See all Topics

Monday, July 20, 2015

Highlight Form Data

Show your position


Conditional formatting, in Access, has one more alternative than Excel. Besides "Field Value Is" and "Expression Is", there is "Field Has Focus". You can call attention to the location of the insertion point.
  1. In Design View, in the Detail section, click the Control box.
  2. On the Format menu, click Conditional Formatting.
  3. Under Condition 1, chooseField Has Focus in the first box.
  4. Click the arrow next to the Font/Fore Color button, click the yellow box, and then click OK.



  5. On the File menu, click Save.
  6. On the View menu, click Datasheet View to view the results.
Also see: Using the Value in a Control as Formatting Criteria and Using an Expression as Formatting Criteria Microsoft Office Online: Highlighting data for impact on a form in Access



See all Topics

Sunday, July 19, 2015

Window Lost!

Open, but hidden



Has this happened to you? You dragged the window over to the far right of the screen it has disappears. When the application is started, the window does not open in the main screen but appears minimized on the Taskbar. Even a right click the window to maximize will not open the app.

Try this.

  1. Hold down the Alt key and tap the Tab Key. When you see the desired window, let go of the Alt key.
  2. Hit Alt+Spacebar
  3. Hit M and then use the arrow keys to get the window to the right spot.
  4. Hit Esc when it's near the right spot.
  5. Now drag on the edges of the window to size it. (do not use the Maximize button)
In the future the window should work correctly.



See all Topics

Saturday, July 18, 2015

Spam Definitions

and Other E-mail Pests


The Very Basics:
  • Keep your e-mail address private.
  • Never reply to spam.
  • Use great caution in complaining.
  • Never buy products advertised in spam.
  • Don't forward chain mail.
  • Your bank never asks you to "confirm" your account!
Getting Rid of "Spam", a Spam Primer by Randy Cassingham The basics of spam, how they got your address in the first place, and what to do now.
Cassingham also publishes This is True and The Stella Awards . (The name "Stella Award" has been applied to any wild, outrageous, or ridiculous lawsuits -- including bogus cases )



See all Topics

Friday, July 17, 2015

Mouse Practice

Click quizzers


Unlike the kids today, not all of us were born with a mouse in our pablum glazed paw.

If you have a new user who needs practice using a Mouse, take a look at some of these links. There are some very well done games and some step by step instructions.

Ferry Halim:
Games

Seniornet.org:
Mouse Exercises
  • Placing the mouse
  • Clicking the mouse
  • Drag and drop
  • Drawing with the mouse
USA Quiz
Paper doll game

Queens Borough Public Library, New York:
How to use the mouseClick tester

Shambles.net: (This website is designed to support the international school communities in 17 countries in South East Asia.)
 Mouse skills collection



See all Topics

Thursday, July 16, 2015

Excel Charts for Dummies

Graph-ology


You don't have to be spreadsheet challenged to read this book. Many people become quite adept at using Worksheet functions and even VBA, but have little experience with charting.

This book has some great cartoons, and, by page 361, the reader will be exposed to step by step instructions covering both simple charts and some quite sophisticated graphing.
"Excel Charts For Dummies will show readers how to professionally display data in presentation-quality charts. How to create attractive charts and why to use specific charts in particular circumstances. Lots of real-world examples with step-by-step tutorials. How to embed graphics and pictures into charts; then use them in impressive PowerPoint presentations or Microsoft Word documents. The book features a 16-page full-color insert of the best Excel charts 'works of art.'"

Ken Bluttman is also the author of Excel Formulas and Functions for Dummies, Access Hacks, and Developing Microsoft Office Solutions.




By Ken Bluttman
ISBN 0-7645-8473-1
Wiley Publishing, Inc. 2005


Technical editor Doug Klippert














See all Topics

Wednesday, July 15, 2015

Free Photos

and other graphics


Robin Good has compiled a list of places that provide royalty free images.
" Finding quality images and photos for complementing an important article, essay or news report is already quite a challenge for many. Imagine when the goal is not just too find good images, but find some that you could openly and freely use without needing to pay royalties or one-time publishing rights to someone."

Free Photographs and Other Visuals

A dozen sources are listed including:
PD Photo.org
"PDPhoto.org is a repository for free public domain photos. Unless something is clearly marked as being copyrighted, you can assume it is free to use. But if you intend to use an image you find here for commercial use, please be aware that standards for such use are higher. Specifically, you should assume no model release was obtained. And pictures featuring products or property should be used with care. The photos are here to be used, but I don't want you to get either of us in trouble over it."



Copyright Information



See all Topics

Tuesday, July 14, 2015

Wild Fires

Pictures and history


WildFire.com is maintained by Abercrombie:
" Abercrombie is the dirt digg'in, hose pull'in, shovel flipp'in, dozer boss'in, rotor lov'in, firefighter in all of us. Abercrombie has always had more questions than answers. Abercrombie is unable to stop asking why. He feels people are capable of and willing to do a much better job if they understand the "why" in addition to knowing "how". Abercrombie likes to push people's buttons sometimes to provoke an honest response. Abercrombie has a few of his own buttons get pushed occasionally, although he seems to be getting better at slowing his emotional responses."
WildlandFire.com

Fire Photos



Basic Firefighting Training

Other fire stuff:

How Fire Engines work
Fire Engines

Tacoma Fire Department
Seattle Fire Department
Queensland Fire and Rescue
(Including sirens, like the Phaser).

Wheels of Fire: Famous Fire Engines (Wales)
Fire Museums on the Web

SPAAMFAA, privately owned Fire Trucks
Fire Truck Graveyard



See all Topics

Monday, July 13, 2015

Microsoft Word 2007-2013 Tutorials

How it's done


Microsoft Office Online:
"It's time to get up to speed with Microsoft Office Word 2013. Learn the best ways to use the new Ribbon, get a handle on finding popular commands, and understand what the new file format does for you."

Microsoft Word 2013 Tutorial

Word 2010 for 2003 Upgraders

Also:

BayconGroup.com:

Microsoft Word 2007 Tutorial



See all Topics

Sunday, July 12, 2015

Add Picture to Comment

Also graphs


  1. Right-click the cell that contains the comment.
    (or choose Insert Comment)
  2. Choose Edit Comment, and clear any text from the comment.
  3. Click on the border of the comment, to select it.
  4. Choose Format>Comment
    (or Ctrl+1)
  5. On the Colors and Lines tab, click the drop-down arrow for color.
  6. Click Fill Effects
  7. On the picture tab, click Select Picture
  8. Locate and select the picture
  9. Click Insert, click OK, click OK
Contextures.com
 


YouTube: Add picture to Excel Comment
 
Mary Ann Richardson, on TechRepublic.com, suggests saving a graph as a JPG and using that as a picture in a comment.
 Add an Excel chart to a comment
 




See all Topics

Saturday, July 11, 2015

Make Null Zero

It's nothing


When it is desirable to return a zero (or another value) rather than an empty field, Access (Visual Basic) has a function Nz():

Nz(variant, [valueifnull])

The Nz function has the following arguments.

variant
A variable of data type Variant. Optional (unless used in a query). A Variant that supplies a value to be returned if the variant argument is Null. This argument enables you to return a value other than zero or a zero-length string.
valueifnull

This example demonstrates how you can simplify an IIF function

Instead of:

varTemp = IIf(IsNull(varFreight), 0, varFreight)
varResult = IIf(varTemp > 50, "High", "Low")


You could use:

varResult = IIf(Nz(varFreight) > 50, "High", "Low")

Helen Feddema offers a suggestion about forcing a zero when Nz() doesn't work

When you want to display zeroes in text boxes (or datasheet columns) when there is no value in a field, the standard method is to surround the value with the Nz() function, to convert a Null value to a zero. However, this doesn't always work, especially in Access 2003, which is much more data type-sensitive than previous versions. In these cases, you can force a zero to appear instead of a blank by using two functions: first Nz() and then the appropriate numeric data type conversion function, such as CLng or CDbl. Here is a sample expression that will yield a zero when appropriate:

NoAvailable: CLng(Nz([QuantityAvailable]))

Download a sample from:
ACCESS Watch



See all Topics

Friday, July 10, 2015

Create Your Own Screensaver

Choose your own images


Windows has a feature that allows you to create a screensaver from images saved in a folder.
You can use pictures you already have or use a PowerPoint slide show.
  1. Open the PowerPoint presentation. If you want to save a specific slide, select it in Normal view.
  2. On the File menu, click Save As.
  3. Select an empty folder or create a new empty folder in which to save your presentation or slide.
  4. In the Save as type box, click Device Independent Bitmap, and then click Save. You can keep the original presentation file name or create a new name.
  5. Click Every Slide or Current Slide Only, and then click OK.
  6. Your presentation or slide is saved to the folder that you selected. After you close your PowerPoint presentation, you will use Windows XP to open the presentation or slide as a screen saver.
    (Animations that you may have added to the original presentation will not play when you create the screen saver. )
  7. Close your presentation.

  1. Click Start, click Control Panel, and then click Display, or right-click an empty part of the desktop and choose Properties.
  2. On the Screen Saver tab, click My Pictures Slideshow (Photos in Vista).
  3. Under Screen saver, click Settings.
  4. Under How often should pictures change?, set the slider at the interval you want between pictures, or, if you are making a single slide a screen saver, move the slider to Less (three minutes) to avoid a distracting flicker on the screen during the transitions.
  5. Under Use pictures in this folder, browse to the folder in which you saved the presentation or slide.
  6. If you saved a single slide, clear the Use transition effects between pictures and Allow scrolling through pictures with the keyboard check boxes.
    (screen saver transition effects in this screen saver option are predesigned and do not include the transitions that you set when you created the presentation.)
  7. Click OK.
To preview your new screen saver, on the Screen Saver tab, click Preview.
Create a screen saver from slides



See all Topics

Thursday, July 09, 2015

Secret SS Information

What's on your card?


There's data encoded in your Social Security number! (not a lot, but some).
You can tell in what state the card was issued:

"The first three (3) digits of a person's social security number are determined by the ZIP Code of the mailing address shown on the application for a social security number. Prior to 1973, social security numbers were assigned by field offices. The number merely established that his/her card was issued by one of the offices in that State."

Social Security Number Allocations


If you're an employer, you can verify if the number is valid:
Social Security Number Verification
(There are three types of cards)

Here are some stories about Social Security :

" The most misused SSN of all time was (078-05-1120). In 1938, wallet manufacturer the E. H. Ferree company in Lockport, New York decided to promote its product by showing how a Social Security card would fit into its wallets. A sample card, used for display purposes, was inserted in each wallet. Company Vice President and Treasurer Douglas Patterson thought it would be a clever idea to use the actual SSN of his secretary, Mrs. Hilda Schrader Whitcher.



The wallet was sold by Woolworth stores and other department stores all over the country. Even though the card was only half the size of a real card, was printed all in red, and had the word "specimen" written across the face, many purchasers of the wallet adopted the SSN as their own. In the peak year of 1943, 5,755 people were using Hilda's number. SSA acted to eliminate the problem by voiding the number and publicizing that it was incorrect to use it. (Mrs. Whitcher was given a new number.) However, the number continued to be used for many years. In all, over 40,000 people reported this as their SSN. As late as 1977, 12 people were found to still be using the SSN "issued by Woolworth."

History


Other things on the site include:

Slider puzzles
(Including such luminaries as: Otto von Bismarck, Frances Perkins, and Arthur Altmeyer )

Both Nixon and LBJ recorded conversations in their offices. The SSA has some of them you can listen to about SS matters:
LBJ and Nixon tapes

Social Security Number



See all Topics

Wednesday, July 08, 2015

Save the Screen

Won't someone please!



"AJ Screensaver is a freeware clock screensaver. This screensaver is based on work of others.

Several very interesting clock shockwave flash files are packed in this screensaver."

A variety of clocks appear. The web site gives links to the original artists.
Freeware: AJScreenSaver





See all Topics

Tuesday, July 07, 2015

Switchboard Inflation

Have more controls



You cannot have more than 8 items on a switchboard when you use the Access Switchboard Manager on the Tools>Database Utilities menu. You can, however, modify the Switchboard objects directly.



Here are some step by step instructions:
TECH on the Net:
Create more than 8 switchboard items

Here are some more Switchboard tips:
TECHontheNet


Switchboard 2007

More Switchboard



See all Topics

Monday, July 06, 2015

Appointments to Email

Drag and drop


When you receive a message about an upcoming meeting, you don't have to copy the address and time and then open Calendar and then open a new appointment dialog box.

Just drag the message onto the Calendar icon. A new appointment form will open up with the body of the email. You can then adjust the location and time if needed.

Also see:
Microsoft support:
How to use vCalendar in Outlook

"Microsoft Outlook supports vCalendar, a powerful approach to electronic Personal Data Interchange (PDI). PDI occurs every time individuals communicate, in either a business or personal context. These interchanges frequently include the exchange of information, such as business cards, telephone numbers, addresses, dates and times of appointments, and such. The vCard and vCalendar features facilitate PDI electronically.
This article discusses:
  • How to create a vCalendar file
  • How to distribute a vCalendar file
  • How to automatically process a vCalendar file
  • How to manually process a vCalendar file as a text file"
And:
The Internet Mail Consortium: vCard and vCalendar
Also See: Meeting Methods



See all Topics

Sunday, July 05, 2015

Word Form or Content

Shape or substance



"The legibility of a typeface should not be evaluated on its ability to generate a good word shape.

Word shape is no longer a viable model of word recognition. The bulk of scientific evidence says that we recognize a word's component letters, then use that visual information to recognize a word. In addition to perceptual information, we also use contextual information to help recognize words during ordinary reading, but that has no bearing on the word shape versus parallel letter recognition debate. "

The science of word recognition
by Kevin Larson
From EyeMagazine
Suggested by:
Microsoft Typography

Also see:
Cmabrigde



See all Topics

Saturday, July 04, 2015

Running Total in Comment

Circular solution



You can't have a worksheet formula that looks like this:

=C3+C3

But you can do something similar if you use VBA and store the results in another location.

"In Microsoft Excel you can avoid circular references when you create a running total by storing the result in a non-calculating part of a worksheet. This article contains a sample Microsoft Visual Basic for Applications procedure that does this by storing a running total in a cell comment."

Microsoft Support:
Create a running total in a cell comment

The macro runs each time the value of a cell changes.
It adds the current value of the cell to the value of the cell comment. Then it stores the new total in the cell comment.

I'm sure someone can come up with other uses for this macro.



Also see:

Decision models.com:
Repetitive Calculation Features and Add-Ins

Daily Dose of Excel
Dick Kusleika
Circular References - The Good Kind



See all Topics

Friday, July 03, 2015

Arts and Letters Daily

VERITAS ODIT MORAS


News and reviews of the latest books/magazines/newspapers.

The site also has an RSS feed.
  • Arts
  • Letters
  • Daily News
  • Literature
  • Philosophy
  • Art
  • Ideas
Arts and Letters Daily
 Recent reference:
"Otto Preminger, hearing a group of fellow émigrés speaking Hungarian, said, "Don't you people know you're in Hollywood? Speak German."
(Entertainment Times
QUID VERBA QUAERIS? VERITAS ODIT MORAS
'Why do you look for words? Truth hates delay'
)



See all Topics

Thursday, July 02, 2015

Database Basics

Definition and explanation


About.com has information about every human endeavor.

Here is a piece that introduces Access and databases in general:
"If you're searching for a more flexible data management system, a database might be just the salvation you're looking for.

What is a database? Quite simply, it's an organized collection of data. A database management system (DBMS) such as Access, FileMaker Pro, Oracle or SQL Server provides you with the software tools you need to organize that data in a flexible manner. It includes facilities to add, modify or delete data from the database, ask questions (or queries) about the data stored in the database and produce reports summarizing selected contents.

Microsoft Access provides users with one of the simplest and most flexible DBMS solutions on the market today. Regular users of Microsoft products will enjoy the familiar Windows "look and feel" as well as the tight integration with other Microsoft Office family products.

Microsoft Access Database Fundamentals



See all Topics

Wednesday, July 01, 2015

Calendar Tips and Help

More answers


Malek Tips.com has tips on a myriad of PC topics.
Here are the titles of a few of their Outlook hints:
Start your Calendar Work Week on Monday

If you work a Monday to Friday job, shouldn't Microsoft Outlook's Calendar work the same way?
Keep Others From Suggesting Appointment Times

Keep others from trying to change the times of your appointments in Microsoft Outlook.
Keep Meeting Requests from Being Deleted

File your Microsoft Outlook meeting requests instead of automatically deleting them.
Change the Calendar Workweek

Let Outlook "Work Week" view represent your actual workweek, not a M-F schedule.
Drag and Drop Events

Quickly move appointments and meetings from one day to another in the Outlook 2003 Calendar.
Play Different Sounds Per Appointment

Aurally note when different appointments and meetings occur with Outlook.
Publish More Free/Busy Information

Allow other networked Outlook users to see when you are free for a meeting request months from now.

Outlook Calendar and Meeting Help and Tips



See all Topics