Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Access Module 1
Module 1 Vocab
| Term | Definition |
|---|---|
| Anomalies | Irregularities, differences, or variances that can be caused by an inefficiently designed database. These can occur more often in unnormalized databases (also known as flat databases). |
| Data Type | A property of a field that indicates the kind of data that can be stored in that field. |
| Database | A tool for collecting information that is organized to provide efficient retrieval of data. These often begin as a list of items that have some form of relevance. |
| Database Management System (DBMS) | A software program (application) that is used to create, store, manipulate, find, and manage data in any kind of information organizing tool. |
| Datasheet | An interactive presentation of a table with fields in columns and records in rows, which is similar to an Excel spreadsheet. |
| Field | A single descriptive item of information about items in a list, organized into columns within a table. |
| Flat Database | A single list organized with records in single rows and fields in columns. |
| Form | An Access object that allows the user to view, enter, and edit data in a user-friendly and controlled interface. |
| Key Fields | A type of Access component that uniquely identify a record (primary key) or connect a record to a record in another table (foreign key). |
| Macro | Access object that uses a simplified programming language to add functionality to a database, often used to automate actions and tasks. (Not covered as part of this course.) |
| Module | Access object that is a collection of programming procedures, statements, and declarations that are stored together as a unit. (Not covered as part of this course.) |
| Naming Conventions | Recommended practice of naming items such as folders, files, and Access objects to a designated standard. |
| Normalization | A step in the database design process of reviewing a preliminary data structure according to specific rules to ensure that data is divided appropriately into tables to be most efficient and useful. |
| Null Value | Something that doesn't exist. |
| Objects | Access components that are used to store, find, and otherwise manage data in a database. |
| Queries | Access objects within a database that are used to ask questions of data and retrieve specific data from one or more tables in the database and display it. |
| Record | A collection of fields about an item in a list, usually organized into rows in a table. |
| Relational Database | Something in which data is divided into separate, subject-based tables, which are linked together by shared key fields into relationships to bring the data together as needed for meaningful information and insights. |
| Relational Database Management System (RDBMS) | A software program (application) that is used to create, store, manipulate, find, and manage data in a type of information organizing tool which links multiple subject-based tables together. |
| Relationship | A designated connection between two tables through shared key fields to allow retrieval of related information from both tables. |
| Report | Access object used to present distilled or summarized data in an easily consumable format. |
| Table | Access object in which data is stored in an organized structure similar to a spreadsheet. |
| Value | The data stored in a field. |
| View | The term for how Access objects that are active are always presented for creating, designing, or using the object. |
Created by:
lexrvh
Popular Computers sets