Study sets matching "access"

Study sets
Classes
Users

Study sets matching "access"

25 terms
ACCESS
database management system
design
reserved
255
Access is a _____.
Database _____ refers to the arrangement of data into tables…
_____ words are words that have a special meaning to Access a…
In Access, table and field names can be up to _____ character…
database management system
Access is a _____.
design
Database _____ refers to the arrangement of data into tables…
56 terms
Access
Elements of an access database (tables…
Datasheet view of a table is similar to
Within a table in the data sheet view,…
Mary wants to have data in the phone n…
Objects
An excel spreadsheet
Is called a record
Enter design view and apply a data mask to that value
Elements of an access database (tables…
Objects
Datasheet view of a table is similar to
An excel spreadsheet
56 terms
Access
Elements of an access database (tables…
Datasheet view of a table is similar to
Within a table in the data sheet view,…
Mary wants to have data in the phone n…
Objects
An excel spreadsheet
Is called a record
Enter design view and apply a data mask to that value
Elements of an access database (tables…
Objects
Datasheet view of a table is similar to
An excel spreadsheet
25 terms
Access
Database
DBMS
Table
Query
A collection of related information
Database Management System
Stores data in a format similar to a worksheet; all database…
A search method used to retrieve data from tables based on cr…
Database
A collection of related information
DBMS
Database Management System
5 terms
Access
CREEK
GENUINE
VAGUE
TROOP
SMALL RIVER
REAL
NOT CLEAR
A GROUP OF PEOPLE OR ANIMAL
CREEK
SMALL RIVER
GENUINE
REAL
Access
backstage view
badges
help menu
database
Contains many of the commands that were on the file menu in p…
small square labels that contain keytips
a menu that enables you to choose between searching help topi…
a tool for collecting and organizing information
backstage view
Contains many of the commands that were on the file menu in p…
badges
small square labels that contain keytips
33 terms
Access
Append
Blank database
Calculated field
Common field
Add to the end of an object
A database that has no database objects
A field that displays the value of a mathematical operation
A field in one or more tables that stores the same data
Append
Add to the end of an object
Blank database
A database that has no database objects
8 terms
access
data base
record
field
text field
collection of data that allows access retrieval and use
rows in the table
colums in a table
any charcters
data base
collection of data that allows access retrieval and use
record
rows in the table
13 terms
Access
Access
Database
One database can have
Tables
Database managing system
Tool for collecting and organizing information
Multiple tables
Hold all the information or data
Access
Database managing system
Database
Tool for collecting and organizing information
41 terms
Access
database
table
simple database
relational database
an organized collection of related information
where a database stores data in one or more spreadsheet-like…
database containing just one data
database that contains two or more tables of related informat…
database
an organized collection of related information
table
where a database stores data in one or more spreadsheet-like…
access
Data base
records
field
numbers
collection of data
the rows in the table
(column in a table)
numbers
Data base
collection of data
records
the rows in the table
20 terms
ACCESS
ADO
DAO
recordset object declaration
DB object deceleration
Active Data Object... ActiveX Data Objects
Data Access Objects... typically Microsoft Jet Database
Dim rs As DAO.Recordset
Dim db As Database
ADO
Active Data Object... ActiveX Data Objects
DAO
Data Access Objects... typically Microsoft Jet Database
71 terms
Access
A database object that retrieves speci…
A flat database
A query is a database object that
An Access record is saved when you
query
is not related to any other collection of data.
retrieves specific data from one or more database tables or q…
move to the next record.
A database object that retrieves speci…
query
A flat database
is not related to any other collection of data.
access
cascade delete
cascade update
child field
foreign key
when a record in a parent table, access deletes all the relat…
when the primary key field is updated in a relationship, the…
Related field from the child table of the relationship
a field in the child table that is related to the primary key…
cascade delete
when a record in a parent table, access deletes all the relat…
cascade update
when the primary key field is updated in a relationship, the…
Access
database management system
store, retrieve, analyze, print
objects
tables
What does DBMS stand for?
DBMS allows you to _______, _______, _______, and _______ inf…
A database is a collection of _______.
These store all data in format called datasheets
database management system
What does DBMS stand for?
store, retrieve, analyze, print
DBMS allows you to _______, _______, _______, and _______ inf…
Access
the basic part of a database that you…
the collection of related information…
a form that displays one record at a t…
a data type that automatically assigns…
data type
record
single form
autonumber
the basic part of a database that you…
data type
the collection of related information…
record
112 terms
Access
View that enables you to add, edit, an…
An Access object that enables you to e…
An Access utility that reduces the siz…
A main component that is created and u…
Datasheet view
Form
Compact and Repair
Object
View that enables you to add, edit, an…
Datasheet view
An Access object that enables you to e…
Form
Access
database
table
record
field
an organized collection of data related to a particular topic…
a list of data organized in rows and columns
a single row in a table
a specific category of information in a database such as name…
database
an organized collection of data related to a particular topic…
table
a list of data organized in rows and columns
71 terms
Access
A database object that retrieves speci…
A flat database
A query is a database object that
An Access record is saved when you
query
is not related to any other collection of data.
retrieves specific data from one or more database tables or q…
move to the next record.
A database object that retrieves speci…
query
A flat database
is not related to any other collection of data.
Access
DATABASE
DATA
INFORMATION
DATABASE MANAGEMENT SYSTEM (DBMS)
Collection of data organized as meaningful information that c…
What is entered into a database... Converted to information by s…
The finished product that is produced by the database
Software system that provides the tools needed to create, mai…
DATABASE
Collection of data organized as meaningful information that c…
DATA
What is entered into a database... Converted to information by s…
36 terms
Access
Data
Information
Database
Data Management
raw facts
data converted into meaning
keeps information about different people, places. events and…
structured way to capture, store, process, integrate, distrib…
Data
raw facts
Information
data converted into meaning
Access
A database object that retrieves speci…
A flat database
A query is a database object that
An Access record is saved when you
query
is not related to any other collection of data.
retrieves specific data from one or more database tables or q…
move to the next record.
A database object that retrieves speci…
query
A flat database
is not related to any other collection of data.
access
aspirin
chain
cookery
crime
аспирин
цепочка
кулинарная
преступление
aspirin
аспирин
chain
цепочка
Access
complet
entrée libre
fermé
fermer
full
free entry
closed
to close
complet
full
entrée libre
free entry
12 terms
Access
database
concept mapping tool
digital environments
digital model
Software which allows the user to systematically search for,…
a device or software application which enables the user to cr…
an artificial environment (surroundings, area, place, or cont…
a model (representation, schematic, replica, reproduction, ex…
database
Software which allows the user to systematically search for,…
concept mapping tool
a device or software application which enables the user to cr…
20 terms
Access
Field
Record
Table
Database
the smallest data element contained in a table (last name, fi…
a complete set of all of the data elements about one person,…
the foundation of every database. A collection of related rec…
consists of one or more tables to store data, one or more for…
Field
the smallest data element contained in a table (last name, fi…
Record
a complete set of all of the data elements about one person,…
118 terms
Access
Which software program is used to crea…
In Microsoft Access, which area provid…
Which type of database consists of a c…
Which term refers to storing the same…
Microsoft Access
Status bar
Relational
Redundancy
Which software program is used to crea…
Microsoft Access
In Microsoft Access, which area provid…
Status bar
9 terms
Access
complet
entrée libre
fermé
fermer
full/complete
free entry
closed
to close
complet
full/complete
entrée libre
free entry
Access
Access
Fertilizer
Constructed
Soil
A way to getting near
A substance that is added to soil to help the growth of plants
To build something
The top lager of earth in which plants
Access
A way to getting near
Fertilizer
A substance that is added to soil to help the growth of plants
10 terms
Access
auf sein
aufmachen
besetzt
der Eintritt
to be up
to open
to occupy
to enter
auf sein
to be up
aufmachen
to open
9 terms
Access
complet/complète
entrée l' (f)
libre
fermer
full
entry/entrance
free/vacant/unoccupied
to close
complet/complète
full
entrée l' (f)
entry/entrance
57 terms
Access
Exact Match
Show
Drag
Navigation
The condition that requires a value in a specified field to b…
You can tell if a field will appear in the query datasheet if…
To include a field in a query, you can click and _______the f…
In a form with a main form and a subform, there will be two s…
Exact Match
The condition that requires a value in a specified field to b…
Show
You can tell if a field will appear in the query datasheet if…
Access
Relational database software
Object
Navigation Pane
Table
Software such as Access that is used to manage data
A table, query, form, macro, or module in a database
A pane in a window that contains links to folders and libraries
A collection of records for a single subject, such as all of…
Relational database software
Software such as Access that is used to manage data
Object
A table, query, form, macro, or module in a database
14 terms
Access
abierto/a
el acceso
cerrar
gratuito/a
open
access
to close
free
abierto/a
open
el acceso
access
Access
database
tables
Record
field
file containing related tables and objects
all of the related records for one logical group
all of the fields created to one logical unit in the table su…
a single component of info bout a person, place item, object
database
file containing related tables and objects
tables
all of the related records for one logical group
14 terms
access
Abierto/a
El acceso
Cerrar
Gratuito/a
Open
Access
To close
free
Abierto/a
Open
El acceso
Access
20 terms
Access
AND Criteria
AutoNumber
Current Record
Data Type
Criteria placed in the same row of the query design grid.
A field data type in which Access enters a sequential integer…
The record that has the focus or is being edited.
A required property for each field that defines the type of d…
AND Criteria
Criteria placed in the same row of the query design grid.
AutoNumber
A field data type in which Access enters a sequential integer…
52 terms
Access
To specify AutoCorrect rules and excep…
To create an initial report that can b…
To add a record to a table, tap or cli…
To show the symbol for the Euro instea…
Options
Report
New (blank)
Format
To specify AutoCorrect rules and excep…
Options
To create an initial report that can b…
Report
Access
Microsoft® Access
Database
Table
Field
program which allows for the creation and management of vario…
collection of objects which work together to store, retrieve,…
collection of fields which store data
single piece of information related to the person, place, obj…
Microsoft® Access
program which allows for the creation and management of vario…
Database
collection of objects which work together to store, retrieve,…
40 terms
Access
datasheet view
form
compact and repair
object
view that enables you to add, edit, and delete the records
ab access object that enables you to enter modify or delete t…
an access utility that reduces the size of the database and c…
a main component that is created and used to make a database…
datasheet view
view that enables you to add, edit, and delete the records
form
ab access object that enables you to enter modify or delete t…
Access
Miami Herald v. Tornillo
Turner Broadcasting v. FCC
Reasons to license broadcasters
Equal Opportunity Rule
A candidate tries to reply back to his local paper after it p…
Certain cable providers try to exclude basic channels; the co…
There is a finite amount of space on the airwaves
You have to give all politicians the same amount of air time.…
Miami Herald v. Tornillo
A candidate tries to reply back to his local paper after it p…
Turner Broadcasting v. FCC
Certain cable providers try to exclude basic channels; the co…
40 terms
Access
A database management system is
Access is
The five advantages to using a compute…
A database is
a system that allows you to store, retrieve, analyze, and pri…
a dbms (database management system)
it's 1) fast 2) flexible 3) accurate 4) efficient 5) cost eff…
a collection of objects
A database management system is
a system that allows you to store, retrieve, analyze, and pri…
Access is
a dbms (database management system)
20 terms
Access
ascending sort
data type
datasheet view
descending sort
sort that arranges records from A to Z or smallest to largest
Indicates the type of data that can be stored in a field
The view of a database table that displays data in rows and c…
Arranges data with letters from Z to A, data with numbers fro…
ascending sort
sort that arranges records from A to Z or smallest to largest
data type
Indicates the type of data that can be stored in a field
Access
the basic part of a database that you…
the collection of related information…
a form that displays one record at a t…
a data type that automatically assigns…
data type
record
single form
autonumber
the basic part of a database that you…
data type
the collection of related information…
record
11 terms
Access
auf
zu
aufmachen
besetzt
open
shut
to open something
occupied, busy
auf
open
zu
shut
17 terms
Access
record
database
query
datasheet view
a complete set of data about 1 thing... (remember 1 row is 1 ___…
an organized collection of information about a subject
a powerful searching tool that can isolate a group of records…
displays the table in a column and row format similar to a sp…
record
a complete set of data about 1 thing... (remember 1 row is 1 ___…
database
an organized collection of information about a subject
10 terms
Access
identified
benefit
evidence
distribution
establish or indicate who or what is
an advantage or profit gained from something.
the available body of facts or information indicating whether…
the action of sharing something out among a number of recipie…
identified
establish or indicate who or what is
benefit
an advantage or profit gained from something.
ACCESS
Database management system
OLE object
Create
Design
Access is a...?
The field whose data type is ____ can store an OLE object, wh…
One way to create a table, is to click ____ on the ribbon and…
You only can delete a primary key in ____ view
Database management system
Access is a...?
OLE object
The field whose data type is ____ can store an OLE object, wh…
Access
AND
Comparison Operator
Compound Criterion
data type
each individual criterion must be true in order for the compo…
symbol used to produce numeric results (>, <, >=, <=, and NOT)
using more than one criterion that the data for which you are…
A field property in Access that determines the type of data a…
AND
each individual criterion must be true in order for the compo…
Comparison Operator
symbol used to produce numeric results (>, <, >=, <=, and NOT)
Access
complet
entrée libre
fermé
fermer
full
open (without obligation to buy)
closed
to close
complet
full
entrée libre
open (without obligation to buy)
1 of 10