Question 1

A report can be saved as a PDF file so users without Access can view it.

Accepted Answer

A) True 
 B)False  True

Question 2

Which of the following is NOT a report view?

Accepted Answer

A)  Report 
B)  Design 
C)  Layout 
D)  Print 
A)  Report 
B)  Design 
C)  Layout 
D)  Print D

Question 3

When Access creates a form with two record sources having a one-to-many relationship,the one record source is displayed in the main form and the many record source is display in a ________.

Accepted Answer

A)  subform 
B)  report 
C)  query 
D)  register 
A)  subform 
B)  report 
C)  query 
D)  register A

Question 4

Which of the following is NOT a form view?

Accepted Answer

A)  Form 
B)  Edit 
C)  Layout 
D)  Design 
A)  Form 
B)  Edit 
C)  Layout 
D)  Design

Question 5

When Access creates a form with two related record sources,the main form is displayed with a stacked layout,while the subform with a datasheet layout.

Accepted Answer

A) True 
 B)False

Question 6

You can sort the data in a form by double-clicking a field and selecting Sort A to Z or Sort Z to A.

Accepted Answer

A) True 
 B)False

Question 7

Changes to data in a form are made in design view.

Accepted Answer

A) True 
 B)False

Question 8

Which database object is used to add data into or edit data in a table?

Accepted Answer

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

Question 9

Pmt is an example of a(n)________.

Accepted Answer

A)  parameter 
B)  function 
C)  argument 
D)  subroutine 
A)  parameter 
B)  function 
C)  argument 
D)  subroutine

Question 10

The results of PricePerRoom: [ListPrice]/([Beds]+[Baths]+3)will appear in a column with the heading ________.

Accepted Answer

A)  PricePerRoom 
B)  ListPrice 
C)  Beds 
D)  Baths 
A)  PricePerRoom 
B)  ListPrice 
C)  Beds 
D)  Baths

A report can be saved as a PDF file so users without Access can view it.

Which of the following is NOT a report view?

When Access creates a form with two record sources having a one-to-many relationship,the one record source is displayed in the main form and the many record source is display in a ________.

Which of the following is NOT a form view?

When Access creates a form with two related record sources,the main form is displayed with a stacked layout,while the subform with a datasheet layout.

You can sort the data in a form by double-clicking a field and selecting Sort A to Z or Sort Z to A.

Changes to data in a form are made in design view.

Which database object is used to add data into or edit data in a table?

Pmt is an example of a(n)________.

The results of PricePerRoom: [ListPrice]/([Beds]+[Baths]+3)will appear in a column with the heading ________.

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

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

Introduction to Access: Finding Your Way Through an Access Database

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 4: Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

A report can be saved as a PDF file so users without Access can view it.

Which of the following is NOT a report view?

When Access creates a form with two record sources having a one-to-many relationship,the one record source is displayed in the main form and the many record source is display in a ________.

Which of the following is NOT a form view?

When Access creates a form with two related record sources,the main form is displayed with a stacked layout,while the subform with a datasheet layout.

You can sort the data in a form by double-clicking a field and selecting Sort A to Z or Sort Z to A.

Changes to data in a form are made in design view.

Which database object is used to add data into or edit data in a table?

Pmt is an example of a(n)________.

The results of PricePerRoom: [ListPrice]/([Beds]+[Baths]+3)will appear in a column with the heading ________.

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

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

Introduction to Access: Finding Your Way Through an Access Database

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