Study sets, textbooks, questions
Upgrade to remove ads
Chapter 1 Access
Terms in this set (62)
to add to the end of an object; for example, to add records to the end of an existing table
AutoNumber data type
a data type that describes a unique sequential or random number assigned by Access as each record is entered and that is useful for data that has no distinct field that can be considered unique
an Access command that adjusts the width of a column to accommodate the column's longest entry.
blank desktop database
A database that has no data and has no database tools-you must create the data and tools as you need them; the database is stored on your computer or other storage device.
A property setting that displays a name for a field in a table, query, form, or report other than that listed as the field name
a field in two or more tables that stores the same data.
currency data type
An Access data type that describes monetary values and numeric data that can be used in mathematical calculations involving values with one to four decimal places.
custom web app
A database that you can publish and share with others over the internet.
facts about people, events, things, or ideas.
The table or tables from which a form, query, or report retrieves its data.
the characteristic that defines the kind
a collection of organized data that allows access, retrieval, and use of data
database management system (DBMS)
database software that controls how related collections of data are stored, organized, retrieved, and secured; also known as a DBMS
a predefined database you can use to assist you in creating a new database
In datasheet view, the table displays its data in rows and columns in a datasheet.
Database Management System
displays the detailed structure of a table, query, form, or report.
The table to which you import or append data.
process of copying data from one file, such as an Access table into Excel spreadsheet
single piece of info that is stored in every record; represented by a column in a database table
characteristics of a field that control how the field displays and how data can be entered in the field
first principle of good database design
A principle stating that data is organized in tables so that there is no redundant data.
A simple database file that is not related or linked to any other collection of data.
an Access object you can use to enter new records into a table, edit or delete existing records in a table, or display existing records
view in which you can view records, but you cannot change the layout design of the form.
process of copying data from another file, such as a Word table or an Excel workbook, into a separate file, such as an Access database
data organized in a useful manner
view in which you can make changes to a form or report while the object is open - the data from the underlying data source displays
connection to data in another file
A form that enables you to display or enter multiple records in a table.
An area at the bottom of the Access window that indicates the number of records in the table and contains controls in the form of arrows that you click to navigate among the records.
an area of the Access window that displays and organizes the names of the objects in a database; from here, you can open objects for use.
the process of applying design rules and principles to ensure that your database performs as expected
number data type
an Access data type that describes numbers that might be used in calculations
a tab that identifies the object and which enables you to make the open object active
displays open objects, such as tables, queries, forms, or reports; by default, each object displays on its own tab
basic parts of a database that you create to store your data and to work with your data; for example, tables, queries, forms, and reports
action of filling a database table with records
field in a table that uniquely identifies a record; for example. a Student ID number
list of characteristics - properties - for fields or controls on a form or report in which you can make precise changes to each property associated with the field or control
A database object which enables you to locate multiple records matching specified criteria
all categories of data pertaining to one person, place, event, thing, or idea; represented by a row in a database table
record selector bar
bar at the left edge of a record when it is displayed in a form, and which is used to select an entire record
record selector box
small box at the left of a record in Database view that, when clicked, selects the entire record
database that has multiple collections
summarizes the fields and records from a table in an easy to read format
The process in which Access looks at the records in the table(s) included in the query design, finds the records that match the specified criteria, and then displays the records in a datasheet; only the fields included in the query design display.
second principle of good database design
A principle stating that techniques are used to ensure the accuracy of data entered into a table
a system that uses controlled servers to ensure that security and privacy of email, to control the storage and use of information and to protect against the loss of confidential data
query that creates subsets of data that you can use to answer specific questions or to supply data to other database objects such as forms and reports
(computer science) a computer that provides client stations with access to files and printers as shared resources to a computer network
a Microsoft technology that enables employees in an organization to access information across organizational and geographic boundaries
short text data type
An Access data type that describes text, a combination of text and numbers, or numbers that are not used in calculations, such as a Postal Code.
simple select query
Another name for a select query.
A form that enables you to display or enter one record at a time in a table.
file being imported
underlying design of a table
format for information
tables and related views
To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.
data cut off
A ________ is a Microsoft Office feature that walks you through steps to complete a complicated task.
Recommended textbook explanations
Introduction to Algorithms
Charles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen
Fundamentals of Python: First Programs
Starting Out with Python plus MyProgrammingLab with Pearson eText -- Access Card Package
Computer Organization and Design MIPS Edition: The Hardware/Software Interface
David A. Patterson, John L. Hennessy
Sets with similar terms
Access Chapter 1 Quizlet
Chapter 1: Microsoft Access
Access Chapter 1
Access Chapter 1
Other sets by this creator
Vocab Chapter 1 PPT
Microsoft Excel- Chapter 3 Vocab
Microsoft Chapter 2
Other Quizlet sets
isds 2001 test 1
Chapter 1- Raj
BTS 168, Ch 1 - Getting Started with Mic…
Access Terms - MOS
T or F: From a pragmatic standpoint, the only important rule of normalization is that the determinant of every functional dependency must be a candidate key.
You want to give a web client a list of their Oracle tables and then allow the user to select a table and see the records. How would you design this with HTML and a PHP script?
You can assign permissions to otehr users at the
How many columns will the relation DRIVER have in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram?