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


  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