To can compile an application at Access, hence before all need to be designed a data base, before entering it into Data Base Access. There are a lot of technique and way to design data base. One of them is simple, visible of steps following :
1) Collects all entities (entity) in application is wishing you are create, then determines also data items (field) in the entity. There is 2 prohibition when doing first step, that is: doesn't there is tables representing some entities, labored every tables only accommodate one entities and doesn't there are identical data item repeatedly in one entities, dissociates into other tables.
2) Specifies index locks. Index is enlisting value sequence in one fields for entity. Field made an index to called as with lock field or index field. One other of vital importance is specify primary lock. Primary lock so central important in compilation of tables, because:
a) Field given primary index, will have the character of on unique (may not be twin)
b) Key required to specify relationship between tables
3) Specifies Relationship between tables. After tables made and split, hence the next step is specify relationship between the tables. There is three relationship types between tables, that is :
a) One-To-One : it is simplest relationship, where every data at a tables, only elation with a data also in other tables.
b) One-To-Many : it is relationship which at most met, where a data at one particular tables is having relationship with many data at other tables.
c) Many-To-Many : it is relationship which must be avoided in data base scheme. If happened relationship Many-To-Many, hence having to be searched its the alternative by the way of making medium tables between the tables.
Before we enter data to data base access we need to make data base planning, data base scheme steps, that is: step firstly dissociate all entities and data items, second step determine last index and step is determine relationship.
To can compile an application at Access, hence before all need to be designed a data base, before entering it into Data Base Access. There are a lot of technique and way to design data base. One of them is simple, visible of steps following :
1) Collects all entities (entity) in application is wishing you are create, then determines also data items (field) in the entity. There is 2 prohibition when doing first step, that is: doesn't there is tables representing some entities, labored every tables only accommodate one entities and doesn't there are identical data item repeatedly in one entities, dissociates into other tables.
2) Specifies index locks. Index is enlisting value sequence in one fields for entity. Field made an index to called as with lock field or index field. One other of vital importance is specify primary lock. Primary lock so central important in compilation of tables, because:
a) Field given primary index, will have the character of on unique (may not be twin)
b) Key required to specify relationship between tables
3) Specifies Relationship between tables. After tables made and split, hence the next step is specify relationship between the tables. There is three relationship types between tables, that is :
a) One-To-One : it is simplest relationship, where every data at a tables, only elation with a data also in other tables.
b) One-To-Many : it is relationship which at most met, where a data at one particular tables is having relationship with many data at other tables.
c) Many-To-Many : it is relationship which must be avoided in data base scheme. If happened relationship Many-To-Many, hence having to be searched its the alternative by the way of making medium tables between the tables.
Before we enter data to data base access we need to make data base planning, data base scheme steps, that is: step firstly dissociate all entities and data items, second step determine last index and step is determine relationship.
