Through the use of this program students had created their tables via entering their field names (their headings) and selected appropriate data types for them via the design view – this ensures that no data of the incorrect type is input in (for example putting in letters where only numbers should be written like for a phone number).
Once the field names are constructed the students can then go back into the datasheet view and type in their data – if any incorrect type of data is input the program will pick this up through the data type that was selected when designing the table. The program also detects duplicate data and would not let you proceed if duplicate data for what we call our primary key – an identifier such as a name or ID which is unique to that entry.
Microsoft Access has a variety of different features that make it an exceptional database program including being able to creating reports so the data is presented in a printable and formal format and a query which lets the user not only sort out and find specific data with multiple criteria but also input calculations. The most unique feature that makes it pleasing to the eye in presentation is the creation of a data entry screen via a form, which creates uses a drag and drop feature from your data, automatically showing data records one at a time through an aesthetically pleasing platform. Using Microsoft Access using the ascending/descending, filter and criteria tools makes it easy for organization and location of suitable information.
The students have worked exceptionally well on creating 4 different databases on a variety of different scenarios in which they delved into exploring these skills and features.