Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive /     Question 1)To omit duplicates from a query, use the property sheet and change the Unique Values property to ____

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

Computer Science

 

 

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

     
       
  • Question 2

 

   
 

When you sort data, duplicates are not included.

     
       
  • Question 3

 

   
 

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

     
       
  • Question 4

 

   
 

To create a parameter query that will prompt users to enter a city name as input, place [Enter City] as the criterion in the City field.

     
       
  • Question 5

 

   
 

When you enter text data in a criterion, you must enclose the text in quotation marks.

     
       
  • Question 6

 

   
 

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

     
       
  • Question 7

 

   
 

crosstab query calculates a statistic for data that is grouped by two different types of information. ____________________

     
       
  • Question 8

 

   
 

To view the results of a query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.

     
       
  • Question 9

 

   
 

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 10

 

   
 

Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose.

     
       
  • Question 11

 

   
 

To view the results of a query, open it by right-clicking the query in the Navigation Pane and clicking ____ on the shortcut menu.

     
       
  • Question 12

 

   
 

To order the records in the answer to a query in a particular way, you ____ the records.

     
       
  • Question 13

 

   
 

You can include ____ in calculations to indicate which calculation should be done first.

     
       
  • Question 14

 

   
 

To show the Navigation Pane if it is hidden, click the ____ Button.

     
       
  • Question 15

 

   
 

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 16

 

   
 

Grouping means creating groups of records that share some common characteristic.

     
       
  • Question 17

 

   
 

To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.

     
       
  • Question 18

 

   
 

To find all accounts whose current due amounts are greater than $2,500.00 and whose account manager is manager 31, enter each criterion on the same row.

     
       
  • Question 19

 

   
 

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 20

 

   
 

To save a query, click the Save button on the ____.

     
       
  • Question 21

 

   
 

To create a top-values query, use the Top Values box on the DESIGN tab to change the number of records to be included from All to the desired number.

     
       
  • Question 22

 

   
 

You can export data from Access to the standard Word format.

     
       
  • Question 23

 

   
 

You cannot create a report for a query.

     
       
  • Question 24

 

   
 

A property sheet is a window containing the various properties of the object.

     
       
  • Question 25

 

   
 

summary function is a function that performs some mathematical function against a group of records. ____________________

     
       
  • Question 26

 

   
 

Standard properties are associated with all Microsoft Office documents and include author, title, and subject.

     
       
  • Question 27

 

   
 

Landscape orientation means the printout is across the length (height) of the page.

     
       
  • Question 28

 

   
 

Form view displays a single record at a time.

     
       
  • Question 29

 

   
 

To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

     
       
  • Question 30

 

   
 

The Navigation Pane contains a list of all the objects in the database.

     
       
  • Question 31

 

   
 

To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.

     
       
  • Question 32

 

   
 

To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.

     
       
  • Question 33

 

   
 

To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.

     
       
  • Question 34

 

   
 

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 35

 

   
 

A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.

     
       
  • Question 36

 

   
 

To delete a record, tap or click the record selector for the record, and then press the ____ key(s).

     
       
  • Question 37

 

   
 

A unique identifier is also called a primary key.

     
       
  • Question 38

 

   
 

In Access, field names cannot contain digits.

     
       
  • Question 39

 

   
 

Layout view shows a report on the screen and allows the user to make changes to the report.

     
       
  • Question 40

 

   
 

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

     
       
  • Question 41

 

   
 

The Currency data type is used for fields that contain only monetary data.

     
       
  • Question 42

 

   
 

A(n) ____ contains information about a given person, product, or event.

     
       
  • Question 43

 

   
 

The term list database describes a database that consists of a collection of tables, each of which contains information on a specific subject. ____________________

     
       
  • Question 44

 

   
 

Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship.

     
       
  • Question 45

 

   
 

To add a record to a table, tap or click the ____ record button.

     
       
  • Question 46

 

   
 

To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation.

     
       
  • Question 47

 

   
 

To save the changes to the layout of a table, tap or click the Save button on the ____.

     
       
  • Question 48

 

   
 

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

     
       
  • Question 49

 

   
 

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.

     
       
  • Question 50

 

   
 

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

     
       

 

Option 1

Low Cost Option
Download this past answer in few clicks

6.83 USD

PURCHASE SOLUTION

Already member?


Option 2

Custom new solution created by our subject matter experts

GET A QUOTE

rated 5 stars

Purchased 8 times

Completion Status 100%

Sitejabber (5.0)

BBC (5.0)

Trustpilot (4.8)

Google (5.0)