click below
click below
Normal Size Small Size show me how
Access Vocablary
| Question | Answer |
|---|---|
| Databass | A collection of structured information or data stored electronically in a computer system. |
| Table | The fundamental building block of a database that stores raw data organized into rows and columns. |
| Record | A single, complete row in a table the contains a specific category of information (e.g., Last Name, Phone Number, or Email). |
| Primary Key | A unique field (or combination of fields) that specifically identifies each individual record in a table, preventing duplicate data. |
| Query | A question or request presented to the database to find, filter, sort, or manipulate specific data across one or more tables (e.g., finding all customers who placed an order in the last 30 days). |
| Form | A user-friendly, on-screen interface utilized to easily enter, view, and edit data in your tables without directly touching the underlying structure. |
| Report | A formatted, professional layout of database information designed for viewing, printing, or sharing with others. |
| Relational Database | A type of database where multiple tables are linked ( or "related") to one another through shared fields, which minimizes data redundancy. |
| Design View | An advanced editing mode in Access where you can configure the structure, data types, and properties of your tables, queries, and forms. |