Upgrade to remove ads
Isys 210 Lesson 11
Terms in this set (35)
ompany that sells emergency preparedness and backpacking equipment
file menu tab
tab contains the menu items associated with managing database files.
create menu tab
tab that contains all of the features used to create and manage database objects (a discussion of the four types of database objects is presented below).
external data tab
tab contains the tools used to import data into Access from external sources or export data for other applications (such as Excel) or in other electronic formats.
compact on close
reduce the size of the file every time the file is closed.
tables, queries, forms, reports
four types of objects in Access
Are used to store the data in Access. A ______ consists of columns, which store data fields, and rows, which store database records.
Are used to find the specific data you need from the database. A _______ can be constructed to locate related data across more than one table. Queries can also be used to perform some basic calculations on numeric data.
present the data in a table in a separate window one record at a time. They are used to help with entering new data into a table and to navigate through the records of a table in a user-friendly way.
allow you to organize and present the data in your database. ________are used to present the data in a meaningful way to aid in managerial decision-making. Reports can be generated from tables or queries.
displays the finished object. For example, the _____ ______ of a table will display the finished table on the screen allowing us to add new data to the table
used to edit the object. The design view of a table allows you to add and configure the field in a table.
is like the design view, but it provides fewer options for manipulating the object and is often easier to use than the design view.
Database tables store information about specific things. These specific things are called
The collection of information you have for an instance of an entity is called a
data stored for each database record is an
stored in the columns of tables.
how to create a new table
click on Table Design in the Tables group of menu items in the Create menu tab
Access refers to the attributes of a table as
used to store most data that won't be treated like a number (used in calculations) such as text, telephone numbers, zip codes, etc.
- limited to 255 characters. These characters can be any combination of letters, number, and symbols.
used to store larger amounts of text. The Long Text data type is limited to 65,536 characters and can contain any combination of letters, numbers, and symbols.
used to store data that has only two possible values such as yes or no, true or false, and on or off.
used to store files created by other programs such as Word or Excel documents, picture files, or sound files. Generally, it is better to store this type of data as an Attachment data type rather than an OLE Object data type.
used to simplify data entry.
this is used to set rules for how the data will be entered for the field. For example, you can use an____________ to make sure that users enter 10 digits for a telephone number.
this is used to have Access automatically set a starting value for a field when a new record is added to the table.
validation rule / validation text
They are used to have Access check values when they are entered into a table to make sure they fit a specific rule. For example, you could use a validation rule to make sure that all of the values entered into a field are greater than 10.
first field in a table that is used to uniquely identify each of the records on that table. This field is called a
When a field is used to link two tables
The process of organizing tables and relationships between tables in a database is called
one to one relationship
relationship that represents the situation where a record from one table can only be associated with one record from the other table
one to many relationship
most common type of relationship. relationships that a single record from one table could be associated with more than one record from the other table, but a record from the second table can only be associated with one record from the first table
many to many relationships
relationships represent the case where a record from one table may be associated with more than one record from the other table and a record from the second table may also be associated with more than one record from the first table.
this property is used make sure that a value is entered for a field when a new record is added to a table.
reduce the likelihood that existing records will be changed accidentally when the user adds or updates records
- a window that displays the data in a table to the user.
- very simple and display only a single record from the table at a time.
- used to edit records and add new records.
This set is often in folders with...
ISYS 210 TEST THREE SPEAKER
Isys 210 lesson 12
Isys 210 lesson 13
Isys 210 lesson 14
You might also like...
ISTM - Access (Exam 3)
ISYS 210 Exam 3 Access (Phinney)
Computer Applications Ch. 1-3
ICT Database Vocabulary
Other sets by this creator
SCMT 465 Accronyms
Small Business Ch. 13
SCMT 340 Inco Terms
Other Quizlet sets
Accounting 100 Final Exam Review
Comm Theory Exam 3
Anatomy lab 9
AP Bio Chapter 2 Practice: The Chemical Context of…