Access

Question 1

Access

Answer 1

• Database management system (type of DBMS)

- Works with multiple files

Question 2

How are tables viewed?

Answer 2

Through the database view

Question 3

What are the 4 object types?

Answer 3

1) Queries: Complex, use query wizard, answers questions, a request for data results
2) Forms: Creates a user interface
3) Reports: Represents data
4) Tables: Update data

Question 4

Primary key

Answer 4

• Uniquely identifies the record

- Puts new numbers at top

Question 5

What do asterisks do?

Answer 5

• New line

- Will always have an asterisk

Question 6

Can I have a blank space in a data sheet on a table?

Answer 6

Yes

Question 7

Select(ion)

Answer 7

Selecting row of query

Question 8

Project(ion)

Answer 8

Selecting column of query

Question 9

Join

Answer 9

Joining two tables together

Question 10

What is the design view called?

Answer 10

Query by example (QBE)

Question 11

3 types of query views

Answer 11

1) Design view (can add condition <>=, Query by example QBE)
2) Database view (how tables are viewed)
3) SQL Structured Query Language

Question 12

look up table

Answer 12

Organizes numbers or texts into categories

Question 13

Which view shows the contents of a table as a data sheet?

Answer 13

Datasheet view

Question 14

True or false field values that may be entered into a field are determined by the data type of the field

Answer 14

True

Question 15

Which database object asks a question about the data stored in a database and displays specific fields and records that answer the question?

Answer 15

Query

Question 16

True or false information systems are broader in scope than information technologies

Answer 16

True