Part of Microsoft Access that is composed of tables, queries, forms, and reports
Attachment
Data type similar to the OLE object that can contain any supported types of file like pictures
AutoNumber
Data type used for the automatic entry of nonrepeating sequential numbers
Calculated
Data type used for entries that need to be calculated
Currency
Data type used for money and is similar with number but with decimal places and a currency symbol
Data
Facts and statistics collected
Data Type
Defines the types of data that the field stores
Date/Time
Data type used to store date and time values that automatically assign a field size
Database
Organized collection of data or information that is related to a particular object
Datum
Singular form of data
DBMS
Electronic or computerized database that will allow the user to access data faster
Fields
General terms, categories, or types of information found in your database
Flat-File Database
Designed to put all your information in one table
Hyperlink
Data type used for entries that contain a path to an object
Large Number
Data type contain much longer greater range for calculation
Long Text
Data type can contain large amounts of alphanumeric data like sentences
Look-Up Wizard
Data type creates a drop-down list from a specified table or form
Manual Database
Traditional way of managing a database using a paper and pen
Many-to-Many
Type of relationship where one record in any table can relate to many records in other tables
Menu bar
Begins with the words File, Home, Create, External Data, Database Tools, Table Tools
Microsoft Access
Database management software used to create small and midsize computer-based databases
Modern Database
Using and creating of the database using computers
Number
Data type can contain numeric values that will be used for calculations
OLE Object
Data type used for storing any objects that can be linked or embedded in a table
One-to-Many
Most common type of relationship that can be established when one record from a table is related to several matching records in other tables
One-to-One
Type of relationship that can be established when one record in a table has only one matching record in another table
Primary Key
One or more fields whose value uniquely identifies each record in a table
Records
One entry in a table
Relational Database
Kind of database wherein one or more tables are linked to other tables in a database
Short Text
Data type can contain alphanumeric characters and special symbols
Tables
Foundation of your database, has rows and columns
Title bar
Part of Microsoft Access located at the top most part of window
Toolbar
Part of Microsoft Access located below the title bar
Yes/No
Data type used for entries that must be answered by a Yes or No, True or False, or On or Off
Polygon
A plane figure formed by three or more segments such that each segment intersects exactly two others, one at each endpoint, and no two segments with a common endpoint are collinear
Polygon
Each segment intersects exactly two others, one at each endpoint
No two segments with a common endpoint are collinear
Angles and Sides of a Polygon
Consecutive sides
Consecutive angles
Included side
Included angle
Diagonal
Convex polygon
A polygonal region where the segment PQ joining any two points P and Q of the region is a part of the region