click below
click below
Normal Size Small Size show me how
ICT 2 - Access DB_1
ICT2 - Unit 4 Database - MS Access PART 1
| Term | Definition |
|---|---|
| Access | Microsoft’s version of a Database Management System. |
| Database Management System | Allows you to store, retrieve, analyze and print information. |
| Database | A collection of objects that work together. |
| Objects | The basic parts of a database, which include tables, forms, queries, reports, and macros. |
| Table | Stores all data in the database in a format called a datasheet. |
| Datasheet | Similar in appearance to an Excel worksheet, containing rows and columns. |
| Query | (question) which is used to search for specific information in the tables. |
| Form | Displays data in a format that looks similar to paper forms. |
| Navigation Pane | The area of the Access window that displays and organizes the names of the objects in a database, and from where you open objects for use. |
| Record | Complete set of data - appears in rows |
| Field | Categories that are listed in columns |
| Field Selector | Contains field name - located at the top of each column |
| Record Selector | Appears to the left of each record - when clicked, selects the entire row. |
| Data | Facts about people, events, things, or ideas. |
| Information | Data that is organized in a useful manner. |