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


  Wednesday, September 28, 2016 – Permalink –

Where's the Template?

Find and/change storage spots



Describes the different template categories and the locations of templates in 2007 & 2010 Office programs. Also describes the registry settings that control where to find your custom templates.

Support.Microsoft.com


See all Topics

Labels: ,


<Doug Klippert@ 3:43 AM

Comments: Post a Comment

  Tuesday, January 19, 2016 – 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


See all Topics

Labels: , , , , ,


<Doug Klippert@ 3:57 AM

Comments: Post a Comment

  Monday, July 27, 2015 – Permalink –

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

Labels: , , , , , ,


<Doug Klippert@ 3:53 AM

Comments: Post a Comment

  Thursday, March 19, 2015 – Permalink –

Samples Queries, Reports, Forms

Examples to part out




This sample queries database contains examples of useful database queries, including the crosstab query, the union query , and the join query

Sample: query topics database

Here are some other sample databases. They are all for Access 2000, but the installed base is predominantly in that format. Access 2000 is also the default format for Access 2002 and 2003.
Sample Access databases that you can download and adapt

Database of Access 2000 sample forms
The sample forms in this database demonstrate a variety of form types and techniques, including how to manipulate data, use controls, and create undo and redo operations.

Some forms include:
  • Bring a subtotal from a subform to a main form
  • Create a running sum
  • Create a stopwatch form
  • Display line numbers on subform records
  • Fill current record with data from previous record automatically
  • Hide the combo box drop-down arrow
  • Simulate drag-and-drop capabilities
Database of Access 2000 sample reports
The sample reports in this database demonstrate a number of techniques, including how to shade every other row or every nth row in a report, how to create a table of contents or an index for a report, and how to create a top 10 report.



See all Topics

Labels: , , , , , , ,


<Doug Klippert@ 3:50 AM

Comments: Post a Comment