Type
Crossword
Description

a collection of organized data that allows access, retrieval, and use of data Database
indicates the type of data that can be stored in a field Data Type
a single characteristic of data that appears in a table as a column Field
a name that identifies a field Field Name
a field that uniquely identifies a record in a table Primary Key
to arrange a list of words or numbers in ascending or descending order Sort
a database view of information arranged in a grid of rows and columns Table
a set of data values of a particular simple type, one for each row of the table Column
sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest Ascending
sort order arranging text or numbers from Z to A, from largest to smallest, or from latest to earliest Descending
a database view that allows the user to see all fields for one record and enter them one at a time Form
a question presented in a way that allows the database to process and generate specific data from one or more tables Query
a collection of fields that appear as a row in a database or table Record
a document that uses data from tables and/or queries, the user controls which items in the database will appear in the report and how it is filtered or sorted Report
the data for a field Entry
Displaying records based on a specified criteria Filtering

Access Crossword puzzle

Type
Crossword
Description

what is a collection of organized data that allows access, retrieval, and use of data. Database
what is the smallest unit of measurement in a database Field
what is to arrange a list of words or numbers in ascending or descending order Sort
what is used to collect data on a particular subject. You can use many tables in a database; each is used to store data on a different subject. Table
what is a question presented in a way that allows the database to process and generate specific data form one or more tables. Query
what allows you to enter or view one record at a time; used to enter or update data. Form
what is a collection of fields that appear as a row in a database or table. Record
what is a field that uniquely identifies a record in a table Primary Key
what is a sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest. Ascending
what is a sort order arranging text or numbers from Z to A, from largest to smallest, or from latest to earliest. Descending
what indicates the type of information that can be stored in a field Data type

MS Access Crossword Puzzle

Type
Crossword
Description

column in a table that contains a specific piece of information within a record. Field
collection of organized data that allow access, retrieval, and use of that data Database
Small box or bar that selects the entire row when clicked Row Selector
A collection of rows and columns Data Sheet
Row in a table that contains specific information about a person, product, or event Record
A object Is Not A Type Of Microsoft Access Database Object Worksheets
The Key Uniquely Identifies Each Record PrimaryKey
Enables You To View Data From A Table Based On A Specific Criterion Query
In the context of databases, a situation that exists between two relational database tables when one table has a foreign key that references the primary key of the other table. Relationship
It is a database management system (DBMS) based on the relational model. RDBMS
An object which stores data in rows and columns. Table
The basic elements of a form or a report are called: Controls
Type of control box which is most often associated with a bound control. TextBox

Database Essentials Vocabulary Crossword

Type
Crossword
Description

A gallery that you can use to insert predefined, templates consisting of objects like tables, forms, and reports into a preexisting databse Application Parts
Two or more primary keys used in a table Composite Key
The kind of information a field contains Data Type
A tool for collecting and organizing information Database
A system for managing data that allows the user to store, retrieve, and analyze information DBMS
A visual representation of the data contained in a table or of the results returned by a query Datasheet
Columns in a database table Field
A primary key from one table that is used in another table Foreign Key
A database object that simplifies the process of entering, editing, and displaying data Form
The standards and guidelines of database design that can be used to determine if a database is structured corrrectly Normal Forms
The process of applying rules to a database design to ensure that information is divided into the appropriate tables. Normalization
Database elements, such as tables, queries, forms, and reports Objects
The column in a database that uniquely identifies each row Primary Key
A database object that enables stored data to be searched and retrieved Query
Row in a database table Record
Duplicate Information Redundant Data
Rule that prevents orphaned records Referential Integrity
A group of database tables that is connected or linked by a defined relationship that ties the information together Relational Database
A database object that presents information in a format that is easy to read and print Report
The most basic database object; stores data in categories Table

Database Crossword

Type
Crossword
Description

What is the name of a collection of organised data? Database
What holds the design and structure of a database inside it? Table
What makes the structure of a database? Field
What makes a field only have one piece of data? Datatype
The collection of values for all fields in one table horizontally is called what? Row
The collection of values for all fields in one table vertically is called what? Column
The connection between two tables is called what? Relation
The connection between two tables using a field is called what? Foreign Key
A table that connects two tables is called what? Primary Key
What allows sorted access to tables, rows and columns? Key

Database Crossword

Type
Crossword
Description

A unique identifier on a database table Primary Key
This object has rows and columns in a database Table
This is used to extract information from a database Query
The object that is used in front of database table to enter information Form
Used to display tables or queries in an organised manner Report
To view used to change field properties in an Access object Design View
This helps to speed up searching in a database Index
This helps you to automate some processes in Access Macro
Used to restrict input in a table field Validation Rule
The default setting of Date and Time field in Access Short Date
These are the correct name for rows in a database table Records
The data type used to format a field to Euro Currency
This data type creates a check box option in a database table YesNo
This is set up in Access when two tables are linked together Relationship
When designed a table in a database each field must have one of these Data Type
To ensure that the same information appears automatically in a field, this is used in the Table design. Default Value
To change all the occurrences of a table entry at once this feature is used Replace
This feature is used to hide records in a table or form that do not need to be seen Filter
In query design view this is clicked to hide the field from showing in the result Show
This tab is used in Access to import information External
The "C" in CSV files Comma
This is used to create objects in Access step by step Wizard
This tab is used to add colour or images to a form in Access Design
A person responsible for the physical design and management of a database Administrator

Tables and Field Properties Crossword

Type
Crossword
Description

lists the database tables and the fields they contain Field List Window
characteristic that defines the appearance and behavior of items in the database such as objects, fields, sections, and controls Properties
string that contains no characters & used to indicate that you know no value exists for a field. zero-length string
The text in the error message that appears when users violate a validation rule validation text
A set of placeholder characters that forces users to enter data in a specific format input mask
A field that allows you to select more than one value from a list mv lookup field
An expression that limits the values that can be entered in the field validation rule
predefined set of characteristics and properties that describes a field Quick Start properties
Tool for collecting and organizing information database
column that uniquely identifies each row primary key
Each row in a table record
Each column in a table field
controls the type of data a field will contain—whether it is text, number, date/time datatype
stores information in separate tables and these tables are connected or linked by a defined relationship that ties the data together Relational Database
primary key from one table is used in another table, this is used to reference the data from the primary key to help avoid redundancy Foreign Key
to arrange it alphabetically, numerically, or chronologically sort
order sorts data from beginning to end, such as from A to Z ascending
order sorts data from the end to the beginning, such as from Z to A, 10 to 1, and December to January descending
a set of rules for determining which records will be displayed filter

Microsoft Excel Spreadsheet Basics Crossword

Type
Crossword
Description

intersection between a row and a column on a spreadsheet that starts with cell A1 cell
is a group of cells within a row or column. cell range
describes how far away a cell or group of cells is from some other cell in the same spreadsheet. cell reference
a vertical series of cells in a chart, table, or spreadsheet; usually identified by an alphabet Column
a feature that allows the user to extend (and fill) a series of numbers, dates, or even text to a desired number of cells. fill handle
a program that reads data in and manipulates the data to fit another output pattern or removes data that may not be needed. Filter
shows the contents of the current cell and allows you to create and view formulas formula bar
a cell with one more cell that has been combined into one cell Merge
a series of data banks laid out in a horizontal fashion in a table or spreadsheet Row
a file made of rows and columns that help sort data, arrange data easily, and calculate numerical data Spreadsheet
describes the process of organizing data in a particular order for easier searching. Sort
an arrangement of information in rows and columns that is much easier to read than a list Table
graphically displays quantitative data area chart
universal keyboard shortcut for the Undo command Ctrl + Z
universal keyboard shortcut for the Redo command Ctrl + Y
keyboard shortcuts for Cut Ctrl + X

Excel Vocabulary Crossword

Type
Crossword
Description

The intersection of a column and a row in a table or worksheet. Cell
The cell in the worksheet in which you can type. Active Cell
A vertical stack of cells in a table or worksheet. Column
An equation that calculates a new value from values currently in a worksheet. Formula
Microsoft Word 2007 Excel
The horizontal placement of cells in a table or worksheet. Row
A computerized spreadsheet. Worksheet
Text stored in a cell that cannot be used in calculations Label
A intersection between a row and a column on a spreadsheet that starts with A1. Cell Address
Is a toolbar at the top of Microsoft Excel spreadsheet window that you can use to enter or copy an existing formula in to cells or charts, Entry Bar
A name that represents a cell, range of cells, formula, or constant value. Number
A range or data that is brought into a worksheet but that originates outside Excel such in a database or text file. Save

Database Vocabulary Words Word Search

Type
Word Search
Description

database management
sorts
advanced filter sort
filter by selection
filters
caption
input mask
format
field size
lookup wizard
yes/no
autonumber
currency
time
date
number
memo
text
record
field
entry
table
database

Microsoft Excel Crossword

Type
Crossword
Description

Appears vertically in a spreadsheet Column
Appears horizontally in a spreadsheet Row
Words or numbers that are entered Lable
Manner in which information is stored into a computer File
Setting that a computer program assumes you will use Default
Function that adds the values of cells Average
Increase or decrease the size of a graphic Handle
Symbol or name that represents something else Variable
Changes the onscreen levels of magnification Zoom
Placing copied data Paste
Numbers that can be manipulated by formulas Value
To highlight a cell or a range of cells Select
Arrangement of cells, objects, or files Adjacent
Excel recognizes a named range Scope
Items on either side of a operator in a formula Operand
Data retrieved from another file saved in a file format Import
Sign used to multiply Asterisk
Makes it easier to organize and fine documents Keyword
An equation Formula
One or more functions are placed inside a main function Nesting