Re: Initial Check Box Setup
From: Cheryl Fischer (cherylfischer_at_NOSPAMmsn.com)
Date: 05/03/04
- Next message: Ric: "Relationships & Forms"
- Previous message: Cheryl Fischer: "Re: Create a database"
- In reply to: Mike C.: "Re: Initial Check Box Setup"
- Next in thread: TC: "Re: Initial Check Box Setup"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 3 May 2004 18:58:38 -0500
The beauty and utility of a normalized design is that you can have an
unlimited number of skills assigned to each employee; this, therefore,
renders having a fixed number of checkbox controls on a form (subject to
redesign whenever a new required skill is added) unnecessary.
Take a look at the Northwind.MDB database which ships as a sample with
Access. Open the Orders form. Notice that for each order there can be
multiple line items in the order. This is a parent-child relationship,
similar to the relationship that would exist between a single
employee/person in your database and that person's multiple skills. Notice
that you can add new line items to an order by using a combo box to enter
the product name, thereby making data entry more accurate and fast.
It is very easy to look at the rich design environment of an Access form and
begin picking out the controls one wants to use before creating
appropriately normalized tables and defining their relationships, putting
the cart before the horse (so to speak). Once you have designed each of
the tables your database needs and made sure that the data is normalized,
you'll find that the forms generally "design themselves", as Access forms
and controls are designed to work their best with normalized data.
-- Cheryl Fischer, MVP Microsoft Access Law/Sys Associates, Houston, TX "Mike C." <anonymous@discussions.microsoft.com> wrote in message news:794401c43141$be498120$a401280a@phx.gbl... > Thanks for the response. > > Unfortunetly, I am still having some problems. I still am > not sure on how to set up the tables and then set up the > form with the actual check boxes on them. > > Any further assistance would be greatly appreicated. > > m. > >-----Original Message----- > >Mike, > > > >From the very brief description you provided, I would say > you are starting > >off with a very un-normalized design which will do > nothing but cause you > >grief down the road. With what you have: a single > table containing an > >employee name with columns representing some number of > individual skills, > >you can design forms, queries and reports. But what > happens when it's > >determined that an additional skill must be added to > those that are already > >in the table? Not only will your table have to be > modified, but so will > >the queries and forms that you use. And, that is only > the beginning... > > > >What you should be looking at is: > > > >Table: tblEmployees > >PK - Autonumber > >LastName > >FirstName > ><other fields directly relating to employee. > > > >Table: tblEmpSkills > >PK - Autonumber > >EmpID (Long Integer - links to PK in tblEmployees > >Skill > ><additional field for Skill Level ??> > > > >I strongly recommend that you take a look at the > following two links which > >discuss normalization - the second link shows an example > which bears some > >resemblance to your current table. > > > >http://databases.about.com/library/weekly/aa080501a.htm > >and > >http://databases.about.com/library/weekly/aa081901a.htm > > > >In addition, here is an Amazon link to one of the better > books on database > >design: "Database Design for Mere Mortals", Hernandez > >http://tinyurl.com/2uona > > > > > >-- > > > >Cheryl Fischer, MVP Microsoft Access > >Law/Sys Associates, Houston, TX > > > > > >"Mike C." <anonymous@discussions.microsoft.com> wrote in > message > >news:75d101c43108$97494f80$a401280a@phx.gbl... > >> Hello. > >> > >> I am in the process of designing a database that, in > >> addition to having the members name, address, etc., will > >> have a group of check boxes. The check boxes will allow > >> the inputer to associate a number of different > expertises > >> to the member. It will look as follows: > >> > >> Member Name Expertise 1 Expertise 2 Expertise 3 > >> ----------------------------------------------------- > >> John Doe x x > >> Jane Doe x x > >> Scooby Doo x x x > >> > >> How do I go about intially setting up the table(s) for a > >> database design such as this one? > >> > >> Any help would be appreicated. > >> > >> Thanks in advance, > >> > >> m. > > > > > >. > >
- Next message: Ric: "Relationships & Forms"
- Previous message: Cheryl Fischer: "Re: Create a database"
- In reply to: Mike C.: "Re: Initial Check Box Setup"
- Next in thread: TC: "Re: Initial Check Box Setup"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
