| A | B |
|---|
| attachment control | A control that enables you to manage attached files in forms and reports. |
| attachment field | A field used to attach multiple files of various formats to an individual record; attached files can be launched from Access. |
| csv text file | A file that uses a comma to separate one column from the next column, enabling the receiving software to distinguish one set of field values from the next. |
| hyperlink | A data type that enables you to quickly link to any file on your computer or to a webpage on the Internet. |
| importing | A process that enables you to copy external data into your database without linking it to its source file. |
| linking | A process that enables you to connect to a table or spreadsheet without having to import the data into your database. |
| pdf | A file format created by Adobe Systems in 1993 for document exchange, independent of software application and operating system environment. |
| rtf | A file format that enables documents created in one software application to be opened with a different software application. |
| text file | A common file format for exchanging data between two computer systems. |
| url | The location of a website or webpage on the Internet. |
| xps | A file format developed by Microsoft and designed to display a printed page on screen identically on any computer platform. |
| ACCDE | Access Database Executable. A type of database file that prohibits users from making design and name changes to forms or reports within the database, and prohibits users from creating new forms and reports. |
| Anomaly | An error or inconsistency that occurs when you add, edit, and delete data. |
| back-end database | A database that contains the tables of the database. |
| composite key | A primary key that is made up of two or more fields. |
| encryption | The process of altering digital information using an algorithm to make it unreadable to anyone except those who possess the key (or secret code). |
| 1NF | First normal form - A criterion satisfied when a table contains no repeating groups or repeating columns. |
| front-end database | A database that contains the queries, forms, and reports of the database. |
| functional dependency | A condition that occurs when the value of one field is determined by the value of another. |
| index | A setting for a field that reduces the time it takes to run queries and reports. |
| normalization | The process of efficiently organizing data so that the same data is not stored in more than one table, and that related data is stored together. |
| 2NF | Second normal form - A criterion satisfied when a table that meets 1NF criteria and all non-key fields are functionally dependent on the entire primary key. |
| 3NF | Third normal form - A criterion satisfied when a table meets 2NF criteria and no transitive dependencies exist. |
