An auto numbered primary key does not give an accurate count of records since it acts as a counter. This makes it increment records hence may not give accurate values. The access database uses different data types. These are date time, auto number, OLE object, text, Yes/No and number data types. The date time data type allows for calculations based on time. The auto number data type generates primary key values. The OLE object data type allows one to store complex data. On the other hand, the text data type stores both text and number while Yes/No uses a checkbox that accepts one option from many values that can be selected. The number data type uses addition, subtraction and other quantitative manipulations.
Despite these data types being useful, a date time data type would be the most appropriate for the budget field in a tracking database. Apart from the data types, the database stores other numeric data. These include character, integer and alpha numeric. On the other side, a calculated field is a field that performs calculations based on one’s data. One clicks and selects the design view and navigates to the field where the value is to be calculated. This invokes the expression builder where respective signs are in between the bracket signs, and at the end clicking the Ok button to complete the process. A lookup filed utilizes the column to query information from multiple fields. This process has options through the drop down list and a text box. In this, one can select an option based on a preference.
This work, titled "Access 2010 essentials essays example" was written and willingly shared by a fellow student. This sample can be utilized as a research and reference resource to aid in the writing of your own work. Any use of the work that does not include an appropriate citation is banned.
If you are the owner of this work and don’t want it to be published on AssignBuster, request its removal.
Request RemovalReferences
AssignBuster. (2021) 'Access 2010 essentials essays example'. 14 December.
Reference
AssignBuster. (2021, December 14). Access 2010 essentials essays example. Retrieved from https://assignbuster.com/access-2010-essentials-essays-example/
References
AssignBuster. 2021. "Access 2010 essentials essays example." December 14, 2021. https://assignbuster.com/access-2010-essentials-essays-example/.
1. AssignBuster. "Access 2010 essentials essays example." December 14, 2021. https://assignbuster.com/access-2010-essentials-essays-example/.
Bibliography
AssignBuster. "Access 2010 essentials essays example." December 14, 2021. https://assignbuster.com/access-2010-essentials-essays-example/.
Work Cited
"Access 2010 essentials essays example." AssignBuster, 14 Dec. 2021, assignbuster.com/access-2010-essentials-essays-example/.
Please, let us know if you have any ideas on improving Access 2010 essentials essays example, or our service. We will be happy to hear what you think: [email protected]