All categories

3 years ago

At the second simple query wizard dialog box, you are asked whether you would like to create a detail or a(n) _____ query.

Computers and Technology

1 answer:

Alisiya [41]3 years ago

3 0

The correct answer is: Summary

<span>If you only selected fields from a single table in the first screen, then when you click the “Next >” button to continue, you will only need to provide the query with a name and then click the “Finish” button to finish creating the query. If, however, you picked data fields from two or more related tables, then when you click the “Next >” button, you will instead view a second screen which asks if you would like a “Detail” or “Summary” query. You can select the option button for the type of query that you wish to create. If you select “Summary,” then you will be able to click the “Summary Options…” button to open the “Summary Options” dialog box. In this dialog box, you can select what type of summary to perform over a selected field. Make your selections, and then click the “OK” button to return to the “Simple Query Wizard.”</span>

Select summary to show only results of aggregate functions.

Select the aggregate function and the field name of the numeric field in the list box. You can enter as many aggregate functions as you want, one in each row of controls.

Aggregate function

Select the aggregate function.

Field name

Select the numeric field name.

Appends a new row of controls.

Removes the last row of controls.

You might be interested in

Suppose you have four 500 MB hard drives plus one 2 GB flash drive. How many GB of capacity is this overall?

Sidana [21]

You would have a total of 2.5 GB of capacity.

A gigabyte consists of 1000 megabytes, so 500 megabytes make half of a gigabyte, or 0.5 gigabytes.

So 2GB + 0.5GB = 2.5GB

4 0

3 years ago

Nathan wants to use the Push transition from left to right in his presentation. After he selects the Push transition, what shoul

Vladimir [108]

After he selects the Push transition, He should select from Left option from the Effect Options drop-down menu.

<h3>What is push transition in PowerPoint?</h3>

The Push Transition Effect is known to be a function in a PowerPoint that helps to pushes one slide to show the other.

Note that when this is applied to any presentation, it moves the current slide upwards to reveal the next slide and so on. A person can add use this kind of effect to present a scrolling effect to one's PowerPoint work.

Learn more about presentation from

brainly.com/question/24653274

8 0

2 years ago

Read 2 more answers

What directs the read/write arm of the hard drive to where data exists and accesses it upon the user's request?

Nastasia [14]

Answer:

NTFS (New Technology File System) or FAT(File Allocation Table) are used to direct read/write arm of hard drive to where data exists and access it upon user's request

Explanation:

Both NTFS and FAT are used but NTFS is fast and optimal and superseed the FAT and supported by windows NT 3.1 and later versions.

7 0

3 years ago

Samantha is looking for a lens that is lightweight and small, making it easy to transport. She doesn’t care about the lens being

irina1246 [14]

Answer:

The correct option is;

d. Prime

Explanation:

A prime lens is a unifocal, or fixed-focal-length lens and it is referred to as the opposite of a zoom lens

The maximum aperture of ranges from f2.8 to f1.2, which are fast and have a creamy rendering of light that are out of focus, and also provide crispy image details, by making the most use of the light available and provide distinct combination of foreground and background images in pictures that give a crisp and visually pleasing appearance.

7 0

3 years ago

Read 2 more answers

Write a program to read a list of exam scores given as integer percentages in the range 0-100. Display the total number of grade

Tju [1.3M]

Answer:

import java.util.Scanner;

public class Program

{

public static void main(String [] Args)

{

int totalAGrades = 0, totalBGrades = 0, totalCGrades = 0, totalDGrades = 0, totalFGrades = 0, counter=0,maximum = 0, minimum = 9999, num, total = 0,smallest = 0,largest = 0;

Scanner in = new Scanner(System.in);

System.out.println("Enter exam percentage: ");

System.out.println("Enter a negative examScore: ");

int examScore = in.nextInt();

while(examScore > 0)

{

counter++;

if(examScore < 0){

break;}

else if(examScore > maximum){

maximum = examScore;}

else if(examScore < minimum) {

minimum = examScore;}

total = total + examScore;

if(examScore <= 50 && examScore>0)

smallest = examScore;

if(examScore > 90 && examScore <=100)

largest = examScore;

if(examScore>=90 && examScore<=100)

totalAGrades++;

else if(examScore>=80 && examScore<=89)

totalBGrades++;

else if(examScore>=70 && examScore<=79)

totalCGrades++;

else if(examScore>=60 && examScore<=69)

totalDGrades++;

else if(examScore>=0 && examScore<=59)

totalFGrades++;

examScore = in.nextInt();

}

System.out.println("Total number of scores is = " + counter );

System.out.println("Total Number of each Letter grade : " + counter);

System.out.println("Percentage of total for each letter grade : ");

System.out.println("Total number of A grades = "+ totalAGrades);

System.out.println("Total number of B grades = "+ totalBGrades);

System.out.println("Total number of C grades = "+ totalCGrades);

System.out.println("Total number of D grades = "+ totalDGrades);

System.out.println("Total number of F grades = "+ totalFGrades);

System.out.println("Lowest exam Score is :"+smallest);

System.out.println("Highest exam Score is :"+largest);

System.out.println("Average exam Score = "+ (total / counter));

}

Explanation:

Get the exam information from user as input and run a while loop until examScore is greater than zero.
Use conditional statement to check the scores of students and increment the relevant grade accordingly.
Finally display all the information including grades and scores.

3 0

3 years ago