Ms Acess

Front 1

Tables

Back 1

store your data

Front 2

Queries

Back 2

allow you to view, change, and analyze data from tables

Front 3

Forms

Back 3

view, add, and update data in tables

Front 4

Reports

Back 4

control how the data is printed

Front 5

Data access pages

Back 5

view, update, or analyze your database's data from Internet or local network.

Front 6

Fields

Back 6

– separate information that describe the data item (headings in a file folder)

Front 7

Records

Back 7

- individual data items (individual folders)

Front 8

Database

Back 8

- the complete collection

Front 9

Design View

Back 9

View create the fields of your table before inputting any data in your table.

Front 10

Types of Databases
Centralized

Back 10

- has all of its data at one site (Microsoft Access)

Front 11

Distributed Databases -

Back 11

stored on more than one location

Front 12

Flat File Database

Back 12

- each database contained in a single table that consists of single files –

Front 13

Hierarchical Data

Back 13

data in a tree-like structure and its elements are connected in a one-to-many relationship

Front 14

Network Model

Back 14

variation of the hierarchical data model - many-to-many relationships

Front 15

Microsoft Access

Back 15

- relational DBMS - store information in databases and manipulate it

Front 16

Relationships

Back 16

- establishing a certain association between common fields in tables

Front 17

Primary Key

Back 17

- contain unique information about the records

Front 18

Foreign Key

Back 18

- consists of one or more fields to which a primary key in another table refers

Front 19

3 Primary Key Types

Back 19

AutoNumber
Single-field each field must be unique
Multiple-field can't guarantee that any one field will contain unique information

Front 20

Types of Relationships

Back 20

One-to-One relationship
One-to-Many relationship
Many-to-Many relationship

Front 21

One-to-One relationship

Back 21

one record in Table A relating to only one record in Table B

Front 22

One-to-Many relationship

Back 22

one record in Table A relates to zero, one, or more records in Table B.

Front 23

Many-to-Many relationship

Back 23

allows for more than one record of Table A to relate to more than one record of Table B should be avoided

Front 24

What is a database

Back 24

organized collection of information

Front 25

What is a Database Management System (DBMS)

Back 25

software package used for creating a database

Front 26

When there is one record in the Customer Table that relates to one or more records in the Billing Table, we say that it is what kind of relationship?

Back 26

One-to-many relationship

Front 27

What are the set of rules that Access uses in order to enforce consistency between tables?

Back 27

Referential Integrity

Front 28

In Access, one database table can be related to another, which is generally referred to as performing a _____________ .

Back 28

Join

Front 29

A field or a set of fields with a unique value in the primary table is considered a

Back 29

Primary Key

Front 30

A relational database reduces ___________.

Back 30

Data redundancy

Front 31

The primary key of one table and the foreign key in another table form a __________.

Back 31

Relationship

Front 32

What are the plus symbols for when entering or viewing data in the datasheet view?

Back 32

For accessing related data through a subdatasheet

Front 33

What are all of the different types of primary keys that are allowed?

Back 33

AutoNumber, Single-field, and Multiple-field

Front 34

A foreign key field can't contain duplicate data.

Back 34

False

Front 35

The data types of the primary key and foreign key fields must be the same although there are two exceptions.

Back 35

True

Front 36

When designing a query, you can specify the order in which the fields should be sorted.

Back 36

True

Front 37

The Simple Query Wizard helps you to create queries that retrieve data from the fields that you specify in the tables or queries in your database.

Back 37

True

Front 38

Which type of query is used to append the records from one or more tables to the end of one or more tables?

Back 38

Append

Front 39

What is the Update query used for?

Back 39

To perform mass updates

Front 40

If you looked at a query in design view and saw that the fifth column contained Total Sales:[UnitPrice]*[UnitsSold] what type of field do you think it would be?

Back 40

Calculated Field

Front 41

A query designed by the Simple Query Wizard cannot be modified.

Back 41

False

Front 42

What are the types of Action Queries?

Back 42

Delete, Update, Append, and Make Table

Front 43

Why do we need queries?

Back 43

To extract specific data from a database.

Front 44

Select queries:

Back 44

A) Retrieve data from one or more tables by using criteria you specify and then display the data.

Front 45

Which type of query prompts the user for input?

Back 45

Parameter query

Front 46

The Query Wizard can be used to extract information from tables, queries, or both.

Back 46

True

Front 47

Calculated Field is created using mathematical expressions, or equations, to determine the contents that are displayed in the control object

Back 47

True

Front 48

Which is the most dangerous Action query?

Back 48

Delete

Front 49

Query means to _____________.

Back 49

Ask a question

Front 50

It's a good idea to make a copy of the data you are changing or moving in an action query, in case you need to restore the data to its original state after running the action query.

Back 50

True

Front 51

Referential integrity rule that permits a change in value to the primary key and changes the appropriate foreign key values in a related table

Back 51

Cascade update

Front 52

A referential integrity rule that permits a record in the primary table to be deleted and also deletes all records in related tables that have matching foreign key values.

Back 52

Cascade delete

Front 53

The field used to determine the order of records in a datasheet form, or other object.

Back 53

Sort field

Front 54

Sort field whose value is different for each record

Back 54

Unique sort field

Front 55

A sort field for which more than one record can have the same value.

Back 55

Non unique sort field

Front 56

A statement containing a combination of database fields, constants, and operators that you define in a query to perform a calculation

Back 56

Expression

Front 57

A field that displays the results of an expression in a query datasheet or a form or report, but does not exist as a field in the database.

Back 57

Calculated field

Front 58

A relationship between two tables in which each record in the primary table matches zero, one, or many records in the related table, and in which each record in the related table matches at most one record in the primary table.

Back 58

One-to-many relationship

Front 59

A set of values that Access enforces to maintain consistency between related tables when you update data in a database. Also, the integrity constraint specifying that each nonnull foreign key value must match a primary key value in the related table.

Back 59

Referential Integrity

Front 60

A ____________ is a collection of 8 bits.

Back 60

character

Front 61

A collection of related bytes is called a?

Back 61

table

Front 62

A collection of related fields is called a ?

Back 62

record

Front 63

A collection of related records is called a?

Back 63

field

Front 64

A database consists of rows and columns. Each row is a ____________, while each column represents ______________

Back 64

record,
field

Front 65

What is the name of the software tool that can be used to create a database; add, change, and delete data in the database; sort and retrieve data; and create forms and reports using the data in the database?

Back 65

database management system

Front 66

In a database table, a(n)___________ contains a specific piece of information within a record?

Back 66

field

Front 67

What is the name of the field that is used as the unique identifier for each record?

Back 67

Primary key

Front 68

What is the term used to describe a collection of data organized in a manner that allows access, retrieval, and use of that data?

Back 68

database