Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive /   Question 1)Access is a ____

  Question 1)Access is a ____

Computer Science

 

Question 1)Access is a ____.

 

     
 

 

     

Question 2

 

   
 

A field whose data type is ____ can store text that can be used as a hyperlink address.

     
       

Question 3

 

   
 

In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.

     
       

Question 4

 

   
 

To create a query using the Query Wizard, tap or click ____ on the ribbon and then click the Query Wizard button.

     
       

Question 5

 

   
 

Form view displays a single record at a time.

     
       

Question 6

 

   
 

A unique identifier also is called a primary key.

     
       

Question 7

 

   
 

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.

     
       

Question 8

 

   
 

To define an additional field in Datasheet view, tap or click the ____ column heading.

     
       

Question 9

 

   
 

To open the Navigation Pane, tap or click the ____ Button.

     
       

Question 10

 

   
 

In Access, the columns in a table are called records.

     
       

Question 11

 

   
 

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.

     
       

Question 12

 

   
 

One way to undo changes to a field is to click the Undo button on the status bar.

     
       

Question 13

 

   
 

The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.

     
       

Question 14

 

   
 

You can place an insertion point by tapping or clicking in the field or by pressing ____.

     
       

Question 15

 

   
 

A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.

     
       

Question 16

 

   
 

Changing the column width in a datasheet changes the structure of a table.

     
       

Question 17

 

   
 

The AutoError Correction feature of Access corrects common data entry errors.

     
       

Question 18

 

   
 

To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

     
       

Question 19

 

   
 

When you sort data in a query, the records in the underlying table are actually rearranged.

     
       

Question 20

 

   
 

To include calculated fields in queries, enter a name for the calculated field, a(n) ____, and then the expression in one of the columns in the Field row.

     
       

Question 21

 

   
 

To find all customers whose current due amount is greater than $1,000.00, enter ____ in the Criteria row of the Current Due column.

     
       

Question 22

 

   
 

 

 



In the accompanying figure, the lower pane in the window where you enter criteria is called the ____.

 

     
       

Question 23

 

   
 

A query that prompts for input whenever it is run is a dialog query.

     
       

Question 24

 

   
 

To print the results of a query that is open, tap or click FILE on the ribbon, tap or click the ____ tab in the Backstage view, and then tap or click Quick Print.

     
       

Question 25

 

   
 

Crosstab queries are useful for summarizing data by category or group.

     
       

Question 26

 

   
 

To find all customers whose returns are greater than $0.00 or whose book rep is book rep number 42, enter each criterion on the same row.

     
       

Question 27

 

   
 

To restrict the objects that appear on the Navigation Pane use the Retrieval Bar.

     
       

Question 28

 

   
 

To calculate statistics for only those records that satisfy certain criteria, select ____ as the entry in the Total row for the field, and then enter the criterion in the Criteria row.

     
       

Question 29

 

   
 

The asterisk (*) wildcard represents any collection of characters.

     
       

Question 30

 

   
 

To quit Access, click the ____ button on the right side of the Access title bar.

     
       

Question 31

 

   
 

To change the caption for a field in a query, click the field in the design grid, click the ____ button on the Design tab, click the Caption box, and enter the new caption.

     
       

Question 32

 

   
 

To include all fields in the design grid, double-click the question mark (?) in the field list. 

     
       

Question 33

 

   
 

To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.

     
       

Question 34

 

   
 

To re-use saved export steps, tap or click the Saved Exports button on the ____ tab on the ribbon.

     
       

Question 35

 

   
 

Modified Multiple Choice

The wildcard symbols for use with filters are ____.

     
 
     

Question 36

 

   
 

You can use the Find button on the HOME tab to search for records in datasheets, forms, query results, and reports.

     
       

Question 37

 

   
 

You can use a filter in either Datasheet view or Form view.

     
       

Question 38

 

   
 

To specify that entries in the Returns field must be between $0.00 and $30,000.00, enter ____ in the Validation Rule property box.

     
       

Question 39

 

   
 

 

 



To move to the first record using the form shown in the accompanying figure, tap or click the ____ button on the Navigation bar.

 

     
       

Question 40

 

   
 

 

 



To delete record PLI22 shown in the accompanying figure, tap or click the record selector in the datasheet for the record on which the client number is PLI22 and then press ____.

 

     
       

Question 41

 

   
 

You cannot preview the data to be updated in an update query before actually performing the update.

     
       

Question 42

 

   
 

When you use a split form, you only can add records using the simple form.

     
       

Question 43

 

   
 

To order the records in the Customer table by city in alphabetical order, use the ____ button.

     
       

Question 44

 

   
 

You can use the asterisk (*) wildcard in a filter but not the question mark (?) wildcard.

     
       

Question 45

 

   
 

You can convert a Number field to a Currency field but you cannot convert a Currency field to a Number field.

     
       

Question 46

 

   
 

To move from Layout view to Form view, tap or click the ____ button on the Access status bar.

     
       

Question 47

 

   
 

Four types of filters are available in Access: Filter By Selection, Common Filters, Filter By Form, and Advanced Filter/Sort.

     
       

Question 48

 

   
 

To add a new record using Form view, tap or click the New (blank) record button on the Navigation bar.

     
       

Question 49

 

   
 

To display the Total row in a datasheet, tap or click the Sum button on the ribbon.

     
       

Question 50

 

   
 

To create an update query, create a new query and then tap or click the ____ button on the DESIGN tab.

     
       

 

Option 1

Low Cost Option
Download this past answer in few clicks

3.83 USD

PURCHASE SOLUTION

Already member?


Option 2

Custom new solution created by our subject matter experts

GET A QUOTE

Related Questions