Views (Visual Database Tools)
Views bring together data from any combination of tables in your database in a tabular form. Views are similar to queries, but are stored with the data source so many users can access them repeatedly. For more information about the differences between queries and views see Comparison of Queries and Views.
You can use views to modify data as well as to review it for read-only purposes. For example you can open a view and change an employee's title, add a record for a new employee, or change a phone number. For more information about using views to modify data see Working with Views.
Note
If you want to change the design of the underlying tables rather then their data, use Table Designer. For example, if you want to change the data type of the employee ID field from byte to long to accommodate longer ID numbers, open the table that contains the employee ID field in Table Designer and make the change there. For more information about using Table Designer see Designing Tables.