BIS 245 Final Exam Study Guide

BIS 245 Final Exam Study Guide Fields - Answer the smallest data element of a table, such as first name, last name, address, or phone number. Records - Answer a group of related fields representing one entity, such as data for one person, place, event, or concept. Tables - Answer An object used to store and organize data in a series of records (rows) with each record made up of a number of fields (columns) and is the foundation of every database. Databases - Answer A collection of data organized as meaningful information that can be accessed, managed, stored, queried, sorted, and reported. Forms (object) - Answer a database object that is used to add, edit or delete table data. Reports (object) - Answer An object that contains professional-looking formatted information from underlying tables or queries. Macros (object) - Answer A series of actions that can be programmed to automate tasks. Modules (object) - Answer An object that is written using Visual Basic for Applications (VBA) and adds functionality to the database. Queries (object) - Answer Enables you to create queries; the Design view is divided into 2 parts - top portion displays the tables and the bottom portion (known as the query design grid) displays the fields and criteria. Structured Query Language (SQL) - Answer The industry-standard language for defining, manipulating, and retrieving the data in a database. Calculated Field - Answer Produces a value from an expression or function that references or more existing fields. Caption Property - Answer Used to create a more readable label that appears in the top row in Datasheet view and in forms and reports. Compact and Repair - Answer An Access utility that reduces the size of the database and can repair a corrupt database. Composite Key - Answer Primary key that is made of 2 or more fields. Criterion - Answer A number, text phase, or an expression used to select records. Data type - Answer Determines the type of data that can be entered and the operations that can be performed on that data.