Show Recommended textbook solutions
Ways of the World: A Global History3rd EditionRobert W. Strayer 232 solutions Tonal Harmony, Workbook8th EditionByron Almen, Dorothy Payne, Stefan Kostka 1,387 solutions America's History for the AP Course8th EditionEric Hinderaker, James A. Henretta, Rebecca Edwards, Robert O. Self 470 solutions
America's History for the AP Course9th EditionEric Hinderaker, James A. Henretta, Rebecca Edwards, Robert O. Self 961 solutions Recommended textbook solutionsIntroduction to Algorithms3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen 726 solutions
Data Structures and Algorithms in Java6th EditionMichael H Goldwasser, Michael T Goodrich, Roberto Tamassia 566 solutions
Starting Out with Python2nd EditionTony Gaddis 601 solutions C++ Programming8th EditionD. S. Malik 486 solutions Upgrade to remove ads Only ₩37,125/year
Terms in this set (80)In a database, data is stored in a ________. Answer: C You can use a database ________ to ask a question of the data. Answer: D The ________ view of a table displays the data stored in the table. Answer: B Each column in an Access table is called a(n) ________. Answer: B The Navigation Pane is located
on the ________ when Access is opened. Answer: D A ________ helps create objects using a step-by-step process. Answer: D The ________ view shows the query's structure. Answer: D If no sort criteria are specified when creating a query, Access will sort the results by the ________. Answer: D Reports have ________ views.
Answer: C ________ an Access database rearranges objects so disk space is used more efficiently. Answer: C True or False? Data is an important asset to any organization after it is converted to information. Answer: TRUE
True or False? Data is always stored in a form. Answer: FALSE True or False? A report allows you to enter, edit, and delete data. Answer: FALSE True or False? The data contents within a table can be seen in Design view. Answer: FALSE True or False? Relationships are links between the tables. Answer: TRUE True or False? A record is all of the data pertaining to one person, place, thing, or event. Answer: TRUE True or False? If you want to insert data from another file into an Access database, you must use copy and Answer: FALSE True or False? Backing up a database will help protect you against any mishaps with the original database such as accidental loss of data. Answer: TRUE True or False? A form pulls records from a table in an easy-to-read format suitable for printing. Answer: FALSE True or False? A column in an Access table is called a characteristic. Answer: FALSE A phone number is an example of a(n) ________. Answer: A Which of the following is NOT true regarding compound fields? Answer: D Tables have ________ view(s). Answer: A The ________ in a table dictates what
data can be stored in a field. Answer: A Data can be entered into a database using one of two methods: entering the data directly into the table or entering it in ________. Answer: C Which
of the following is NOT true about undoing in Access? Answer: B In
a database, a(n) ________ is a field that uniquely identifies a record. Answer: C In a customer table, a(n) ________ field would serve as a good primary key. Answer: B The ________ data
type generates the value by automatically incrementing the value for each new record to produce unique keys. Answer: D Being able to format a phone number in a field as (412) 555-8676 without manually entering the symbols occurs when a(n) ________ has been applied to the field. Answer: C The ________ key in one table acts as a primary key of another table. Answer: D When two fields are needed to uniquely identify a record, a ________ key is used. Answer: C If one student in tblStudents can register for many classes in tblClasses, the relationship would be noted as a ________ relationship. Answer: C When a database is ________, redundancy is minimized. Answer: B True or False? The Undo button will permit a user to undo up to 100 changes. Answer: FALSE True or False? A person's phone number would serve as a good primary key. Answer: FALSE True or False? The size of a field can be changed in a table's Design view. Answer: TRUE True or False? When you have a one-to-one relationship, you could combine the two tables into a single table. Answer: TRUE True or False? The process of normalization causes multiple smaller tables to be created. Answer: TRUE True or False? Relationships between tables must be based on common fields. Answer: TRUE The ________ allows you to move to the top and bottom of a table or scroll to a specific Answer: B A ________
is used as a placeholder for an unknown part of a value or to match a certain pattern in a value. Answer: A To search for a word that begins with "ar" you would enter ________. Answer: D Which
of the following is NOT true about applying filters to a datasheet? Answer: A A ________ query is used when you want to find records with the same specific value. Answer: A Which of the following is NOT true about the Find Unmatched query wizard? Answer: B ________ perform arithmetic operations, such as calculating averages and totals, on records displayed in a table or query. Answer: A Calculated query fields must be formatted in the query design
grid using the ________. Answer: C ________ is a tool in Access that can help you format your calculated fields correctly. Answer: B In a query, if you
wanted to display the number of records retrieved, you would use the ________ aggregate function. Answer: A True or False? Datasheets are used to view all records in a table at one time. Answer: TRUE True or False? In Datasheet view, you can use the Replace command to quickly locate specific records using all or part of a field value. Answer: FALSE True or False? To search for a three-letter word that starts with "t" and ends with "p" you would enter t!p. Answer: FALSE True or False? A filter is a condition you apply temporarily to a table or query Answer: TRUE True or False? In addition to the Simple Query Wizard, there are three additional query wizards available to make quick, step-by-step queries. Answer: TRUE True or False? Comparison operators compare the values in a table or another query to the criteria value you set up in a query. Answer: TRUE True or False? An aggregate function can be used in Datasheet view by adding a total row to a table. Answer: TRUE True or False? When using the Find Duplicates Query Wizard, you select the fields that you think may include duplicate information, and the wizard creates the query to find records matching your criteria. Answer: TRUE True or False? The Simple Query Wizard provides the opportunity to select data criteria Answer: FALSE True or False? To search for a word that starts with "ar" you would enter ar*. Answer: TRUE When you create a form from two tables that have a one-to-many relationship, the first table selected
becomes the main form and the second table you select becomes the ________. Answer: D A(n) ________ control is a control whose data source is a field in the table such as the customer name. Answer: B A
________ control may be the name of the field or some other text you manually enter. Answer: A Which of the following is NOT true about multiple-table forms? Answer: D Which of the following is NOT true about creating a report using the Report Wizard? Answer: A A report can be created from all of the following EXCEPT: Answer: B ________ allows you to modify the report while seeing the data. Answer: A ________ allows the specification of rules that apply formatting to cells or specific controls, as determined by the rule outcome. Answer: B To calculate totals for smaller groups of records, use ________. Answer: B When the Report Wizard has finished creating the report, it shows you the report in ________. Answer: B True or False? Datasheet view shows all the fields and records at one time, which provides all the information you need to update your data, unlike in a form or query, where some of the fields or records may not be in view. Answer: TRUE True or False? Design view shows all the records and fields at one time, which is one advantage to using it to update your records. Answer: FALSE True or False? When you create a form from two tables that have a one-to-many relationship, the first table selected becomes the subform and the second table you select becomes the main form. Answer: FALSE True or False? A form with a subform allows you to see one record at a time from the main form and multiple records in Datasheet view from the other related table. Answer: TRUE True or False? A split form is a form created from one table, but it has a Form view and a Datasheet view in the same window. Answer: TRUE True or False? When you enter data in a form, it is stored in the form and not the table. Answer: FALSE True or False? Form view is only for viewing data, so to make any changes to the form you need to switch to either Print Preview or Design view. Answer: FALSE True or False? A theme is a built-in combination of colors and fonts. Answer: TRUE True or False? Before you can use two tables in a form, you must make sure there is a one-to-one relationship between the tables. Answer: FALSE True or False? A text box control represents the actual value of a field and is an unbound control. Answer: FALSE Students also viewedAccess Module 1,2,3, and Test112 terms Liz-S Access Chapter 485 terms tracy_scott8 Access I40 terms Angel_Hernandez691Plus Access exam150 terms DGV296 Sets found in the same folderAccess Module 1,2,3, and Test112 terms Liz-S Java Programming: Chapter 182 terms tlamatqui BCAP 1200 Microsoftword130 terms alyssa_patuel7 Microsoft Excel Terminology68 terms wendypisciotta Other sets by this creatorBusiness Last Test29 terms Sabrina_Otterbein4 BLUES MUSIC34 terms Sabrina_Otterbein4 Music Final Test6 terms Sabrina_Otterbein4 music short answers test 26 terms Sabrina_Otterbein4 Verified questions
computer science Recall, in our discussion of the Church–Turing thesis, that we introduced the language $D=\{\langle p\rangle | p$ is a polynomial in several variables having an integral root}. We stated, but didn’t prove, that D is undecidable. In this problem, you are to prove a different property of D-namely, that D is NP-hard. A problem is NP-hard if all problems in NP are polynomial time reducible to it, even though it may not be in NP itself. So you must show that all problems in NP are polynomial time reducible to D. Verified answer
computer science It is often desirable to keep all elements of a doubly linked list compact in storage, using, for example, the first m index locations in the multiple-array representation. (This is the case in a paged, virtual-memory computing environment.) Explain how to implement the procedures ALLOCATE-OBJECT and FREE-OBJECT so that the representation is compact. Assume that there are no pointers to elements of the linked list outside the list itself. (Hint: Use the array implementation of a stack.) Verified answer computer science True/False. Parameters to methods may only be primitive types. Verified answer computer science Suppose that a scheduling algorithm (at the level of short-term CPU scheduling) favors those processes that have used the least processor time in the recent past. Why will this algorithm favor I/O-bound programs and yet not permanently starve CPU-bound programs? Verified answer Recommended textbook solutionsIntroduction to Algorithms3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen 726 solutions Information Technology Project Management: Providing Measurable Organizational Value5th EditionJack T. Marchewka 346 solutions Service Management: Operations, Strategy, and Information Technology7th EditionJames Fitzsimmons, Mona Fitzsimmons 103 solutions
Starting Out with Python4th EditionTony Gaddis 629 solutions Other Quizlet setspsc 100 final exam: lesson 729 terms kellysilva710 Quiz 2 (book info)68 terms maddiebond Cardiology Test 470 terms kaibanks Fill in the blank Communication Disorders27 terms kenzz_xoxo Which Access object Cannot be used to enter or edit data quizlet?unbound controls such as labels and lines do not have a tab stop property because they cannot be used to enter or edit data.
Which of the following is used to locate data in a database?Indexes are used to quickly locate data without having to search every row in a database table every time a database table is accessed.
Which of the following is a collection of related data fields?A collection of related data is called Database. A database is a data structure that stores organized information.
Which of the following options is used to add a new record in Access?To add a new record:
There are three ways to add a new record to a table: In the Records group on the Home tab, click the New command. On the Record Navigation bar at the bottom of the window, click the New record button. Begin typing in the row below your last added record.
|