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. |