FINAL EXAM - Summer 2010 - Question 1 1. In a database,...

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon
Question 1 1. In a database, what are the basic parts that allow people to work with it? Answer Access database objects Queries Reports Forms 1 points Question 2 1. Which of the following is a database object Answer
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
DBMS Input device Query Sheet 1 points Question 3 1. Which database object is designed to display a subset of the data from one or more tables? Answer Form Table Report Query 1 points Question 4
Background image of page 2
1. A data field formatted as a text data type can store up to ______ characters. Answer 128 1024 255 512 1 points Question 5 1. The Find and Replace dialog box allows the person using Access to ____________. Answer
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
create a new database delete existing data create new data find text 1 points Question 6 1. A properly structured database ensures which of the following? Answer Mixed records accuracy and integrity redundancy Inefficiency 1 points Question 7
Background image of page 4
1. A(n) _____________ ___ is used to create a relationship to another table. Answer foreign key Primary key connection link 1 points Question 8 1. A relational database joins tables using a _____________ _______ . Answer joined
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
link relationship connection 1 points Question 9 1. Which type of relationship is the most common relationship in a database? Answer Many-to-many relationship One-to-one relationship One-to-many relationship One-to-all relationship 1 points Question 10 1.
Background image of page 6
A one-to-many relationship is where one record in the first table corresponds to _________ records in the second table. Answer zero man y one two 1 points Question 11 1. To quickly add fields to a new select query, use the ______ Query Wizard. Answer
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Find Duplicates Crosstab Find Unmatched Simple 1 points Question 12 1. Which of the following operators are used by numeric criteria to compare two values? Answer Comparison Equivalency Similarity Adjustment 1 points
Background image of page 8
Question 13 1. The _____________ ____ is a fast and intuitive tool for building reports Answer Report Builder Expression Builder Report Wizard Data Reporter 1 points Question 14 1. When viewing a report in Report view, the Detail section displays which of the following?
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Answer Column labels Headers Titles Actual data 1 points Question 15 1. Which type of query calculates a sum, average, or similar statistic and then groups the results by two sets of values Answer Pass through Crosstab Update Parameter
Background image of page 10
1 points Question 16 1. When EXCEL
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/16/2011 for the course ITE 115 taught by Professor Rynn during the Spring '10 term at Northern Virginia Community College.

Page1 / 39

FINAL EXAM - Summer 2010 - Question 1 1. In a database,...

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online