Data types Text
Numeric Boolean
Date/Time Currency
AutoNumber Binary

 

A data type used to store alphanumeric data such as names, descriptions, or addresses. The different kinds of data that can be stored in a database.
A data type used to store true/false or yes/no values in a database. A data type used to store numbers in a database.
A data type used to store monetary values in a database. A data type used to store dates and times in a database.
A data type used to store images, videos, or other non-text data in a database. A data type used to assign a unique, incremental number to each record in a database table automatically.

 

Long Text Lookup
Hyperlink Attachment
Primary key Foreign key
Relationship Table

 

A data type used to create a dropdown list of values from another table in a database. A data type used to store large amounts of text such as comments or descriptions in a database.
A data type used to attach files to a record in a database, such as a resume or cover letter. A data type used to store web addresses or email addresses in a database.
A field that refers to a unique identifier in another database table, thereby establishing a relationship between the two tables. A unique identifier in a database table that is designated to be the main way to access and retrieve data.
An arrangement of data into rows and columns, comprising fields and records. The association between tables in a database, established through the use of primary and foreign keys.

 

Field Record
Data Create
Operations Access
Retrieve Designate

 

A row in a database table that represents a unique instance of data. A column in a database table that contains a specific piece of information.
To establish or bring into existence. Information that is stored in a database table.
The ability to retrieve, view, or modify data in a database. The actions that can be performed on data in a database, such as inserting, deleting, and updating records.
To assign or identify something for a particular purpose or function. To obtain or access data from a database.

 

database components
data organized
stored create
query table

 

The different parts that make up a database, such as tables, forms, queries, and reports. A structured set of data held in a computer and organized in such a way that it can be easily accessed, managed, and updated.
Arranged in a systematic way, often according to specific rules or guidelines. Facts and statistics collected together for reference or analysis.
To build or make something new, such as a database or table. Saved or held in a particular place, often for future use or reference.
A collection of related data held in a structured format within a database. A specific request for information from a database, often used to filter or sort through data.

 

form report
field record
Database Validation Database Verification
Record Count Verification Field Specification Verification

 

A formatted view of database data that can be printed or viewed on screen, often used for analysis or communication purposes. A type of database object used to enter, edit, or view data in a table or query.
A complete set of related information within a database, often represented by a row in a table. A specific piece of data within a database, such as a name or date.
The process of ensuring that a database is valid, accurate, and consistent by comparing it with a source of truth. The process of checking if the data in a database is accurate and conforms to certain rules and constraints.
The technique used for ensuring that the data in a database is of the correct type, length, and format. The technique used for checking if the number of records in a database is correct.

 

Range Check Validation Format Check Validation
Consistency Check Validation Completeness Check Validation
Redundancy Check Validation Data Type Check Validation
Referential Integrity Verification Practical Scenario

 

The technique used for checking if the data in a database field conforms to a specified format, such as a phone number or email address. The technique used for checking if the values in a database field fall within a specified range or set of values.
The technique used for ensuring that all required data is present in a database. The technique used for ensuring that the data in a database is consistent across tables and fields.
The technique used for checking if the data in a database is of the correct data type, such as text, numeric, or date. The technique used for checking if there are any duplicate or unnecessary records or fields in a database.
An application of the techniques learned in this lesson in a real-world situation. The technique used for ensuring that the relationships between tables and fields in a database are valid and consistent.

 

Database validation Database verification
Validation error Verification error
Syntax error Logical error
Input error Output error

 

The process of checking and confirming that data entered into a database is correct and matches the original source data. The process of ensuring that data entered into a database meets specified requirements and is accurate.
An error that occurs when data entered into a database does not match the original source data, such as incorrect data entry or data corruption during transmission. An error that occurs when data entered into a database does not meet specified requirements, such as incorrect or incomplete data.
An error that occurs when the program logic or database design is flawed, causing incorrect or unexpected results. An error that occurs when data entered into a database does not adhere to the syntax rules of the database engine or programming language used.
An error that occurs when the output or result of a database query or operation is incorrect or unexpected. An error that occurs when incorrect or incomplete data is entered into a database.

 

Redundancy error Normalization error
Data integrity Data validation
Sorting data Multiple fields
Descending order Database

 

An error that occurs when a database is not properly normalized, leading to data inconsistencies, inefficiencies and potential errors. An error that occurs when data is duplicated or repeated unnecessarily in a database, leading to inefficiency and potential data inconsistencies.
The process of verifying that input data is correct, complete and meets specified requirements. The assurance that data entered into a database is accurate, consistent and meets specified requirements.
The process of sorting data based on two or more fields. The process of arranging data in some logical order.
A collection of data that is organized in a way that allows users to access, manage, and update it easily. The process of arranging data from highest to lowest or from A to Z.

 

Importance Learn
Practice Spreadsheet
Arranging Logical order
Degree Significance

 

The act of gaining knowledge or skill through study, instruction, or experience. The degree to which something is of significance or value.
A program used to organize and manipulate data in rows and columns. The act of repeatedly doing something in order to improve skill or proficiency.
The process of arranging data in a way that makes sense or is understandable to people. The process of putting things in a particular order based on some criteria.
The quality of being important or having an impact on something. A measure of the extent or amount of something.

 

Consistent Formatting Inputting Data
Tables Forms
Real-World Scenarios Data Accuracy
Data Integrity Data Security

 

The act of entering data into a table or form. The process of ensuring that the way data is presented in tables and forms remains uniform throughout the document.
A document used to gather information for a specific purpose. A tool used to organize data into rows and columns.
The degree to which data is correct and error-free. Situation outside of a classroom setting where data is being inputted into tables and forms with consistent formatting.
The protection of data from unauthorized access. The assurance that data is consistent and reliable.

 

Data Validation Input Mask
Data Type Field
Search/Query Single Criterion Search/Query
Multiple Criteria Search/Query Key Features

 

A predetermined format for inputting data into a form. The process of verifying that data conforms to a predefined set of rules or requirements.
A specific area within a form or table for entering data. A category assigned to data for the purposes of validation and presentation.
A type of search/query that uses only one attribute or parameter to find relevant information. A process of finding and retrieving specific information from a database or search engine.
The important and distinguishing aspects or characteristics of search/query functions. A type of search/query that uses multiple attributes or parameters to find relevant information.

 

Boolean Operators Wildcards
Filters Sorting
Practical Scenarios Comparison
Contrast Attribute

 

Characters used in a search query to stand for unknown or variable parts of a search term. The logical operators (AND, OR, NOT) used to combine search terms for more effective search results.
The process of arranging search results in a specific order, based on a chosen attribute or parameter. Parameters used to refine or narrow search results based on specific criteria.
The process of identifying similarities and differences between single criterion and multiple criteria search/query functions. Real-world situations where search/query functions are applied to find specific information or solve a problem.
A characteristic or property of a database record or object that can be used to query or filter information. The process of highlighting the differences between single criterion and multiple criteria search/query functions.

 

Relational operators Logical operators
AND operator OR operator
Comparison operator Query
Successful query Unsuccessful query

 

Symbols used to combine two or more conditions, such as AND or OR Symbols used to compare two values, such as less than (<) or equal to (=)
A logical operator that returns true if at least one of the conditions is true A logical operator that returns true only if both conditions are true
A request for information from a database using specific criteria Symbols used to compare two values for equality or inequality, such as = or !=
A query that does not return the desired information from a database A query that returns the desired information from a database

 

Boolean value Logical expression
Conditional expression Troubleshoot
Creating reports Customizing reports
Specified fields Microsoft Access

 

A combination of conditions using logical operators A value that is either true or false
To identify and fix problems in a process or system A combination of conditions using comparison and logical operators
The act of modifying reports to suit specific needs and preferences. The process of generating reports using Microsoft Access.
A database management system developed by Microsoft Corporation. Certain fields in a database selected for inclusion in a report.

 

Effective data analysis Report customization
Database management system Generating reports
Data analysis Database
Decision making Modifying reports

 

The process of tailoring reports to meet specific requirements. The use of meaningful insights derived from data to improve decision making.
The act of creating reports using a database management system. Software that enables users to create, manipulate, and maintain databases.
A structured collection of data stored and retrieved using a computer system. The process of examining data to draw conclusions or identify patterns.
Changing the layout, format or content of reports. The process of making choices by identifying and evaluating options.