Upgrade to remove ads
Only SGD 41.99/year
- Science
- Computer Science
-
Flashcards
-
Learn
-
Test
-
Match
-
Flashcards
-
Learn
-
Test
-
Match
Terms in this set [218]
Because many of the accounts that PrattLast Associates services are located in Pennsylvania, management would like to minimize any data entry in this field. What property do you need to change and what would you enter in the property box?
You need to change the Default Value property. You would enter =PA in the property box.
PrattLast has just realized that they need to make some additional changes to the Account table. They have asked you to make these changes.
Because PrattLast may move the database to SQL Server, they have decided to delete the Resources Needed field. How do you delete the field?
Click the row selector for the Resources Needed field and then press the DELETE key.
PrattLast Associates has decided to add some additional validation rules to the Account table. They have asked you to create these validation rules.
PrattLast would like to make sure that if a manager enters the letters pa in the State field that it displays in the database as PA. What property do you need to change and what would you enter in the property box?
You need to change the Format property and you would enter the format symbol, > in the box to convert all entries to uppercase.
PrattLast has just realized that they need to make some additional changes to the Account table. They have asked you to make these changes.
Bavant would like to move the Account Type field in the Account table. The field should appear before the Account Manager field. What do you need to do to move the field?
To move the field, click the row selector for the Account Type field and then drag the field to the location immediately above the Account Manager field.
Which aggregate function will find the customer with the largest amount paid?
To find the largest amount paid amount for a customer, select MAX as the entry in the Total row for the Amount Paid column.
What criteria should PrattLast enter in the Start Date column of the design grid?
I would enter the criteria =0 and
Restructuring the database includes adding new fields to a table, changing the characteristics of existing fields, and removing existing fields.
True
To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.
Rename
To change the name of a field, press and hold or right-click the column heading for the field, and then tap or click Rename Field on the shortcut menu
True
To add a record to a table, tap or click the ____ record button.
New [blank]
To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click Insert Column on the shortcut menu.
False
To delete a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.
Delete
To import data to a table, tap or click the ____ tab on the ribbon.
External Data
The Access window consists of a variety of components. These include the ____.
Object tabs
Navigation Pane
Quick Access Toolbar
To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu
Open
Changing the column width in a datasheet changes the structure of a table
False
A field that has the Calculated data type can store a unique sequential number that Access assigns to a record
False
A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.
AutoNumber
To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.
Design View
To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation
False
In Access, table and field names can be up to ____ characters in length.
64
____ words are words that have a special meaning to Access and cannot be used for the names of fields
Reserved
The term list database describes a database that consists of a collection of tables, each of which contains information on a specific subject
False
The maximum number of characters allowed in a field whose data type is Short Text is 255 characters
True
Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo
False
Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship
True
One way to undo changes to a field is to click the Undo button on the status bar
False
Landscape orientation means the printout is across the length [height] of the page
True
The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255
False
Form view displays a single record at a time
True
A field whose data type is ____ can store text that can be used as a hyperlink address.
Hyperlink
To delete a record, tap or click the record selector for the record, and then press the ____ key[s]
Delete
A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet
Attachment
To save the changes to the layout of a table, tap or click the Save button on the ____.
Quick Access Toolbar
Wildcards are symbols that represent any character or combination of characters
true
To enter a number in a criterion, type the number without any dollar signs or commas
True
To change the design of a query that is not currently open, right-click the query and then click ____ on the shortcut menu
Design View
A summary function is a function that performs some mathematical function against a group of records
False
To include the Total row in the design grid, click the ____ button on the DESIGN tab
Totals
To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____
Square Brackets []
In fixed-width files, each record is on a separate line and the fields are separated by a special character
False
To re-use saved export steps, click the Saved Exports button on the ____ tab on the ribbon
External Data
When you sort data, duplicates are not included
False
Grouping means creating groups of records that share some common characteristic
True
To show the Navigation Pane if it is hidden, click the ____ Button
Shutter Bar Open/Close
To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu
Tables and Related View
To print the results of a query that is open, click FILE on the ribbon, click the ____ tab in the Backstage view, and then click Quick Print
Less than [], and NOT [not equal to] are examples of ____
Comparison operators
The ____ operator allows you to search for a range of values in one field
BETWEEN
To view the results of a query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu
Open
Unless you specify otherwise, Access assumes that the criteria you enter involve equality [exact matches]
True
A default value is a value that Access will display on the screen in a particular field before the user begins adding a record.
True
To display the Total row in a datasheet, click the Sum button on the ribbon
False
You can add a record to a table by ____
-Clicking the New [blank] record button on the Navigation bar
-Clicking the New button
-Pressing the CRTL + PLUS SIGN [+]
To sort the data that appears in a datasheet on multiple fields, the major and minor keys must be next to each other in the datasheet with the major key on the right
False
You can use a filter in either Datasheet view or Form view
True
To order the records in the Account table by city in alphabetical order, use the ____ button
Ascending
Normally, Access prohibits the deletion of a record in which the primary key matches a foreign key in another table
True
Filter By Query allows you to filter based on multiple criteria, for example, to find only those accounts whose returns are $0.00 and whose account manager is 38
False
To find duplicate records in a table, use the _____ Query Wizard
Find Duplicatesq
To specify that a field is to be required, change the value for the _____ property from No to Yes
Required
The Remove Filter command on the Advanced menu clears all filters
False
The wildcard symbols for use with filters are ____
-Question Mark [?]
-Asterisk [*]
When a filter is in effect, you can redisplay all records by clicking the ____ button on the HOME tab
Toggle Filter
To order the records in the Account table in reverse alphabetical order by City, click the ____ button
Descending
Validation rules can indicate a ____
-Default
Value
-Required Field
-Range of Values
When you create a calculated field, users can update the field
False
A[n] ____ field is a field that can be computed from other fields
Calculated
To open a form in Form view from the Navigation Pane, right-click the form and click Form View on the shortcut menu
False
To create a split form, select the table in the Navigation Pane, click CREATE on the ribbon, click the ____ button on the CREATE tab to display a menu, and then click Split Form on the menu
More Forms
To clear a filter, click the ____ button on the HOME tab and then click Clear All Filters.
Advanced
To use Filter By Selection to find all customers located in Granger, click the City field for any record where the city is Granger and then click the ____ button on the HOME tab.
Selection
Validation rules are rules that a user must follow when entering the data
True
Students also viewedCh 10/11 Test Questions
75 terms
fantasticowenking123
Access 2
50 terms
barbara_terczak
Access
63 terms
Emely_Campos
Access module 2
43 terms
mia_bairPlus
Sets found in the same folderModules 1-5
282 terms
Lindsay_Stokes0921
Midterm II
291 terms
Lindsay_Stokes0921
Other sets by this creatorCSCI Final
786 terms
Lindsay_Stokes0921
Systematic Theology Final
127 terms
Lindsay_Stokes0921
French Final
25 terms
Lindsay_Stokes0921
Quiz 8
19 terms
Lindsay_Stokes0921
Verified questions
computer science
Use what you’ve learned about the binary numbering system to convert the following decimal numbers to binary: 11 65 100 255
Verified answer
computer science
Provide a minimal set of MIPS instructions that may be used to implement the following pseudoinstruction: $$ not $t1, $t2 \quad // bit-wise \quad invert $$
Verified answer
computer science
Given a dictionary gradeCounts = { "A": 8, "D": 3, "B": 15, "F": 2, "C": 6 } write the Python statement[s] to print: a. all the keys. b. all the values. c. all the key and value pairs. d. all of the key and value pairs in key order e. the average value. f. a chart similar to the following in which each row contains a key followed by a number of asterisks equal to the key’s data value. The rows should be printed in key order, as shown below. A: ******** B: *************** C: ****** D: *** F: **
Verified answer
computer science
Both main memory and secondary storage are types of memory. Describe the difference between the two.
Verified answer
Recommended textbook solutionsInformation Technology Project Management: Providing Measurable Organizational Value
5th EditionJack T. Marchewka
346 solutions
Computer Organization and Design MIPS Edition: The Hardware/Software Interface
5th EditionDavid A. Patterson, John L. Hennessy
220 solutions
Information Technology Project Management: Providing Measurable Organizational Value
5th EditionJack T. Marchewka
346 solutions
Information Technology Project Management: Providing Measurable Organizational Value
5th EditionJack T. Marchewka
346 solutions
Other Quizlet setsInspections
14 terms
Natalia_Washington4
Drafting [ED] Test on Fundamentals and Equpiment
31 terms
Jessy_Martin
CSCI40 MIDTERM 2 REVIEW
28 terms
ricardonav18Teacher
Final !!
56 terms
nelispereira1