Chapter 4: Glossary

Definition of terms used in this chapter:

Append to add on to the end of an object, for example, adding records to the end of an existing table in a database
Arrange tab a tab in the Report Layout toolbar that allows you to make changes to the arrangement of tables, rows and columns in a Report
Autonumber a data type that describes a unique sequential or random number assigned by Access as each record is entered and that is useful for data that has no distinct field that can be considered unique. This data type cannot be manually changed or typed in
Blank form allows you to create a new, blank form, which you can then customize and format the way you want
Bound a control that retrieves data from an underlying table or query
Data Facts about people, events, things or ideas
Data type classification identifying the kind of data that can be stored in a field such as numbers, text or dates
Database an organized collection of facts about people, events, things or ideas related to a specific topic or purpose
Datasheet view the Access view that displays data organized in columns and rows similar to an Excel spreadsheet
DBA stands for Database Administrator, an IT professional whose primary responsibilities include database installation, configuration, design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery
Design tab a tab in the Report Layout toolbar that allows you to make modifications to the design of the Report
Design view an Access view that displays the detailed structure of a table, query, form, or report. Also known as developer’s view. For Forms and Reports, this may be the only view in which some tasks are performed. Only the controls, not the data are displayed in this view
Detail the area in a Form that data is displayed and interacted with; may include text boxes, check boxes, combo boxes, labels, pictures and other data editing controls
Developer’s view also known as Design View. The most powerful view in Access
Enable content Microsoft Office's built in security feature
End users the person or people that use the database
Export also known as a ‘dump’, extracting and saving a database file which can be used for storage, distribution or importing into another system
Field a single piece of information that is stored in every record and is represented by a column in a database table
Field name the description that identifies a field
Flat databases a simple database that file that is not related or linked to any other collections of data
Form a database object that you can use to enter new records into a table, or to edit, delete, and display existing records in a table
Form design allows you to work with the underlying structure of your form
Form footer the bottom margin of each page of an Access form
Form header the top margin of each page of an Access form
Form view the Access view in which you can view, modify, delete or add records in a table but you cannot change the layout or design of the form
Form wizard a step by step way to create a form
Format tab a tab in the Report Layout toolbar that allows you to make changes to the formatting of a Report such as Fonts and Backgrounds
Group, Sort and Total a pane that displays at the bottom of the Report window in design view in which you can control how information is sorted, grouped, and totaled in a report
Importing the process of copying data from another file, such as an Excel Spreadsheet, into a separate file, such as an Access table
Information data that is accurate, timely, and organized in a useful manner
Is Null criteria used in queries that that searched for fields that are empty
Knowledge processed information that is useful when making important decisions
Label a control on a form or report that contains descriptive information, usually a field name or title
Layout view the Access view in which you can make changes to o form or report while the data from the underlying data and source displays
Navigation pane an area of the Access window that displays and organizes the names of the objects in a database and allows objects to be opened for use
Object type a way to sort objects in the navigation pane so they are grouped by type
Objects the basic parts of a database that you create to store your data and to work with your data; includes tables, queries forms and reports
One-To-Many the most common type of database relationship between two tables where one record in the first table corresponds to many records in the second table
Page setup a tab in the Report Layout toolbar that allows you to make changes to the Setup of a report to prepare it for printing, such as Page Size and Page Layout
Populate the action of filling a database table with records
Primary key a required field that uniquely identifies a record in a table
Print preview a Report view that displays what the printed report will look like
Property sheet a list of characteristics, or properties, for fields or controls on a form or report in which you can make precise changes to each properly associated with the field or control
Queries a database object that retrieves specific data from one or more database objects, either tables or queries, and displays the requested data in a datasheet
Query grid the bottom pane of the Query Design View window in which you specify the fields, sort order, and limiting criteria for the query
Query wizard a step by step way to create four types of queries to use in accessing and modifying the data in your database
Redundancy in a database, information that is duplicated in a manner that indicates poor database design
Relational databases a sophisticated type of database that has multiple collections of data within the file that are related to one another
Relationships an association that you establish between two tables based on common fields
Report also known as the Report Tool, a quick and easy way to create a new Report
Report view a Report view that is the default view used when you double-click a report in the Navigation Pane
Report wizard a step by step way to create a Report
Short text An Access data type that describes text which can be a combination of letters and numbers that are not used in calculations, such as zip code
Show a checkbox in the Query Grid that enables fields to be shown or hidden
Tables a database object that organizes and presents text and data in columns and rows and is the foundation for databases
Text box a bound control on a form or report that displays the data from an underlying table or query
Unbound label a control that does not have a source of data, such as the title in a form or report
User friendly easy to use and understand, it is a goal to create database that are easy to use

License

Icon for the Creative Commons Attribution 4.0 International License

Computer Usage and Applications Copyright © by Abigail Rusu & Maricopa Millions is licensed under a Creative Commons Attribution 4.0 International License, except where otherwise noted.

Share This Book