Fundamentals of Database Systems
7th EditionRamez Elmasri, Shamkant B. Navathe
687 solutions
Information Technology Project Management: Providing Measurable Organizational Value
5th EditionJack T. Marchewka
346 solutions
Service Management: Operations, Strategy, and Information Technology
7th EditionJames Fitzsimmons, Mona Fitzsimmons
103 solutions
Service Management: Operations, Strategy, and Information Technology
7th EditionJames Fitzsimmons, Mona Fitzsimmons
103 solutions
Upgrade to remove ads
Only A$47.99/year
- Science
- Computer Science
-
Flashcards
-
Learn
-
Test
-
Match
-
Flashcards
-
Learn
-
Test
-
Match
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 3
37 terms
AccessTutorial 2
43 terms
CIT105-ACCESS Quiz 2
29 terms
BCIS: Access Module 3
16 terms
Sets found in the same folderCGS 2100
48 terms
Study Guide Test 2 comp class
45 terms
CGS Test 3
48 terms
CGS Test review 5
32 terms
Other sets by this creatorPGA PGM Qualifying Test
157 terms
PEO 2624 Exam 2
29 terms
BSC1005L FINAL FSU
195 terms
Cases
9 terms
Recommended textbook solutionsInformation Technology Project Management: Providing Measurable Organizational Value
5th EditionJack T. Marchewka
346 solutions
Fundamentals of Database Systems
7th EditionRamez Elmasri, Shamkant B. Navathe
687 solutions
Service Management: Operations, Strategy, and Information Technology
7th EditionJames Fitzsimmons, Mona Fitzsimmons
103 solutions
Computer Organization and Design MIPS Edition: The Hardware/Software Interface
5th EditionDavid A. Patterson, John L. Hennessy
220 solutions
Other Quizlet setsChapter 10
32 terms
Reforming American Society/ Abolition and women's…
61 terms
Domain 1 Health Information Documentation
29 terms
BMTCP HM Fundamentals 155A
142 terms