Deck 5: Extensions B: Introduction to Microsoft Excel

Question 1

The description in the table design window is used for __________.

A)documentation
B)additional data type information
C)additional field name information
D)formatting fields
E)setting properties

Answer 1

documentation

Question 2

In Access,entities are called __________.

A)fields
B)rows
C)queries
D)columns
E)tables

Answer 2

tables

Question 3

__________are used by the user to enter data in to an Access database.

A)Reports
B)Forms
C)Modules
D)Queries
E)Tables

Answer 3

Forms

Question 4

The properties of each field are set at the__________ of the table design window.

A)bottom
B)top
C)centre
D)left
E)right

Question 5

Access' graphical query interface translates statements into ___________

A)ASP
B)SQL
C)query
D)C++
E)VBA

Question 6

The second column at the top of the table design window contains the__________ of the field.

A)data type
B)field name
C)field size
D)description
E)properties

Question 7

In MS Access, __________ is a term that refers to the attributes that are described in the data model.

A)application
B)table
C)data
D)key
E)field

Question 8

In interviewing users the database designer needs to make sure they include the __________ that users are making.

A)movements
B)assumptions
C)data
D)noise
E)steps

Question 9

The red__________ icon is used to run queries.

A)(+)
B)(!)
C)(:)
D)(?)
E)(=)

Question 10

You build the links between tables using the___________window.

A)relationships
B)mapping
C)database relationships
D)relationship wizard
E)database diagram

Question 11

When defining a relationship between two tables in Access,it is important to be sure to drag the correct__________ in the right direction and lay it on the other table.

A)key
B)attribute
C)relationship
D)table
E)window

Question 12

__________ ask questions about the data.

A)Modules
B)Forms
C)Tables
D)Reports
E)Queries

Question 13

When creating a new table in Access,the primary key is set by clicking on the__________ icon.

A)drive
B)relationship
C)exclamation mark
D)key
E)switch

Question 14

The key icon can be found in the__________ tab ribbon.

A)Datasheet
B)Home
C)Design
D)Database Tools
E)Create

Question 15

When designing a database the designer must recognize the __________involved in the business process.

A)value
B)value added
C)ambiguity
D)data
E)problems

Question 16

In a query of two or more tables Access will will show

A)only records in the parent table
B)every record in one table joined to each record in the other table.
C)only records the have matching values in all the tables.
D)only records that do not have matching records in all the tables.
E)all the relevant records in both/all tables.

Question 17

When you create a new table Access automatically creates an ID field with a(n)__________data type.

A)date
B)text
C)hyperlink
D)number
E)autonumber

Question 18

When creating relationship you should also select__________in the relationships dialog box.

A)cascade delete related fields
B)cascade update related fields
C)enforce referential integrity
D)B and C only
E)A,B and C only

Question 19

__________are used to summarize data on paper.

A)Queries
B)Forms
C)Reports
D)Modules
E)Tables

Question 20

A question one asks of the database is known as a(n)

A)query.
B)form.
C)table.
D)report.
E)result.

Question 21

Access provides a graphical________for creating queries.

Question 22

A subform allows multiple records to be displayed that are related to the record displayed in the main form.

Question 23

MS Access makes it easy to generate database queries by providing an easy -to -use __________that generates SQL statements automatically.

Question 24

Database forms allow the users to view,add,update or__________data in the underlying tables.

Question 25

Access provides a graphical user interface for creating database queries.

Question 26

To create a data entry form in Access,you can use the default table display or you can use the form __________.

Question 27

To create a report form two tables you can use the __________.

Question 28

In a form you can_______over any data you wish to change

Question 29

Forms allow a user to view and maintain the __________ in a database.

Question 30

A quick way of creating reports in Access is to use the Report Wizard.

Question 31

Forms allow users to view and maintain data in a database.

Question 32

In MS Access,the __________ data type is used to generate a unique primary key.

A)integer
B)text
C)autonumber
D)currency
E)number

Question 33

In database terms,a(n)__________ is the same thing as a question that one asks of the database.

Question 34

Relationships are created by clicking on the primary key in one table and dragging it to the related field in another table.

Question 35

In order to execute a query in MS Access,create the query and then click on the__________ icon.

Question 36

Queries in Access are translated into __________ by the query graphical interface.

Question 37

Relationships can be assigned using the Relationships tool that is found on the Database Tools tab of the ribbon.

Question 38

Access does not allow users to create queries in SQL.

Question 39

The most common data type for fields in tables is always the "number" data type.

Question 40

The Relationships window allows users to define the relationships between tables.

Question 41

Before creating a database in Access,you should develop a data model based on the user requirements.

Question 42

Access allows users to create tables in a design view.

Question 43

Data entry forms in Access are used to generate reports.

Question 44

Why are queries so useful and how are they created in MS Access?

Question 45

What are reports used for ad how are they created in MS Access?

Question 46

A data entry form in Access can be created using the Form tool in the Create tab ribbon.

Question 47

A primary key is indicated by a small key icon next to the field name in the design mode of the table.

Question 48

What are data entry forms used for and how are they created in MS Access?

Question 49

In the table design mode in Access the field and data type are required to create an attribute.