Access Database Design
Lisa Mills
December 29, 2010
The initial thing you should do when seeking at access database design is to smash down your information into divide essentials. For example in an invoicing scheme you are available to have to accumulate information on orders, invoices, delivery, customers, payment, products etc. These symbolize individual facts & will have distinctive property. A customer will have an address & name. An order will have an arrange numeral, date of arrange etc. Separate facts will be stored in what are recognized as tables. You would have a table for customer, invoice etc. You also need a way to link these tables or facts jointly & this is done with amazing called keys. An order could be related to a purchaser via a customer id key pasture.
The top way is to experiment with contravention behind facts & linking. It is vital that this step is complete properly as it can bang your database really if there are issues. Imagine only individual bright to link a particular order to a patron when in actuality that shopper could have many orders. These evils should be ironed out through the Access database design stage.
Do you desire the scheme to mechanically delete linked records or would you like to manage this physically yourself. There are pros & cons to liability this. It is likely to set up the MS Access database to execute what is known as cascade deletes. Basically if you eliminate a customer then this would eliminate all their connecting orders. You may desire to keep the orders & have more manage over this procedure.
In Access you have the capacity to make a main form which will illustrate a single confirmation. You can also make an MS Access sub form which will illustrate numerous records. You will require tables for both these forms & a way of connecting them jointly. A good example of a main & sub form is an order and customer. One customer would be exposed as single evidence in the main form & numerous orders exposed in the related MS Access sub form.
A particular main aspect of Access database design is that you must not have repeating in sequence. For example you would not desire to store multiple instance of a national insurance figure or still the full name of an individual. The reason for this is that it takes up redundant storage space as well as impacting penetrating.
Author writes for ms access, access 2007 and microsoft access.
The top way is to experiment with contravention behind facts & linking. It is vital that this step is complete properly as it can bang your database really if there are issues. Imagine only individual bright to link a particular order to a patron when in actuality that shopper could have many orders. These evils should be ironed out through the Access database design stage.
Do you desire the scheme to mechanically delete linked records or would you like to manage this physically yourself. There are pros & cons to liability this. It is likely to set up the MS Access database to execute what is known as cascade deletes. Basically if you eliminate a customer then this would eliminate all their connecting orders. You may desire to keep the orders & have more manage over this procedure.
In Access you have the capacity to make a main form which will illustrate a single confirmation. You can also make an MS Access sub form which will illustrate numerous records. You will require tables for both these forms & a way of connecting them jointly. A good example of a main & sub form is an order and customer. One customer would be exposed as single evidence in the main form & numerous orders exposed in the related MS Access sub form.
A particular main aspect of Access database design is that you must not have repeating in sequence. For example you would not desire to store multiple instance of a national insurance figure or still the full name of an individual. The reason for this is that it takes up redundant storage space as well as impacting penetrating.
Author writes for ms access, access 2007 and microsoft access.
Print
Email
