Show Recommended textbook solutions
Fundamentals of Database Systems7th EditionRamez Elmasri, Shamkant B. Navathe 687 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
Service Management: Operations, Strategy, and Information Technology7th EditionJames Fitzsimmons, Mona Fitzsimmons 103 solutions Upgrade to remove ads Only A$47.99/year
Terms in this set (48)Description The _______ property allows the database designer to explain the purpose of a field or how a field is used. Common A field used to connect one table logically with another table called a _______ field. Field Properties A database system determines how to store, display, and process field values bases on which of the following. that describes the purpose or contents of the field or object so that later you can easily remember what the name represents. When choosing field names. it is best to choose names that ________. Date/Time Which data type would be the best logical data type for a field names PaidDate? M/DD/YY Which symbols would be used to create a custom date formate that would display July 4, 2016 as 7/04/16. Yes/No Which data type would be most logical to use for a field names BillPaid to indicate if an invoice has been paid? Structure Changing the order of fields in a database table is an example of changing a table's _________. Values Formatting Date/Time fields changes only the way data is displayed, not the field _______.
Foreign Key The common field between two tables in the Relationships window is indicated by a ____________. If the underlying field names in the access table DO NOT MATCH the excel worksheet column headings exactly. Which of the following would be a likely reason that an Import process from an Excel spreadsheet to an Access database might fail? Delimited It is important that data being imported from a text file into Access are separated by a character, such as a comma, which defines the text file as a ________ text file. One-To-Many A relationship between Access tables that is a relationship between one record in the first table and zero, one, or many records in the second table, and at least one record in the second table matches at most one record in the first table, is defined as a ______ relationship. Run Results of a query may be viewed at any time by clicking the ______ button in the Results group on the ribbon. Query by Example (QBE) The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of example? Maintaining The process of adding, modifying and deleting records in a database to keep the records current and accurate is referred is referred to as _______ a database. Shift+Space Which keyboard shortcut selects the first field value in the first record when in Navigation Mode? Hide Fields The _________ command removes the display of one or more fields in Data sheet view. Multiple A query based on more than one table is a ______ query. Common Queries based on more than one table, must have a _______ field. Report Data may be sorted in a table data sheet, a form, and a ________. Unique When the sort field data for each record in a database is different, the sort field is _________. Left Most In a query, Access sorts fields first based on the sort field that is ______ in the design grid of the Query window when in Design view. Condition A criterion, or rule, that determines which records are selected when a query is run is called a ________. On or before 1/1/1997 Based on the criterion for the BirthDate field "on or before 1/1/1997", the query will return all patients with a birth date ________. Aggregate Functions Statistical information such as totals and averages is calculated using _________. Form Data in a form may only be modified in _______ view. One-To-Many A form created from two tables that have a ______ relationship creates a main form and a subform. ... Which Access database object is best to use for basis of a report when specific criteria must be applied to the resort? Single Record It is often easier to maintain data in a data sheet using a form because all changes for a _____ are the focus at one time. Record Each row in an Access table data sheet displays which of the following? Field Each column in an Access table data sheet represents a ________. Field View The specific content of a field is referred to as the _________. Common Field Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables? It uniquely identifies each record in the table What is the purpose of the primary key? Data Base Data organized as a collection of tables creates this type of data system. Field Selector Another term used for the column selector feature is ________. Best Fit Which of the following terms describes the Access feature that allows a user to size a column in data sheet view so that the column is just wide enough to display the longest visible value in the column. Star Symbol Which Ribbon group and button would be used to create a new record in an Access database table? Table Which of the following is an Access 2013 database object? Form Which Access database objects might be used to enter, edit, and view records in a database? Query Which Access Database object asks a question about the data stored in a database and displays specific fields and records that answer the question? Layout view Which view is used to make design changes to a form while the form is displaying data? Repairing the database Which function does compacting an Access database perform other than reducing the file size? Programming Task Experienced database developers avoid using spaces in field names and object names because names with spaces might cause errors if the objects are involves in ________. Short Text Which data type allows field values to contain letters, digits, and other characters? Tab / Enter Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in data sheet view when entering data? Clipboard When copying and pasting records from one table to another, the records must first be copied to the _______. Students also viewedCIT105- ACCESS Quiz 337 terms AccessTutorial 243 terms CIT105-ACCESS Quiz 229 terms BCIS: Access Module 316 terms Sets found in the same folderCGS 210048 terms Study Guide Test 2 comp class45 terms CGS Test 348 terms CGS Test review 532 terms Other sets by this creatorPGA PGM Qualifying Test157 terms PEO 2624 Exam 229 terms BSC1005L FINAL FSU195 terms Cases9 terms Recommended textbook solutionsInformation Technology Project Management: Providing Measurable Organizational Value5th EditionJack T. Marchewka 346 solutions
Fundamentals of Database Systems7th EditionRamez Elmasri, Shamkant B. Navathe 687 solutions
Service Management: Operations, Strategy, and Information Technology7th EditionJames Fitzsimmons, Mona Fitzsimmons 103 solutions
Computer Organization and Design MIPS Edition: The Hardware/Software Interface5th EditionDavid A. Patterson, John L. Hennessy 220 solutions Other Quizlet setsChapter 1032 terms Reforming American Society/ Abolition and women's…61 terms Domain 1 Health Information Documentation29 terms BMTCP HM Fundamentals 155A142 terms Which data type allows both positive and negative numbers as field values?Integer data types can be Unsigned and Signed. Unsigned can store only zero and positive numbers, whereas Signed allows zero, positive, and negative numbers.
Is the default name for a new table in an Access database?Table1 is the default name of the first table in a new desktop database.
Which Access 2016 View contains commands used?The Backstage view. The Backstage view occupies the File tab on the ribbon and contains many commands. The Backstage view also contains other commands that apply to an entire database file. When you open Access but do not open a database (e.g., you open Access from the Windows Start menu), you see the Backstage view.
What is the default setting for the field size property for a field with the number data type?The default setting is 50. Number / Currency fields: Stores the number as a Byte, Integer, Long Integer, Single, Double, or Replication ID, or Decimal. The default setting is Long Integer.
|