Question 1

Match between columns
                        Premises: macro
query
form
module
report

Accepted Answer

The Answer of object that allows you to enter data is...

Question 2

Match between columns
                        Premises: foreign key
comparison operator
criterion
normalization
filter

Accepted Answer

The Answer of number,text phrase,or expression used to select records is...

Question 3

Which of the following is FALSE about the Undo feature in Access?

Accepted Answer

A)  You can click Undo to reverse the most recent change to a single record. 
B)  You can use Undo to reverse multiple edits in Access. 
C)  In Access, the Undo feature works the same as it does in other Office programs. 
D)  You can click Undo to redo a change that you made previously. 
A)  You can click Undo to reverse the most recent change to a single record. 
B)  You can use Undo to reverse multiple edits in Access. 
C)  In Access, the Undo feature works the same as it does in other Office programs. 
D)  You can click Undo to redo a change that you made previously. B

Question 4

What is a foreign key? Provide an example.

Accepted Answer

A foreign key is a field in one table th

Question 5

A(n)________ is a number,phrase,or expression used to select records from a table.

Accepted Answer

The answer of A(n)________ is a number,phrase,or expression used to...

Question 6

A ________ is a question you ask about data stored in a database.

Accepted Answer

A)  query 
B)  form 
C)  report 
D)  macro 
A)  query 
B)  form 
C)  report 
D)  macro

Question 7

Which of the following best describes information?

Accepted Answer

A)  Information is a converted into fields and records within a table in a database. 
B)  Information is converted into data that can be selected and sorted for business or personal use. 
C)  Information is what is entered into a database. 
D)  Information is the finished product that is produced by a database. 
A)  Information is a converted into fields and records within a table in a database. 
B)  Information is converted into data that can be selected and sorted for business or personal use. 
C)  Information is what is entered into a database. 
D)  Information is the finished product that is produced by a database.

Question 8

Good database design begins with grouping data into correct tables,a practice known as ________.

Accepted Answer

The answer of Good database design begins with grouping data...

Question 9

A primary key:

Accepted Answer

A)  must include letters. 
B)  must contain a unique value for each record within a table. 
C)  has the same value for all records in a relational database. 
D)  is a unique record within a relational database. 
A)  must include letters. 
B)  must contain a unique value for each record within a table. 
C)  has the same value for all records in a relational database. 
D)  is a unique record within a relational database.

Question 10

Match between columns
                        Premises: XPS file
Access Web app
SharePoint
Office 365
Access

Accepted Answer

The Answer of Web app platform developed by Microsoft and is...

Question 11

Explain a query in Access.Provide an example.

Accepted Answer

A query is a question that you

Question 12

Both Access and Excel contain tools that can be used to extract and analyze information.

Accepted Answer

A) True 
 B)False

Question 13

Match between columns
                        Premises: object
database
table
record
field

Accepted Answer

The Answer of an object in which data is stored is...

Question 14

Filter by Form uses the AND and OR logical operators.

Accepted Answer

A) True 
 B)False

Question 15

A(n)________ is a collection of organized and meaningful data that can be accessed,managed,stored,queried,sorted,and reported.

Accepted Answer

The answer of A(n)________ is a collection of organized and...

Question 16

A sort can only list records in a database in a specific numeric sequence.

Accepted Answer

A) True 
 B)False

Question 17

Access is known as a(n)________ system because it allows users to administer groups of data in tables and create relationships.

Accepted Answer

relational

Question 18

An Access database can MOST accurately be described as a structured collection of:

Accepted Answer

A)  tables. 
B)  objects. 
C)  records. 
D)  modules. 
A)  tables. 
B)  objects. 
C)  records. 
D)  modules.

Question 19

Relationships in a database can be graphically represented by the ________ between the tables.

Accepted Answer

The answer of Relationships in a database can be graphically...

Question 20

Match between columns
                        Premises: RDBMS
Web app
DBMS
VBA
Access

Accepted Answer

The Answer of application platform by Microsoft and database management is...

Which of the following is FALSE about the Undo feature in Access?

What is a foreign key? Provide an example.

A(n)________ is a number,phrase,or expression used to select records from a table.

A ________ is a question you ask about data stored in a database.

Which of the following best describes information?

Good database design begins with grouping data into correct tables,a practice known as ________.

A primary key:

Explain a query in Access.Provide an example.

Both Access and Excel contain tools that can be used to extract and analyze information.

Filter by Form uses the AND and OR logical operators.

A(n)________ is a collection of organized and meaningful data that can be accessed,managed,stored,queried,sorted,and reported.

A sort can only list records in a database in a specific numeric sequence.

Access is known as a(n)________ system because it allows users to administer groups of data in tables and create relationships.

An Access database can MOST accurately be described as a structured collection of:

Relationships in a database can be graphically represented by the ________ between the tables.

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and SQL in Access: Advanced Techniques

Filters

Exam 11: Introduction to Access: Finding Your Way Through an Access Database

Which of the following is FALSE about the Undo feature in Access?

What is a foreign key? Provide an example.

A(n)________ is a number,phrase,or expression used to select records from a table.

A ________ is a question you ask about data stored in a database.

Which of the following best describes information?

Good database design begins with grouping data into correct tables,a practice known as ________.

A primary key:

Explain a query in Access.Provide an example.

Both Access and Excel contain tools that can be used to extract and analyze information.

Filter by Form uses the AND and OR logical operators.

A(n)________ is a collection of organized and meaningful data that can be accessed,managed,stored,queried,sorted,and reported.

A sort can only list records in a database in a specific numeric sequence.

Access is known as a(n)________ system because it allows users to administer groups of data in tables and create relationships.

An Access database can MOST accurately be described as a structured collection of:

Relationships in a database can be graphically represented by the ________ between the tables.

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and SQL in Access: Advanced Techniques

Filters