Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal









Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com


  Monday, June 29, 2009 – Permalink –

Access Tools for Free or Fee

Shareware/Freeware


Peter De Baets has some for pay and some for free downloads at Peter's Software.

In the past I have used his Shrinker-Stretcher

ShrinkerStretcher will automatically rescale/resize your MS Access forms, controls, and fonts to fit any screen resolution, desktop scheme, or font setting.

Using ShrinkerStretcher means you can develop applications without concern for your end user's display settings! Scale your 800x600 application down to 640x480, or to any other screen resolution!

For free includes:
ChromaForm
Let your users set their own form color schemes.
Custom Time Functions -
Perform mathematical operations on custom time values that include fractions of a second.
TableLinker
Manage linked tables from multiple databases, ODBC sources, or any combination of the two. Easily refresh table links or connect to tables in a different data environment.




See all Topics

Labels:


<Doug Klippert@ 3:36 AM

Comments: Post a Comment

  Thursday, June 25, 2009 – Permalink –

Compact Before Synchronizing

A DB two step


If you're working with a replicated database, always compact it twice before you synchronize.

The first time you compact, Access marks objects that need to be deleted, but it doesn't actually remove them.

The flagged objects are removed the second time you compact the database. Although there's no harm in additional compacting, there's no added benefit.

This is particularly important to do when working with the Design Master. Each time you make design changes to the Design Master, a copy of the original object is kept in the database.

If you edit and save a Report or Form 10 times, your database actually has 9 older versions of the form in it. The same is true if you change the schema of a Table or Query If you synchronize before compacting, all of the versions are sequentially sent to the other replicas until everything is in synch, and you can't reclaim the space taken up by the older versions.

However, if you compact the database first, only the most recent form version is sent to the replica.




See all Topics

Labels:


<Doug Klippert@ 3:29 AM

Comments: Post a Comment

  Tuesday, June 23, 2009 – Permalink –

Mail Your MDB-ACDB

Don't let Outlook stop you


There was a lot of frustration with Outlook 200x. If an Access MDB file is received, Outlook expects the worst and blocks the attachment.

The trick has been to ZIP the file or change the extension to something like .DAT.

Here's a registry trick that restores Outlook to the good old days.
Outlook 2007, 2003, 2002 and Outlook 2000 SP3 allow the user to use a registry key to open up access to blocked attachments. (Always make a backup before editing the registry.) To use this key:
  1. Run Regedit, and go to this key:

    HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Outlook\Security

    (change 10.0 to 9.0 for Outlook 2000 SP3,11.0 for Outlook 2003, 12.0 for Outlook 2007)
  2. Under that key, add a new string value named Level1Remove.

  3. For the value for Level1Remove, enter a semicolon-delimited list of file extensions. For example, entering this:

    .mdb;.url

    would unblock Microsoft Access files and Internet shortcuts. Note that the use of a leading dot was not previously required, however, new security patches may require it. If you are using "mdb;url" format and extensions are blocked, add a dot to each extension.
    Note also that there is not a space between extensions.
 

If you are using this registry entry, a glance at Help>About Microsoft Outlook will show Security Mode: User Controlled above the license information.
After applying this registry fix or using one of the above tools, the user still has to save the attached file to a system drive before opening it. In effect, the fix rolls the attachment behavior back to Outlook 2000 SR-1, with its included Attachment Security Fix.
An end-user cannot bypass this "save to disk" behavior and open the file directly from the mail message, though an Exchange administrator can.
Slipstick.com:

Opening .exe Attachments


Also see:
Shortcuts for Sending Access Objects via Email


See all Topics

Labels: ,


<Doug Klippert@ 3:33 AM

Comments: Post a Comment

  Sunday, June 21, 2009 – Permalink –

Clip Art at Home

Install more


Do you remember all of the clip art that was available locally with Office XP?

When you have an Internet connection, you have access to the Office Online collection, but if you would like more clip art installed on your machine:


A small amount of sample clip art images was included The 2007 Office systems and Office 2003 and is part of the "local collection" that is searched when you do not have Internet access to the Microsoft Office Online Clip Art and Media Web site. Office 2003 no longer included a media content CD with additional clip art. However, the Microsoft Office XP Media Content CD can still be installed locally or on a network share.

The Office XP Media Content CD contains approximately 35,000 clips that are a subset of the clips that are available on the Microsoft Office Online Clip Art and Media Web site. The Office XP Media Content CD was included with Microsoft Office XP Professional, Microsoft Office XP Standard, and Microsoft Publisher 2002 Deluxe Edition.

To install the contents of the Office XP Media Content CD on a computer, follow these steps:
  1. Exit all programs that are running

  2. Insert the Office XP Media Content CD into the CD drive or into the DVD drive
    (Hold down the SHIFT key to prevent the program from automatically starting. If Microsoft Windows Installer automatically starts, click Cancel)

  3. Click Start, click Run, type the following command, and then click OK: 
    msiexec.exe /i CD_drive:\CAG.MSI ADDLOCAL=ALL /qb
(CD_drive is the letter of the drive that contains the Office XP Media Content CD)
Support.Microsoft.com
How to add clip art to Clip Organizer in a 2007 Office system and in Office 2003




See all Topics

Labels:


<Doug Klippert@ 3:02 AM

Comments: Post a Comment

  Wednesday, June 17, 2009 – Permalink –

VBA Variable Problems

Explicit protection


It's good practice to always use the Option Explicit statement in the beginning of your code modules to ensure that all variables are unambiguously declared in your procedures.

With this process in place, you'll receive a "Variable not defined" error if you try to execute code containing undeclared variables. Without this statement, it's possible to mistype variable names, which would be interpreted as new Variant type variables.

This could severely impact the results of your code, and you might not ever know it. If you do find a problem, tracking down where the error is can be a chore.

Although you can manually type the statement into your modules, changing a setting in Access can ensure that the statement is always added to new modules.

  1. Open a module (start the VBA Editor)

  2. Choose Tools>Options from the menu bar

  3. On the Editor tab of the Options dialog box, select the Require Variable Declaration check box in the Code Settings panel

  4. Finally, click OK





See all Topics

Labels:


<Doug Klippert@ 3:37 AM

Comments: Post a Comment

  Wednesday, June 10, 2009 – Permalink –

Automaticaly Setup a Database

Link in a snap


When you're creating a new database that will link to data that isn't in an Access format, you can speed up the setup process.

Rather than creating a new database and then using the File>Get External Data>Link Tables,

  1. Choose File>Open from the menu bar

  2. Select the appropriate data format from the Files Of Type dropdown list

  3. Open the file as you would any Access database
Access will automatically create an MDB file with the same name as the data source you selected and will set up links to the data.




See all Topics

Labels: , ,


<Doug Klippert@ 3:55 AM

Comments: Post a Comment

  Thursday, June 04, 2009 – Permalink –

Database Examples

Clever timesavers


Roger Carlson, RogerCarlson.com, has collected a group of Access databases that demonstrate different functions.

The Library includes tutorials and a good list of files that can be downloaded.

See the Table of Contents
CascadingComboBoxes.mdb
This sample illustrates how to restrict the value of one combo box based on the value of another
EmailingSpecificReports.mdb
This illustrates how to email the same report with different data to a variety of users
RelinkOnOpen.mdb
This sample illustrates how re-link, automatically, tables if the database has been moved
UIDesign.mdb
Shows a variety of samples of good and bad User Interface design techniques

And many more




See all Topics

Labels: , ,


<Doug Klippert@ 3:34 AM

Comments: Post a Comment

  Saturday, May 23, 2009 – Permalink –

Compact-Repair Shortcut

Desktop convenience


You can make compacting and repairing databases easier by providing a desktop shortcut.

Right-click on the Windows desktop and select New>Shortcut from the shortcut menu. Then, set up a Command Line entry in the form:

"Path to Access.exe" "Path to Database.mdb" /compact

For example, to create a shortcut to compact Northwind, you might use:

"C:\Program Files\Microsoft Office\Office\Msaccess.exe" "C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb" /compact

Click Next and continue through the shortcut setup wizard, naming the shortcut appropriately.

In Access 2000+, the database is both compacted and repaired when the /compact switch is applied.

Access 97 executes these processes separately, so Access 97 shortcuts should use a Command Line in the form:

"Path to Access" "Path to Database" /compact /repair

Also note that you can compact to a different location by specifying a target database name after the /compact switch.

If you omit a target file name following the /compact option, the file is compacted to the original name and folder. To compact to a different name, specify a target file.

If you don't include a path in target database or target Access project, the target file is created in your My Documents folder by default.

(Even though a shortcut will open the database without it, in order for the command line flag to work, you MUST include the path to the executable - Access.exe)




See all Topics

Labels: ,


<Doug Klippert@ 3:31 AM

Comments: Post a Comment

  Sunday, May 17, 2009 – Permalink –

New Fields from Datasheet View

Table fields on the fly



We all, of course, pre-plan our table layouts. However, if you need to create a table field while working in Datasheet view, you don't have to switch to Design view.

There's a quick way to create a field from Datasheet view.

Right-click on the column heading of the column you want to the right of your new field.
Choose Insert Column from the shortcut menu.

Access creates a field with a name such as "Field1".

You can then immediately start entering data in. You can also use the shortcut menu to rename or delete the newly created field.

Later you can go to Design view to set the field's properties.




See all Topics

Labels: ,


<Doug Klippert@ 3:19 AM

Comments: Post a Comment

  Sunday, May 10, 2009 – Permalink –

Shortcuts to Access Objects

Quick way in


If you often work with a certain Access objects (specific forms, queries, etc.) in a database, you can create a shortcut to it on your desktop.

Click on the Object and drag it to the desktop..


Access will create the shortcut on your desktop, or another location.




See all Topics

Labels:


<Doug Klippert@ 3:18 AM

Comments: Post a Comment

  Wednesday, May 06, 2009 – Permalink –

Who was that font I saw you with last night?

That was no font, that was my typeface


You can find the Fonts supplied with some Microsoft products
Select a product name from the list to get a list of fonts supplied with that product.

Microsoft's Typography is an interesting site to poke around in.

Here are some books I use for reference material:

Words into Type

by Marjorie E. Skillin, Robert Malcolm Gay ISBN 0139642625


Stop Stealing Sheep & Find Out How Type Works


by Erik Spiekermann, E.M Ginger ISBN 0201703394


The Elements of Typographic Style

by Robert Bringhurst ISBN 0881791326

A font can be defined as a collection of characters with the same style and size. A typeface is the design of the characters regardless of size or style. The terms are used interchangeably today.




See all Topics

Labels:


<Doug Klippert@ 3:12 AM

Comments: Post a Comment

  Sunday, May 03, 2009 – Permalink –

Crosstab Query Column Headings

Using Month Numbers


If you display a crosstab query as a datasheet, consider using a month's or day's number as a column heading instead of a text abbreviation (e.g., 1 instead of Jan or January, or 2 instead of Mon).

Text abbreviations are sorted alphabetically. Apr appears before Feb, Mon appears before Sun, etc. Number representations will sort in their proper order.




See all Topics

Labels:


<Doug Klippert@ 3:03 AM

Comments: Post a Comment

  Sunday, April 26, 2009 – Permalink –

Composite Keys

Multi-Field Keys


To quickly create a multi-field primary key, while in the table's Design View:
  1. Hold the Ctrl key and click each field that you want to make up the primary key.
  2. Choose Edit>Primary Key from the menu bar, or click the Primary Key button on the toolbar
Access creates the composite primary key for you.

University of Texas at Austin:
Primary and Foreign Keys




See all Topics

Labels: ,


<Doug Klippert@ 3:05 AM

Comments: Post a Comment

  Saturday, April 18, 2009 – Permalink –

Duplicate Table Structures

No need to reinvent


When setting up a database, you may find that there is a table structure in another database that would be appropriate. You could Import the table, but then you have to clear out the useless records.

Here's an easier way to do it:
  1. Choose File>Get External Data>Import from the menu bar
    (External Data tab in 2007, then select Access in the Import group)
  2. Select the database that contains the tables you want to copy and click the Import button.
  3. Select the appropriate tables on the Tables sheet
  4. click the Options button, select the Definition Only option and click OK
.

To export a table definition from your current database to another:
  1. Select the appropriate table in the Database window.
  2. In Access 2000 and above, choose File>Export.
    (If you're using Access 2007, choose More in the Export group)
  3. Click OK.
  4. Now, regardless of version, select the target database and press Enter
When the Export dialog box appears, select the Definition Only option button and click OK. See all




See all Topics

Labels: ,


<Doug Klippert@ 3:42 AM

Comments: Post a Comment

  Wednesday, April 15, 2009 – Permalink –

Date an Octothorpe

Date an Octothorpe


Some more of those things I'm sure I used to know

The keyboard combination of Alt+Shift+D inserts the current date in MS Word and PowerPoint. Ctrl+; (semicolon) does it in Excel and Access.

If you do not like the date's format, select a different one with Insert>Date and Time and, if you would like to make that permanent, click on the Default button in the lower left corner of the dialog box (in PowerPoint it's in the lower right corner).

In Excel, Ctrl+Shift +# formats the entry as day-month-year. Ctrl+1 will display the "Format cells" dialog box.

BTW, the "hash, pound or number" sign # is also called an "octothorpe".

The person who named it combined Octo for the eight points and Thorpe for James Thorpe.

"Bell Labs engineer, Don Macpherson, went to instruct their first client, the Mayo Clinic, in the use of the new (touch tone phone system). He felt the need for a fresh and unambiguous name for the # symbol. His reasoning that led to the new word was roughly that it had eight points, so ought to start with octo-. He was apparently at that time active in a group that was trying to get the Olympic medals of the athlete Jim Thorpe returned from Sweden, so he decided to add thorpe to the end."

While we're at it, the "backwards P, Enter mark" is actually named a "pilcrow".

The pilcrow was used in medieval times to mark a new train of thought, before the convention of using paragraphs was commonplace.

Also see:
Geek-speak names for punctuation marks

Wikipedia:
Punctuation



See all Topics

Labels: ,


<Doug Klippert@ 3:35 AM

Comments: Post a Comment

  Friday, April 10, 2009 – Permalink –

Business Rules!!! ... Rules

Bean Counting Models


Data modeling can be an exhausting, time consuming process. Here are some samples that may establish a starting point.


The website has close to 100 database models for experimentation, practice and examples.

"My intention is to provide a wide range of 'Kick Start' Models that anyone can use as a starting-point, and could extend cleanly and logically, with appropriate reference to the Business Rules.

It is not my intention to provide Models that can be used off-the-shelf to meet the requirements of a large commercial organization.

After all, that is one of the things I do for a living !!!

None of the Models is the complete and final solution in its area, but any of them can be added to easily and quickly to meet a specific requirement. The logic in each Model is intended to be correct and to contain the minimum Entities for the area being modeled."


Database Answers

Barry Williams - Founder and Principal Consultant.


If you're attempting a "Big Year" list of blogs, you can add Viewpoint of a Database Analyst: A Database Design Principles Blog




See all Topics

Labels: , ,


<Doug Klippert@ 3:49 AM

Comments: Post a Comment

  Thursday, April 02, 2009 – Permalink –

Relationships

How it all ties together



"Find out how to reap the benefits of data normalization in Access while ensuring that your system provides users with all the information they need. Learn to relate your application's tables to each other, so that your users can view the data in the system as a single entity. After you define relationships between tables, you can build queries, forms, reports, and data access pages that combine information from multiple tables."


Relationships: Your Key to Data Integrity in Access 2003

An article from Informit.com and Alison Balter.

Alison is the founder of InfoTechnology Partners, Inc., a computer consulting firm in California. She is a highly experienced trainer and consultant, specializing in Windows applications.




See all Topics

Labels:


<Doug Klippert@ 3:27 AM

Comments: Post a Comment

  Monday, March 30, 2009 – Permalink –

Linked Table Problems

Lost functionality


Have you found that you cannot update linked Excel tables in Access 2003?


If you have installed Microsoft Office 2003 Service Pack 2 (SP2):


MORE INFORMATION
Because of legal issues, Microsoft has disabled the functionality in Access 2003 and in Access 2002 that let users change the data in linked tables that point to a range in an Excel workbook. However, when you make changes directly in the Excel workbook, the changes appear in the linked table in Access.


Support.Microsft.com:
You cannot change data in linked tables that are to an Excel workbook

You might try reinstalling and then only installing SP1.


Also:

VB123.com:
Guacamole dipped - Access to Excel linked table gotcha

PCWorld.com:
Patent ruling costs Microsoft $8.9 million


"A jury in U.S. federal court found that Microsoft infringed on a Guatemalan inventor's 1994 patent on technology linking the company's Access and Excel programs, and ordered the world's largest software maker to pay $8.9 million in damages.



See all Topics

Labels: ,


<Doug Klippert@ 3:17 AM

Comments: Post a Comment

  Wednesday, March 25, 2009 – Permalink –

Toggle Object Views

Use the keyboard


When you are putting a database together you often want to switch between views of Access objects to see the changes.

For instance, you'll switch the view to examine a Table in Design view and then back to data view. It is can be faster to switch between views using keyboard shortcuts, rather than the View menu.

You can cycle through the views of an open object using the

Ctrl + .

or

Ctrl + ,

shortcut keys.
These shortcuts can be used with tables, queries, forms, reports, and data access pages.




See all Topics

Labels: ,


<Doug Klippert@ 3:31 AM

Comments: Post a Comment

  Monday, March 16, 2009 – Permalink –

New Default Access Form Template

Set new standards



You can change Access's default form.

To set up a custom template,
  1. Create your template form by specifying all the properties you want to maintain from form to form.
  2. Then, save the form using any name.
  3. Next, select Tools>Options from the menu bar and select the Forms/Reports tab.
  4. Enter your template's name in the Form Template box to replace the Access default (Normal) and click OK.
The next time you create a form, Access will base it on your form template rather than the typical Normal template.

In Access 2007, click the Office button in the upper left corner and the click Access Options.
The design options are located under Object Designers: Forms/Reports.
The same thing can be done with Reports.

 

 (The settings are saved in the Access workgroup information file, not in a particular data base)

Also: MeadinKent.co.uk: Making a report template

Here's a calendar from MeadinKent: Calendar page




See all Topics

Labels: , , ,


<Doug Klippert@ 3:13 AM

Comments: Post a Comment

  Monday, March 09, 2009 – Permalink –

Change Properties in Form View

Alterations on the run


As you work with a form, you will, sometimes, find controls would benefit from minor tweaking. You may want to change the color of a text box, change the font that's used, or remove scroll bars.

You may have been told switch to Design view to make changes. However, you can display the property sheets for a control while you're in Form view.

To do so, click the Properties on the View menu, Right-click, or press [Alt][Enter].
As in Design view, the displayed properties relate to the control that is selected on the form. The property changes you make are reflected on the fly.
You will be prompted to resave your form when you close it.




See all Topics

Labels: ,


<Doug Klippert@ 3:49 AM

Comments: Post a Comment

  Saturday, February 28, 2009 – Permalink –

Parameter Queries Deux

Another look at parameters

The ability to use dynamic criteria in a Query makes Access even more valuable.

David Badurina operates NlueMooseTech.com.

He has produced an Access Parameter Query Tutorial video that walks the viewer gently through the process.

The site also has information on Excel and Word.

(Parameter queries are also referenced here:
Parameter v. Form)

How to create a parameter query

Using Parameter Queries




See all Topics

Labels: ,


<Doug Klippert@ 3:24 AM

Comments: Post a Comment

  Friday, February 20, 2009 – Permalink –

Access on Line

Free Basic Instruction


Microsoft has developed a very good collection of tutorials and samples for Office applications. They're located at Office.Microsoft.com

Even if you haven't upgraded to 2007, these suggestions will work with most earlier versions.

For Access look at:
Access 2007

If you have avoided Access in the past, a least glance at "Getting started with Access and Database applications"

Also:

Access 2003 Training Modules

These are 30 to 55 minute demonstrations.

"When you click Practice in Access at the bottom of this page, a practice database will download to your computer and open in Access, and a separate window with practice instructions will appear alongside."








See all Topics

Labels:


<Doug Klippert@ 3:18 AM

Comments: Post a Comment

  Friday, February 13, 2009 – Permalink –

Data Modeling

Data bits and pieces

While a few of us may be guilty of constructing databases on the run, and then trying to clean up the mess later, the wise ones plan ahead.

What information will you need in the future? What reports are going to be requested? If you're the bean counter, do you need to count all the legumes?


"Data modeling is probably the most labor intensive and time consuming part of the development process. Why bother especially if you are pressed for time? A common response by practitioners who write on the subject is that you should no more build a database without a model than you should build a house without blueprints.

The goal of the data model is to make sure that the all data objects required by the database are completely and accurately represented. Because the data model uses easily understood notations and natural language, it can be reviewed and verified as correct by the end-users.

The data model is also detailed enough to be used by the database developers to use as a "blueprint" for building the physical database. The information contained in the data model will be used to define the relational tables, primary and foreign keys, stored procedures, and triggers. A poorly designed database will require more time in the long-term. Without careful planning you may create a database that omits data required to create critical reports, produces results that are incorrect or inconsistent, and is unable to accommodate changes in the user's requirements."

University of Texas at Austin
Introduction to Data Modeling

Finding the Perfect Fit
By Tim McLellan

AgileData.org:
Data Modeling 101

DataModel.org




See all Topics

Labels: , , ,


<Doug Klippert@ 3:47 AM

Comments: Post a Comment

  Thursday, February 05, 2009 – Permalink –

Other Right Clicks

A couple overlooked


Right-clicking on objects, such as Tables, Reports or Queries, gives you the opportunity to print, copy, and work with them.

There are other options revealed by right-clicking on the Database window itself.
Right-click on the empty white space of the Database window can lead to Relationships.



If you right-click on the edge of the window, you'll find a link to Access database properties, startup activity for the current database, or open a new database.

Right-clicking on the Database window also lets you configure the items in the Groups bar.




See all Topics

Labels:


<Doug Klippert@ 3:00 AM

Comments: Post a Comment

  Saturday, January 31, 2009 – Permalink –

Kürzungen für jeder

Accessibility Shortcuts


Several resources are available to help increase speed and effectiveness for keyboard users. Here are keyboard shortcuts for leading Microsoft products that help save time and effort and provide an essential tool for some people with mobility impairments.

  • Internet Explorer 7/6/5/4
  • Office (2007/2003/XP/2002/2000/97)
  • PhotoDraw
  • PowerPoint
  • Producer
  • Publisher
  • Windows (Vista/2003/XP/2000/98/ME/NT)
  • Windows Media Player
  • Windows Movie Maker
  • Windows XP Media Center Edition 2005
Microsoft.com Keyboard Assistance.




See all Topics

Labels:


<Doug Klippert@ 3:25 AM

Comments: Post a Comment

  Thursday, January 29, 2009 – Permalink –

Sort Forms

Create a sorting function

Here is one way to provide your users with a means to reorder fields in forms.

"Chris Weber develops a solution that allows users to sort the data in their forms (or subforms) that you can add to your application easily.

  • The sorting interface should be generic to any form in any database.

  • It should also work with subforms.

  • It needs to be implemented as expediently as possible to fulfill the bid, and be easily maintained in the future.

  • It should be intuitive or reminiscent of other interfaces in Access and Windows.
Let Your Users Sort it Out



Scroll down to the bottom of the page. There is a file that can be downloaded with the code.




See all Topics

Labels: , , , ,


<Doug Klippert@ 3:04 AM

Comments: Post a Comment

  Monday, January 26, 2009 – Permalink –

Graphics from the '50s

Remember it the way you want to


Original fifties clipart? Just in time for the holidays, some Ozzie and Harriet style pics.



"Most communities in the fifties had small town print shops that doubled as printers of local news and advertising papers. These printers could not afford graphic artists so they used stock clipart supplied by large companies who distributed common graphics for use in advertising sections of the papers. They were provided for the printer in lots of categories to meet any advertiser's needs."

Retrographix.com



See all Topics

Labels:


<Doug Klippert@ 3:34 AM

Comments: Post a Comment

  Sunday, January 18, 2009 – Permalink –

Normalization

Designing an efficient database

Here is an understandable article about how to put together a normalized database.

One topic covered is what should be used for a Primary or foreign key.
"In general, a key field should have these characteristics:

Should be One Field

It is possible to define multiple fields as the key fields of a table, but a single field is preferable. ...Far better to have a CustomerID number than a combination of other fields to define a customer.
Should be Numeric

Access offers an AutoNumber field that is a Long Integer which is ideal for key fields. These values are automatically unique for each record and supports multi-user data entry as well.
Should Not Change Over Time

A key field should not change over time. Once identified, like a social security number, it should never change.
Should be Meaningless
To ensure a key field doesn’t change over time, it should have no meaning and therefore no reason to change over time.


Here are a few of the other topic headings:

Understanding Your Data
  • What Data Do You Need?
  • What Are You Going to Do with the Data?
  • How Is Your Data Related to Each Other?
  • What Is Going to Happen to the Data Over Time?
  • Learn How to Use Queries
Database Normalization Tips By Luke Chung, Founder and CEO of FMS Inc
Also see: Knowledgebase #283878: Description of the database normalization basics
15seconds.com: Introduction to Relational Databases
and:
Normalization Model




See all Topics

Labels: ,


<Doug Klippert@ 3:54 AM

Comments: Post a Comment

  Tuesday, January 06, 2009 – Permalink –

Clip Art Gallery

Sprinkle carefully


Judicious use of Clip art can spice up a document. Here's an article about how to customize existing pictures including:
  • Display clip-related toolbars
  • Customizing your clip art
  • Cropping
  • Sizing
  • Adding text wrapping
  • Blurring
  • Rotating and flipping
  • Adding a drop shadow
Edit clip art in Word

Also:
Clip art gallery

 

Halloween clips
Clip Art demo
5 new things about the Clip Art and Media site
Mary Sauer's Design Gallery Help
Microsoft Clip Art & Media Help




See all Topics

Labels:


<Doug Klippert@ 3:24 AM

Comments: Post a Comment

  Monday, December 29, 2008 – Permalink –

Drag Data

Simple exchange


To transfer data from an Access query or table in another Office program, such as Word, there's no need to manually export the data.
  1. Open the target Office document

  2. Arrange both applications on the screen
    (Right-click an empty part of the Task bar and choose Tile Windows Vertically)

  3. Switch to Access and select the fields or records that you want copied

  4. When you've finished selecting the data, move the mouse pointer near the border of the selection until it turns into an arrow

  5. Finally, drag and drop the data to your target document
You can also select a whole table, go to Edit>Copy. Switch to Word or Excel and Paste.
It works in the other direction too. Select some Excel data. Switch to Access. While viewing the Tables Objects, Paste the Excel data. It will form a new table.



See all Topics

Labels: , ,


<Doug Klippert@ 3:57 AM

Comments: Post a Comment