Microsoft Access Database Design Concept - Step 5 of 7: Table Field Design of the Access Database
The Field Design & Validations This is the last step which completes the ‘back-end’ database design process and steps 6 and 7 (later articles to follow) focuses on the ‘front-end’ database design process and is deemed optional to this final step of the ‘back-end’ database design process. In this section, I’m going to discuss the process which talks about the field’s properties and the business rules of how fields control data input. If you are not designing input screens (Access Forms), then the process could effectively stop here. If however, you intend to handle ‘front-end’ processes for your database, this is the preliminary step of setting the best fit attributes (ideally in table design view mode). You will therefore need to know about what properties are and how and where you apply them. Properties is a general term to describe an attribute of an object. For an example, a field (the object) has many attributes to it ...