click below
click below
Normal Size Small Size show me how
Access DB part2
ICT II - Unit 5
| Term | Definition |
|---|---|
| Table Design | The number of fields, and the type of content within each field, in an Access table. |
| Datasheet View | The Access view that displays an object organized in a format of cloumns and rows similar to an Excel Spreadsheet. |
| Design View | The Access view that displays the underlying structure of an object. |
| Populate | The action of filling a database table with records |
| Data Type | The characteristic that defines the kind of data that can be entered into a field, such as numbers, text. or dates. |
| Ascending | To sort from the smallest to the largest (from A to Z and 0 to 9) |
| Descending | To sort from largest to smallest (from Z to A and 9 to 0) |
| Field Description | An optional brief comment or explanation of a field. It would appear in the status bar at the bottom of the window, when its field is selected. |
| Primary Key | A field that uniquely identifies each record in a table. |
| Sort | To organize data alphabetically or in numerical order. |
| Form Wizard | Helps create a form quickly and allows you to select options to specify: record source, layout, and style |
| Criterion | Also called Condition - a way of telling the query which data you are interested in seeing. |
| Data Changes | Are automatically saved in Access. |
| Auto Number | A feature that sequentially numbers entered records creating a unique number for each field. |