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

auto fill

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

Backstage View

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

Cell content

anything typed into a cell

Cloud storage

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

constant value

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

data type

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

Datasheet View

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

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

Enable Content

Microsoft Office’s built-in security feature

end users

the person or people that use the database


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

fill handle

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

flat databases

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

Microsoft 365

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

Name Box

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

operating system

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


the action of filling a database table with records

Primary Key

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

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


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

relational databases

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

USB flash drive

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

user friendly

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


Icon for the Creative Commons Attribution 4.0 International License

Computer Applications Copyright © 2022 by LOUIS: The Louisiana Library Network is licensed under a Creative Commons Attribution 4.0 International License, except where otherwise noted.

Share This Book