1. Question : (TCO 1) A collection of customer information and .homeworkminutes.com/answer/view/71589#”>purchase transactions that might be stored in both Access and Excel would be called a_____Student Answer: FieldRecordTableDatabase2. Question : (TCO1) Which statement is NOT true?Student Answer: A relationship is a connection between two tables using a common field.A primary key is used to identify uniquely each field in a table.Multiple users on different computers can work on a database simultaneously.Access speed measures the time it takes for a storage device to make the file content available for use.3. Question : (TCO 1) To create a filtered list on a particular field in a recordStudent Answer: click on the Home tab Advanced Filter and then Filter By Form.click on the Home tab Filter and then the Find option.click on the Home tab Selection and then pick your criteria.right click on an item in your Field column and then click Sort.4. Question : (TCO 1) To locate the tool to compact an Access database click on theStudent Answer: File tab Options Current Database and select Compact and Repair Database Tools.Home tab Advanced and select Compact and Repair Database Tools.Database Tools tab and select Compact and Repair Database Tools.External Data tab and select Compact and Repair Database Tools.5. Question : (TCO 1) Field names can be created or modified in which view?Student Answer: DatasheetDesignFormReport6. Question : (TCO 2) In using a web search engine typing the web site address in the proper place in the brower and then hitting enter is calledStudent Answer: server setup.presentation task.client browsing.systems application.7. Question : (TCO 2) How many data types does Access recognize?Student Answer: 579108. Question : (TCO 1) To display a subset of records based on certain criteria use which of the following?Student Answer: FilterFormReportTable1. Question : (TCO 2) To create a relationship between two tables you need at least aStudent Answer: data type.query.hyperlink.primary key.2. Question : (TCO 2) Which of the following does NOT describe a many-to-many relationship?Student Answer: There must be at least two tables.Many matching records exist in each direction between the tables.A junction table is used.You can connect to tables in other databases such as Oracle.3. Question : (TCO 2) Primary keys can be createdStudent Answer: as computer-generated fields.from an existing single field.from several existing fields.All of the above4. Question : (TCO 3) A relational table includes the following conditions EXCEPTStudent Answer: column entries and attributes must be the same data type.rows must be in order.cells contain a single data value.columns or attributes have a well defined range of values.5. Question : (TCO 3) Which of the following is true regarding the use of delimiters in a field criterion in Access?Student Answer: Date/Time data types need no delimiters.Date/Time data types need to be enclosed in single quotes.Number data types require no delimiters.Text data types require pound signs.6. Question : (TCO 3) The field property that ensures that the field is not empty isStudent Answer: Format.Required.Validation.Validation Rule.7. Question : (TCO 3) All of the following are true about a property EXCEPTStudent Answer: a Datasheet View is used to display properties.referenced as an attribute.changes can be made with a property sheet.tables forms queries and reports can have properties.8. Question : (TCO 4) Which of the following is NOT an example of a primary key?Student Answer: ISBN number for a textbookLast nameSocial Security NumberStudent ID9. Question : (TCO 4) To ensure that a value of 15 or greater was entered into a field you would use aStudent Answer: field size.field type.Sarbanes-Oxley Act.validation rule.10. Question : (TCO 2) Which of the following is a property that determines how much physical storage the field requires in the database?Student Answer: CaptionField SizeInput MaskValidation Rule1. Question : (TCO 2) Which of the following is an example of an entity in a business?Student Answer: CompanyBusiness ownerCEOEmployees2. Question : (TCO 2) Physical design refers toStudent Answer: developing a database model that will support company operations.purchasing your hardware components.selecting the specific hardware characteristics based on data storage and data access requirements.the process of converting your ERD into tables and defining your rows and columns based your entities and attributes.3. Question : (TCO 3) All of the following explain index usage EXCEPTStudent Answer: a primary field uses an index.adding an index to a table might decrease overall database performance slightly.an index can reduce the amount of time it takes for Access to run queries and reports.indexes are created using the Index property type.4. Question : (TCO 2) A crow’s footStudent Answer: is a Boolean field.is used to describe attributes.points to the child table.points to the parent table.5. Question : (TCO 2) The term cardinality refers toStudent Answer: a count of the total records in a table.a field which is a candidate for a primary key.the number of records in a relationship.the most important field in a table.6. Question : (TCO 2) A primary keyStudent Answer: can be computer generated.consists of one field only that uniquely identifies each record in a table.is a relationship between two or more tables.All of the above.7. Question : (TCO 3) Which does NOT apply to the following relationship image?Student Answer: A one-to-many relationship is shown between Orders and Order Details.The display is showing the Design View of relationships.Order Details has a composite primary key.Within the Orders Details table the ProductID field will contain unique values only.8. Question : (TCO 4) What Access data type would you use to store $23.58?Student Answer: CalculatedCurrencyMoneyNumber9. Question : (TCO 4) You can reserve space for a field using theStudent Answer: PNPI regulations.Sarbanes-Oxley Act.field size property.validation rule.10. Question : (TCO 4) Which question is part of a requirements analysis?Student Answer: What is the organization’s structure and core business?What are the existing problems with the current database?Will the database interface with other systems?All of the above.1. Question : (TCO 1) Entity attributes are represented asStudent Answer: fields.files.records.tables.2. Question : (TCO 2) All of the following are Access data types EXCEPTStudent Answer: autonumber.date/time.number.string.3. Question : (TCO 2) In Access query results are displayed in which view?Student Answer: datasheet.form.recordset.report.4. Question : (TCO 2) Which of the following is a naming convention for field names?Student Answer: autonumbercamelcaseprimary keyPPNI5. Question : (TCO 2) The command language used with relational databases isStudent Answer: PNPI.RDBMS.SQL.tuple.6. Question : (TCO 2) Another term for an expression isStudent Answer: formula.function.parameter.query.7. Question : (TCO 2) Validation textStudent Answer: changes the way text data is formatted.determines the maximum length of a text field.requires text data to be inputted correctly.specifies the error message when a rule is violated.8. Question : (TCO 2) Which of the following is NOT true of a birth date field?Student Answer: A process date is considered a constant.A process date would be defined as a date/time field.A process date would be defined as a calculated field.Date arithmetic can be applied to a process date field.9. Question : (TCO 6) An action query isStudent Answer: a select query used to warn users of database changes.always initiated by a user.an aggregate query used to summarize field data.used to add edit or delete data in a database.10. Question : (TCO 6) All of the following are true about a delete query EXCEPTStudent Answer: A delete query is an action query.Access will display a warning message before running the delete query.It can be created by clicking the Create tab Query Wizard and then select Delete Query.It selects records from a table and then removes them from the table.1. Question : (TCO 2) The process of checking the reliability of data is calledStudent Answer: data validation.input mask.primary key.validation rule.2. Question : (TCO 2) Validation text isStudent Answer: an error message that provides instruction on what to fix when an incorrect value is entered into a field.a list of predefined values that can be entered in a field.a comparison of values entered in two fields.a field that requires a value of characters or text only.3. Question : (TCO 2) A logical data validation method is a(n)Student Answer: birth date field that cannot exceed a hire date.entered number less than 100 will not display.field left blank will display with a default of zero.social security number entered as 111223333 is displayed as 111-22-3333.4. Question : (TCO 2) To reduce problems that may occur in generating queries and reports you could place lookup values into aStudent Answer: data type.field.list.table.5. Question : (TCO 2) An input mask placed on a form will apply toStudent Answer: all forms based on that table.all forms in the database.all forms based on that table and the table itself.that specific form only.6. Question : (TCO 5) All of the following are performed in the design view of a form EXCEPTStudent Answer: adding pictures lines calculations and controls.changing the size of the form sections.entering a data value.modifying the properties of a form.7. Question : (TCO 5) A bound controlStudent Answer: is a textbox that is connected to a field in a query or a table.contains a formula that displays the result.is used to display aggregate information.uses a macro to process field information.8. Question : (TCO 5) All of the following are form creation tools EXCEPTStudent Answer: blank form.form design.form layout.form wizard.9. Question : (TCO 5) Aggregate reportsStudent Answer: are most effective when run again on one table.are useful for detecting data entry errors.can performing complex “what if” analyses.require a macro in order to be effective.10. Question : (TCO 5) A data macroStudent Answer: executes a series of actions when a table event occurs or whenever a named macro is executed.identifies fields to compare.is a switchboard.is a table event.1. Question : (TCO 1) The easiest way to create a report is to use the following report tool.Student Answer: Blank ReportReportReport DesignReport Wizard2. Question : (TCO 1) All of the following are report sections EXCEPTStudent Answer: detail.group footer.page footer.summary.3. Question : (TCO 1) A detail lineStudent Answer: prints more detailed information on one record only.provides additional field information on a record.repeats for each record in the record source.All of the above4. Question : (TCO 1) A tabular layout resembles aStudent Answer: form that you fill out.spreadsheet.group of index cards.All of the above5. Question : (TCO 1) Grouping data in a report willStudent Answer: provide grand totals for your report.let you organize and summarize your data.make a report more attractive.allow you to edit data in a record.6. Question : (TCO 1) Column headings in a report are based onStudent Answer: the captions used in the source table or query.the text controls you place in a report.group labels.report labels.7. Question : (TCO 7) In addition to the detail field the primary drop zone in a PivotTable design grid is theStudent Answer: column field.filter field.row field.All of the above8. Question : (TCO 7) Data mining refers toStudent Answer: analyzing volumes of data to identify trends and patterns.conducting what if analyses.analyzing minute differences in field data.the least squares regression technique to forecast data trends.9. Question : (TCO 7) A scatter chart is used to displayStudent Answer: continuous data.discrete data.percentages of a whole.vertically stacked data.10. Question : (TCO 7) All of the following are Aggregate Functions EXCEPTStudent Answer: average.count.select.sum.
