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

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

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 Word Search Puzzle

Type
Word Search
Description

Report Wizard
Report Tool
Report
Form Tool
Form
Multitable Query
Query Wizard
Record Set
Query
Join Line
Referential Integrity
One-to-Many Relationship
Field Size
Lookup Wizard
Hyperlinks Data Type
Attachment Data Type
OLE Object Data Type
Yes/No Data Type
AutoNumber Data Type
Currency Data Type
Date and Time Data Type
Number Data Type
Memo Data Type
Text Data Type
Data Type
Template
Properties
Database Design
Foreign Key
Primary Key
Record
Field
Table
Database

Excel Lesson 1-4 Crossword

Type
Crossword
Description

gives you fast and easy access to the tools you use most often in Quick Access Toolbar
small badges displaying keyboard shortcuts for specific tabs and commands Key Tips
shows you behind-the-scenes options to manage files such as opening, saving, Backstage View
takes you to Backstage view, with its navigation File Tab
indicates the current cell you are in as well it gives you the opportunity to name the cell or range Name Box
in Excel 2013 is rich in information, illustrations, and tips that can help Help System
takes the information from one location Copy
puts information into another location Paste
options that automatically fill cells with data and/or formatting Auto Fill
is a group of adjacent cells that you select to perform operations on all of the selected cells Range
are a series of settings that allow you to change how a Print Options
commands on the default ribbon tabs are related in functionality Group
files that already include formatting and formulas complete with designs, tools, and specific data types Templates
this can be a number, a cell address, a date, text, or Boolean data, but is usually a number or cell address in terms of formulas Value
identifies a cell’s location in the worksheet, based on its column letter and row number Cell Reference
adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell Relative Cell Reference
refers to a specific cell or range of cells regardless of where the formula is located in the worksheet Absolute Cell Reference
a cell reference that uses an absolute column or row reference, but not both Mixed Cell Reference
is a group of cells, and occasionally a single cell, with a designated name Named Range
its used to edit information in a worksheet, you can make changes directly in the cell or edit the contents of a cell in the... Formula Bar
you highlight the text that is to be changed Selecting Text
are used to identify numeric data and are the most common type of text entered in a worksheet Labels
feature works only for entries that contain text or a combination of text and numbers Auto Complete
is a small green square in the lower-right corner of a selected cell or range of cells Fill Handle

database terminology Crossword

Type
Crossword
Description

Name of Microsoft database Access
Field property that alters the field heading in datasheet view Caption
in order to question a database for Victorian customers only, what feature of the query will be used? Criteria
The field property used to when all customers come from Victoria to reduced input error and save time is? Default
data type is used to create a list box (2 words) Lookup wizard
Type of query that allows user to determine the output Dynamic
Design feature used for a calculated query Builder
Another word for field Attribute
Another word for table Entity
Headers and Footers are created in this view Design
A view to see the data contained in the database Datasheet
Accuracy and consistency of data is enforced by (2 words) Referential integrity
unique identifier (2 words) Primary key
this establishes a link between two tables (2 words) Foreign key
a data type text
Access is an example of what type of database relational
An output that is subtotaled will be created this Access object Report
Used to input data accurately into a database form
data type used for a quantity field Number

Access Lesson 1 Vocab Crossword

Type
Crossword
Description

A menu of options and commands that allows you to access various screens to perform common tasks with your database files. Backstage view
Small square labels where KeyTips are located. Badges
A tool for collecting and organizing information. Database
The visual representation of the data contained in a table or of the results returned by a query. Datasheet
Each column in a table. Field
Accesses the Backstage view. File tab
Small letters and numbers on the Ribbon that execute commands when used with the ALT key. Every command on the Ribbon has a KeyTip. KeyTip
Standards and guidelines that can be used to determine if your database is structured correctly. Normal forms
The process of applying rules to your database design to ensure that you have divided your information items into the appropriate tables. Normalization
Database objects that enable stored data to be searched and retrieved. Query

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 Tech Terms Crossword

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

Spreadsheet Crossword Puzzle

Type
Crossword
Description

Tools used for excel that displays across the top of the window. Ribbon
Starts at the top of the worksheet and goes to the bottom of the worksheet. (A, B ,C) Column
Spreadsheet file. Workbook
A column on the worksheet. Row
Where you enter information. Worksheet
Commands on the default ribbon tab, and adds commands within a group. Group
Make changes directly in the cell. Formula Bar
A cell in excel spreadsheet that is currently selected by clicking mouse pointer or keyboard keys. Active cells
Where you can manage your files. Backstage view
Consists of a column indicator and a row number. Cell address
to keep and store files for future use. Save
A spreadsheet program included in Microsoft office. Excel