Rabu, 11 April 2012

Re: [MS_AccessPros] Re: Question regarding Data Organization

 

Duane, Thanks, that is good advice. mark

---------- Original Message ----------
From: "Duane" <duanehookom@hotmail.com>
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Question regarding Data Organization
Date: Wed, 11 Apr 2012 13:56:28 -0000

Mark,
In addition to Crystal's great advice, you might want to review some of her excellent tutorials at http://www.accessmvp.com/strive4peace/. Also establish a good naming convention from the start. Avoid naming fields, tables, and other items with reserved words. Check Allen Browne's page at http://www.allenbrowne.com/AppIssueBadWord.html.

Keep coming back with your table/field designs so you get your application set up correctly. A bad design is difficult to correct once you have started creating forms and adding data.

Duane Hookom
MS Access MVP

--- In MS_Access_Professionals@yahoogroups.com, "MarkF" <Fischermh@...> wrote:
>
> I have begun to build an Access 2007 database to track non-profit grant funding. I am a novice and definitely the epitome of the saying "a little knowledge is a dangerous thing."
>
> Basically, we have many grants. Each grants funds a specified list of expenses. We need to make sure that an expense is not funded by two different grants. We also need to know what expenses are not funded. For example grant A may fund 100% of Employee 1' compensation and 50% of employee 2's compensation.
>
> Here is my thought regarding the table structure:
>
> 1. Employee Table:name, compensation, position, department
> 2. Department Table: List of Departments
> 3. Grant Table: Start Date, End Date, amount, Grantor
> 4 Expense Table: Expense, amount Such as Rent $1,000
> 5. Position Funding Table: On table for each position. We have 58 staff positions, so 58 tables. The table fields are Grant and amount. So if Position 1, is funded by 3 grants, each grant is listed with the amount of funding.
> 6. Expense Funding Table: One table for each expense line item, with grant and amount fields. For example, a rent table with 2 grants paying 50% each.
>
> I am thinking there may be an better way without have a table for each expense. Any suggestions would be greatly appreciated.
>
> Thanks,
> Mark
>




__________________________________________________________
53 Year Old Mom Looks 33
The Stunning Results of Her Wrinkle Trick Has Botox Doctors Worried
http://thirdpartyoffers.netzero.net/TGL3231/4f85da5a42bc03b444bst05duc

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar