Download Microsoft Access Database Terminology and Concepts and more Exams Information Technology in PDF only on Docsity!
MICROSOFT ACCESS TERMS
Database - ANSWER A file that consists of one or more tables and the supporting objects used to get data into and out of the fields Relational database software - ANSWER a computer application, such as Microsoft Access, that is used to store data and convert it into information Relational database management system - ANSWER Data are grouped into similar collections, called tables, and the relationships between tables are formed by using a common field Flat or non-relational data - ANSWER data contained in a single page or sheet Field - ANSWER a basic entity, data element, or category, such as a book title or telephone number Column - ANSWER the data field that you assign to group data vertically into columns. Example: First name, last name, address, and phone number Record - ANSWER a complete set of all of the data about one person, place, event, or idea. Example: All the fields on my class roster about one student. Row - ANSWER the source field that you assign to group data horizontally in a crosstab query Table - ANSWER a collection of records
Primary key - ANSWER the field that makes each record in a table unique; ex. Student ID number Foreign key - ANSWER a field in one table that also is stored in a different table as a primary key Question - ANSWER A database object through which you can ask questions about data in a database, and get answers. The answers come back in a order from the records that meet your instructions. Form - ANSWER an interface through which you can put in or change record data. Report - ANSWER A document printed that shows information nicely formated from a database Speed at which Access accesses - ANSWER the length of time it takes for the storage device to present the content of the file for use Compact and Repair Database Utility - ANSWER compacts and reduces the size of a database and removes wasted space. Datasheet view - ANSWER is a grid of columns and rows in which you will add, edit, and delete records for a database table Design view - ANSWER shows the structure of a table, form, or report without showing the data
Date/Time - ANSWER hold formatted dates or times and allows the values to be used in date or time arithmetic. Example: Library databases that store research papers Currency - ANSWER can be used in a calculation and is used for fields that contain monetary values. Example: Your checking account balance Yes/No - ANSWER assumes one of two values, such as Yes or No, True or False, or On or Off. Example: Dean's list Hyperlink - ANSWER stores a Web address (URL). Example: www.lsu.edu OLE - ANSWER contains an object created by another application. Example: Excel workbook Attachment - ANSWER data type that allows you to attach images, spreadsheet files, charts, and other types of supported files to the records in your database Date arithmetic - ANSWER a mathematical expression that calculates elapsed time; Ex. Add one to Today( ) to get tomorrow. Filter - ANSWER condition that helps you find a subset of data meeting your specifications; Ex. Filter by crash data by parish code Sort - ANSWER (ascending) provides an alphabetical list of text data or a small-to-large list of numeric data. (Descending) arranges the records with the highest value listed first
Filter by form - ANSWER allows to choose the criteria from a drop-down list, or apply multiple criterion Filter by selection - ANSWER filters in only those records that meet the pre- selected criteria Inequity - ANSWER looks at a mathematical relationship such as: PivotChart view - ANSWER displays a chart of the associated PivotTable view PivotTable view - VIEW is a quick and easy way to summarize, organize data about groups of records Query design grid - GRID appears when a query is opened in Design view; splits the window in two parts Query Wizard - WIZARD a tool that steps you through the process of creating new queries with a series of dialog boxes Select query - ANSWER searches the underlying tables for data that satisfy the parameters of the query Calculated field - ANSWER a field whose value is computed from a formula that involves one or more existing fields
Discrete data - ANSWER classification of data that is measured and quantified in discrete, unique increments; categories; ex. the number of males and females in a class, names of countries, etc. Continuous data - ANSWER classification of data in which values fall on a continuum and are easily scaled. Ex. Measurements of time, temperature, money, volume, size, and distance. Column, bar, and stack - ANSWER charts that display quantitative data and compare data across categories. Line Charts - ANSWER a chart that plots data points which are continuously distributed data to compare trends over time. Place time measurements on the X axis. Pie chart - ANSWER a chart that shows proportion of each category to the whole for a single data series Doughnut chart - ANSWER a chart that shows values as percentages to the whole for multiple data series Bubble Charts - ANSWER a variation of a scatter chart to show how sets of things compare according to various factors. The sizes of the bubbles show the relative size of the data being plotted Legend - ANSWER area of the chart that identifies which color represents the data for each data series
Axes - ANSWER the vertical and horizontal scales displaying plotted data in a line, column, bar, or scatter chart Gridlines - ANSWER the lines that extend across the plot area of a chart Chart title - ANSWER the area of a chart that shows a name describing the data reflected in a chart Plot area - ANSWER area of the chart that depicts the data points Calculated detail field - ANSWER the part of a PivotTable or PivotChart that creates a new field and executes the specified calculation on all of the detail records Calculated total field - ANSWER a data field used to customize aggregated data
