Final answer:
The statement is true; Microsoft Access does allow you to update data in tables through the use of Update Queries, which are part of the database's query capabilities.
Step-by-step explanation:
Microsoft Access is a database management system that includes a query function that allows users to manage and manipulate data. One of the functionalities of a query in Access is the ability to update data.
This is done through an Update Query, which is a specific type of query designed to modify a set of records in one or more tables. The SQL (Structured Query Language) behind the Update Query specifies which records should be updated and the new values for them.
To create an Update Query, you would use the Query Design feature of Access, which lets you select the fields you want to update, specify the criteria for selecting records, and define the new values those fields should contain. These queries can modify multiple records in one operation, making them very powerful tools for maintaining and editing data in your tables.
Therefore, the statement that Access provides query capabilities that allow you to update data in the tables in a database is true.