Bis 245 Final Exam Study Guide Questions With Correct Answers |Graded A
Fields Correct Answer the smallest data element of a table, such as first name, last name, address, or phone number. Records Correct Answer a group of related fields representing one entity, such as data for one person, place, event, or concept. Tables Correct 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 Correct Answer A collection of data organized as meaningful information that can be accessed, managed, stored, queried, sorted, and reported. Forms (object) Correct Answer a database object that is used to add, edit or delete table data. Reports (object) Correct Answer An object that contains professional-looking formatted information from underlying tables or queries. Macros (object) Correct Answer A series of actions that can be programmed to automate tasks. Modules (object) Correct Answer An object that is written using Visual Basic for Applications (VBA) and adds functionality to the database. Queries (object) Correct 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) Correct Answer The industry-standard language for defining, manipulating, and retrieving the data in a database. Calculated Field Correct Answer Produces a value from an expression or function those references or more existing fields. Caption Property Correct 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 Correct Answer An Access utility that reduces the size of the database and can repair a corrupt database.
Información del documento
- Subido en
- 23 de noviembre de 2022
- Número de páginas
- 3
- Escrito en
- 2022/2023
- Tipo
- Examen
- Contiene
- Preguntas y respuestas
