Type
Crossword
Description

occurs in database systems which have a field that is repeated in two or more tables Redundancy
A technique of preventing simultaneous access to data in a database, to prevent inconsistent results. Record Locking
A set of properties that guarantee that database transactions are processed reliably ACID
Database transaction is an indivisible and irreducible series of database operations such that either all occur, or nothing occurs Atomicity
Any data written to the database must be valid according to all defined rules, including constraints, cascades, triggers, and any combination thereof Consistency
A DBMS usually acquires locks on data which may result in a loss of concurrency or implements multiversion concurrency control. This requires adding logic for the application to function correctly. Isolation
guarantees that transactions that have committed will survive permanently. For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes Durability
Information processing that is divided into individual, indivisible operations Transaction Processing
A measure of the consistency of the data in a database. It is violated when the relation to which a foreign key refers to no longer exists Referential Integrity
The language and syntax used to write and run database queries SQL
A way of structuring the data in a relational database according to formal rules, in order to avoid problems of efficiency and security in accessing and maintain the data Normal Forms
All non-key elements are fully dependant on the primary key 3NF
All the incomplete dependencies have been removed 2NF
That is a relation in which the intersection of each tuple and attribute contains one and only one value 1NF
A table with no normalisation. All data and all fields in one table 0NF
A data structure that improves the speed of data retrieval operations on a dataset table at the cost of additional writes and storage space Indexing
The process of arranging data in tables and setting their relationships Normalisation
The process of producing a data model for describing the data or information aspects of a business domain or its process requirements, in an abstract way that lends itself to ultimately being implemented in a data such as a relation database ERM
A key field which can be used to access a table in a different way Secondary Key
When more than one field is added together to form a unique primary key for a table Concatenated Primary Key
The linking field in a table formed when a relationship is made Foreign Key
A field that uniquely identifies a record in a table Primary Key
Allows the user to specify information about multiple tables Relational Database

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 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 collection of data organised in a specific way database
The collection of a set of values for all fields in one table row
a field that will uniquely identify each row primary key
The connection between two tables is called the relation
The field used in such a way to connect two tables foreign key
the property of a transaction that guarantees that either all or none of the changes madeby the transaction are written to the database atomicity
the computer memory that is set aside to contain a portion of the database data that has most ecently been accessed by the databasenapplication programe. cache
A foreign key attribute that automatically migrates the changes made to a referenced table to all of the referencing table rows cascade
a process where seleced modifications in a master database is re-playes into another database replication
a copy of a product, or any of its components, installed on a single machine seat

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

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

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

Technology Crossword

Type
Crossword
Description

The opening page of a website. homepage
A computer language used to create web pages. HTML
A file format for compressing pictures JPEG
A link from a hypertext file or document to another location or file, activated by clicking on a highlighted word or image on the screen. hyperlink
The ability to use technology to find, organize, and evaluate information. digitalliteracy
A group of networked computers that share a common address (.edu, .com). Domain
The process of converting data into code. encryption
A security system that protects a network. firewall
A way to narrow search results by using the operators AND, OR, & NOT. BooleanLogic
A temporary storage place for quick retrieval of frequently used data. cache
A small text file stored in a computer’s hard drive by a website. cookie
An organized collection of information that is searchable. database
To practice appropriate and responsible behavior when using technology digitalcitizenship
The text field in a web browser where an URL is displayed or typed. addressbar
The amount of data that can be sent through a connection at one time. bandwidth
To save the URL of a webpage for easy access in the future. bookmark
Instructions you input for a computer to follow. code
The action of writing CODE or instructions for the computer to follow. programming
An unit of memory (8 binary digits represent a character). byte
Central Processing Unit- The brain of the computer. cpu
A program that searches for items in a database or sites on the WWW. searchengine
Uniform Resource Locator- The address of a resource on the WWW. url
A program used to navigate the WWW. browser
The global system of interconnected computer networks that link billions of devices. internet
A set of computers connected together for the purpose of sharing resources. network
Hyper Text Transfer Protocol- the set of rules for transferring files on the World Wide Web. http

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

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

Computer Networks Crossword

Type
Crossword
Description

What is it called when computers and other devices that are connected to share hardware, software, and data? Computer Network
A real time, face to face meeting between individuals not in the physically in the same place is called? Videoconference
A phone, such as a cellular or satellite phone, that uses a wireless network. mobile phone
The act of working from a remote location bu using computers and networking technology. telecommute
The use of networking technology to provide medical information and services telemedicine
A network that uses a central device connected directly to several other devices star network
In a client-server network, a computer that is dedicated to processing client requests. server
A location that provides wireless Internet access. hotspot
A network in which computers and other devices are connected to the network via physical cables Wired Network
A network in which computers and other devices are connected without physical cables Wireless Network
A network that uses a central cable to which all network devices connect. Bus Network
In a client server network, a computer or other device that requests and uses network resources. Client
To retrieve files from a server download
to transfer files to a server upload
a private network that is set up similarly to the internet and is accesses via a Web browser Intranet
The amount of data that can be transferred, such as via a bus or over a networking medium, in a given time period. bandwidth
An intranet that is at least partially accessible to authorized outsiders. Extranet
The amount of data that is transferred under real life conditions. Throughput
A method of transmitting data in which data is sent out to all nodes on a network and is retrieved only by the intended recipient. Broadcasting
A networking standard for very short-range wireless connections Bluetooth