Week 11 Flashcards
(30 cards)
Which type of query is a query that adds, changes, or deletes multiple table records at one time?
Action Queries
In which type of query do you choose the fields and records you want to change by entering the selection criteria and the update rules?
Update
List the various types of action queries?
Update
Append
Make Table
Delete
What is a make-table query? Explain.
Creates a whole new table
Which type of table contains data that is no longer needed for current processing but that you might need to reference in the future?
History Table
Delete queries are often run after ____ queries have added those same records to history tables.
Append
What type of query changes selected fields and records in one or more tables?
Update
How do you choose the records you want to delete when using a delete query?
Create query –> selected the records and run the query. After its run, then select the delete option.
Which type of query adds records from an existing table or query to the end of another table?
Append
Which type of query creates a new table from one or more existing tables?
Make Table
What type of query would you use to increase the salaries of selected employee groups by a specified percentage?
Update: Update to:
You need to combine the information from a table containing customers in city A with a table containing customers in city B in a customer database. What type of query should you use?
Append
Which file type contains format specifications for a table that may be exported from a database as
an XML document?
XSD - XML Strucutred Definition
What properties are preserved in the new table when you use a make-table query?
data type and field size
no primary key or field properties such as look up fields
ut the following steps for creating a delete query in the proper order:
a. Create a select query with the necessary fields and selection criteria.
b. Switch to Design view to make any necessary changes.
c. When the query is correct, click the Delete button in the Query Type group on the Design tab. Access replaces the Show and Sort rows in the design grid with the Delete row.
d. Click the Run button.
e. In the Results group on the Design tab on the Ribbon, click the Run button to preview the results.
f. Click the Yes button to confirm deleting the records.
a. Create a select query with the necessary fields and selection criteria.
d. Click the Run button.
b. Switch to Design view to make any necessary changes.
e. In the Results group on the Design tab on the Ribbon, click the Run button to preview theresults.
c. When the query is correct, click the Delete button in the Query Type group on the Design tab. Access replaces the Show and Sort rows in the design grid with the Delete row.
f. Click the Yes button to confirm deleting the records.
What is the abbreviation for a one-to-many relationship?
1:M
Provide a complete definition for a one-to-many relationship.
Primary has one record, that record in the related table has many records.
What is the abbreviation for a many-to-many relationship?
M:N
What type of relationship would exist in a Database of careers with a table of Jobs offered to students by employers and the Student table which contains one record for each student?
One to many
Which type of relationship requires you to create a third table and form one-to-many relationships between the two original primary tables and the new related table?
One to many
What would be the name of the third table in the question above?
Relationship Table
List four types of tables that can be found in a relational database.
Relationship Table
1:1
1:M
M:N
What is the most common type of relationship in a database?
1:1
What is the proper name for an entity in a one-to-one relationship?
Entity Subtype
