Glossary

to add on to the end of an object, for example, adding records to the end of an existing table in a database

an Excel feature that generates and extends values into adjacent cells based on the values of the selected cells

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

A centralized space for file management tasks such as opening, saving, printing, or sharing a file

anything typed into a cell

Online storage of data including files and folders that allows access from different places and devices

a vertical group of cells in a spreadsheet, indicated by letters

a device for computing

a set value that does not change and is directly typed into a cell. There are two types: text and number values

Microsoft’s personal assistant in Windows 10

Facts about people, events, things, or ideas

classification identifying the kind of data that can be stored in a field such as numbers, text, or dates

an organized collection of facts about people, events, things, or ideas related to a specific topic or purpose

the Access view that displays data organized in columns and rows similar to an Excel spreadsheet

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

Microsoft Office’s built-in security feature

the person or people that use the database

Information, such as a document, stored on a computer under a single name

the small square in the lower right-hand corner of a selected cell

a simple database file that is not related or linked to any other collections of data

A spot to store and organize files on a computer

an equation that performs a mathematical calculation on values in a worksheet

An acronym that stands for Graphical User Interface: graphics such as an image of a file or folder that you click to perform an action

the process of copying data from another file, such as an Excel Spreadsheet, into a separate file, such as an Access table

data that is accurate, timely, and organized in a useful manner

processed information that is useful when making important decisions

Any disk, drive, folder, or another place on your computer in which you can store files and create folders

A version of Microsoft Office that includes Word, Excel, Access, and PowerPoint to which you subscribe for an annual fee

Appears whenever you right-click text in Word, Excel, or PowerPoint and provides a quick-access version of the Font group on the Home tab, plus a few extra buttons from other groups

an element of the Excel window that displays the name of the selected cell, table, chart, or object

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

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

A computer program that manages the other programs and devices on a computer

A computer program that manages the other programs and devices on a computer

the action of filling a database table with records

a required field that uniquely identifies a record in a table

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

the bottom pane of the Query Design View window in which you specify the fields, sort order, and limiting criteria for the query

a step-by-step way to create four types of queries to use in accessing and modifying the data in your database

two or more selected cells on a worksheet that are adjacent or nonadjacent

in a database, information that is duplicated in a manner that indicates poor database design

a sophisticated type of database that has multiple collections of data within the file that are related to one another

an association that you establish between two tables based on common fields

a horizontal group of cells in a spreadsheet, indicated with numbers

software for working with data

Also called synching, is the process of updating computer files that are in two or more locations according to specific rules

a moveable, resizable container for text or graphics

Also called a removable storage device, used to save and transfer information from one computer to another

easy to use and understand; it is a goal to create databases that are easy to use