click below
click below
Normal Size Small Size show me how
vocab words access
| Question | Answer |
|---|---|
| Database | database management system (RDBMS) that allows you to store, manage, and report on data without needing extensive programming experience |
| Table | The foundation of any database where you actually store your data. They consist of fields (columns) and records (rows). |
| Records | is a single, complete row of data in a table |
| Field | is a specific category of information within a database table |
| Primary Key | is a unique identifier for each row in a database table |
| Query | Used to find, filter, sort, and extract exactly the information you need from your tables. |
| Form | User-friendly interfaces for entering, viewing, and updating data in your tables |
| Reports | User-friendly interfaces for entering, viewing, and updating data in your tables |
| Relational database | organizes data into distinct, subject-specific tables that are connected by defined links |
| Design view | a "behind-the-scenes" workspace used to build or modify the underlying structure of database objects |