COMP 1010 Lecture 58: Lecture 58
Document Summary
Tables and relationships between tables are infrastructure of a database. Queries, forms, and reports will help make information in a database useful o reorganize information into different views: allow us to enter new data easily. Views make a database more usable, can also be designed for security reasons (making certain information viewable for certain people only) 3 ways to create custom database views (depending on goal): 1) use a query if you want to ask your database a question. Views are dynamic structure of tables and relationships between them are created once, we can add to it over an extended period of time. Must decide what fields you want to include before creating, and what tables they come from. Query results are shown in a functional table: same view used with regular data stored in a table. For better looking results you should create a query, then generate another view. Use design view when creating a query in access.