Loading Consent Dialog
RelationalDBDesign
SiteMap
Data Manipulation
Access Features
Building Database
Tables Queries
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Refining Queries
«Prev
Tables Queries Forms
Table Design Enhancement
Table Field Validation
Custom Validation Messages
Input Mask Mechanics
Access Lookup Fields
Data Typ Aadvantages
Refining Queries
Access Database Filters
Multiple Access Queries
Query Field Properties
Specifying Join Properties Queries
Total Queries in Access
Working With Crosstab Queries
Building Modifying Forms
Create Access Form
Add Format to Access Form
Insert Graphic onto Access Form
Access Form Properties
Changing Form Properties
Custom Form properties
Aligning Sizing Multiple Controls
Access Controls
Combo Box
Subform Control
Create Multipage Forms
Adding Chart to Form
Activex Controls
Calendar activex Control
Query join types - Quiz
Query join types, query types, and action queries
Each question is worth one point. Select the best answer or answers for each question.
1.
Which type of join would be used if you wanted to make sure only clients (Table 1) were displayed that had a project (Table 2) assigned to them?
Please select the best answer.
A.
Left outer join
B.
Inner join
C.
Right outer join
D.
Middle outer join
2.
Which type of query would you use to add new records to an existing table?
Please select the best answer.
A.
Make Table
B.
Delete
C.
Update
D.
Append
3.
Which action query does not destroy or alter existing information?
Please select the best answer.
A.
Make Table queries
B.
Delete queries
C.
Append queries
D.
Update queries
Correct answers:
Your Score: 0
Submit
Quiz Explanation