62 terms

Microsoft Access


Terms in this set (...)

Append To add to the end of an object
AutoNumber data type
AutoNumber data type Data type the describes a unique sequential or random number
Best Fit
Best Fit An Access command that adjusts the width of a column to accommodate the column's longest entry.
Blank desktop database
Blank desktop database that has no data and has no database tools
Caption Property setting that displays a name for a field in a table
Common field
Common field A field in two or more tables that stores the same data
Currency data type
Currency data type Access data type that describes monetary values and numeric data's that can be used in math
Custom web app
Custom web app Database that you can publish and share with others over the internet
Data about people, events, things, or ideas.
Data source
Data source The table or tables from which a query, form, or report retrieves its data.
Data type
Data type Characteristic that defines data that can be stored in a field, such as numbers, text, or dates.
Database Organized collection of facts about people, events, things, or ideas.
Database management system
Database management system software that controls how related collections od data are stored.
Database template
Database template A preformatted database that contains prebuilt tables.
Datasheet view
Datasheet view Access view that displays data organized in columns and rows.
DBMS Acronym for database
Design view
Design view Access view displays the detailed structure of a table.
Destination table
Destination table Table which you import or append data
Export Copying data from on file into another
Field Single piece of info that is stored in every record.
Field properties
Field properties Characteristics of a field that control how the field displays
First principle of good database design
FPOGDD Principle of a good database design starting that data
Flat database
Flat database Simple database file that isn't related
Form Access object you can use to enter new records into a table
Form view
Form view Access view in which you can view in which you can view records
Import Process of copying data from another file, such as word table or an Excel workbook
Info Data organized in a useful manner
Layout View
Layout view Make changes to a form or report while the object is open
Link Connection to data in another file
Multiple-items form
Multiple-items A form that enables you to display or enter multiple records in a table
Navigation area
Navigation area Bottom of the access window that indicates the number of records in the table
Navigation Pane
Navigation pane Area of the access window that displays and organizes the names of the objects in a database
Norm Process of applying design rules and principles to ensure that your database performs as expected
Number data type
Number data type Access data type that describes numbers that might be used in calculations
Object tab
Object tab, a tab that identifies that objects and which enables you to make the open objects active
Object window
area of the access object window that displays open objects, such as tables, queries , forms, or reports
Objects Basic parts of a database that you create to store your data
Populate Action of filling a database table with records
Primary key
Primary key field in a table that uniquely identifies a record
Property Sheet
Property sheet List of characteristics
Query Object that retrieves specific data
Record All categories of data pertaining to one person
Record selector bar
Record selector Bar at the left edge of a record when it's displays in a from
Record selector box
The small box at the left of a record in datasheet view that, when clicked selects the entire record
Redundant info that is duplicated in a manner that indicates poor database design
Relational database
Sophisticated type of database that has multiple collections of data
Summarizes the fields and records from a table
Searches the records in the tables included in a query design
Second principle of good database design
Principle stating that appropriate stating that database techniques are used to ensure that accuracy
Secure environment
A system that uses controlled servers to ensure the security and privacy of email
Select query
Access query that retrieves data from one or more tables
Computer that provides services on a network such as an email server or a file server
Microsoft app used for setting up web sites to share and manage documents
Short Text data type
Access data type that describes text
Simple select query
Another name for a select query
Single-record form
A form the enables you to display or enter one record at a time in a table
Source file
When importing a fie, refers to the file being imported
Underlying design of a table
Format for info that organizes a presents text and data in columns and rows
Tables and Related Views
In Navigation Pane groups objects by the table to which they relate to
Refers to data that is cut of or shortened
A feature in Microsoft office that walks you step by step through a process