Microsoft Access stores your information in tables. Once a table is created, you can use the many tools provided to view and manipulate your Access database. Microsoft Access queries are created to search the database. The fields used in a query are stored in the underlying table. In order to change the data type in one of your Access queries, you need to change the data type in the table’s design. Warnings Writer Bio
