Access Chapter 3 Simulation Flashcards

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

How do you display the Total row in a table and calculate the sum of the values in the Amount field?

On the Home tab, in the Records group, click the Total button. Click the Amount column in the Total row. Click the arrow to expand the list of functions and select Sum.

What criteria do you add to a query to return only the records where the value in the Credits field is greater than 124 and the value in the Classification field is 'Sr'?

Click the Credits field's criteria row, type '>124'. Click the Classification field's criteria row, type 'Sr'. On the Design tab, in the Results group, click the Run button.

How do you modify a query to hide the DeptCode field in the query results?

Click the DeptCode column's Show box. On the Design tab, in the Results group, click Run.

How do you create a new query in Design view with specific fields from the Students and ResidenceHalls tables?

On the Create tab, in the Queries group, click Query Design. Inside the Add Tables dialog, select Students, then click Add. Double-click LastName, FirstName, Classification, ResidenceHall. Then select ResidenceHalls and add ResidenceName and FreshmenOnly. Finally, click Run. Signup and view all the answers

How do you set the sort order to display records with the highest number of credits first?

Click the Credits field's sort row, click the arrow, then click Descending. On the Design tab, in the Results group, click Run. Signup and view all the answers

How do you start a new query without using one of the query wizards?

On the Create tab, in the Queries group, click Query Design. Signup and view all the answers

What criteria do you add to a query to return records where the student LastName field begins with the letter 'A'?

Type 'Like 'A*' in the Criteria row in the LastName column. On the Design tab, in the Results group, click Run. Signup and view all the answers

How do you modify a query to show only students who are freshmen?

Click the Classification field's criteria row, type 'Fr'. On the Design tab, in the Results group, click Run. Signup and view all the answers

How do you modify a query to group results by values in the DeptName field and summarize Credits using the Sum function?

On the Design tab, in the Show/Hide group, click the Totals button. Click the Credits field's Total row, click the arrow, then click Sum. Click Run. Signup and view all the answers

How do you add criteria to a summary query to include only records where the value in the Days field is 'TTh'?

In the Total row, under Days, click the arrow and select Where. In the Criteria row, under Days, type 'TTh'. On the Design tab, in the Results group, click Run. Signup and view all the answers

What criteria do you add to a query to return records where the value in the Credits field is less than 90 and the value in the Classification field is 'Jr' or 'Sr'?

Type '<90' in the Credits field's criteria row and type 'Jr' or 'Sr' in the Classification field's criteria row. Run the query to view the results. Signup and view all the answers

Study Notes

Query and Table Manipulation in Access

Enable the Total row by clicking the Total button on the Home tab under the Records group for summing the Amount field.
To filter records, set criteria for the Credits field as ">124" and the Classification field as "Sr" before running the query.

Hiding Fields and Running Queries

To hide the DeptCode field in query results, uncheck the Show box for the DeptCode column, then run the query.

Creating New Queries

Initiate a new query in Design view by selecting Query Design from the Create tab in the Queries group.
To form a new query, add fields from both the Students and ResidenceHalls tables in the specified order, then execute the query.

Sorting and Reviewing Results

Modify sort order to display results of the Credits field in descending order for highest values first, and then run the query.
Set criteria in the LastName field with "Like 'A*'" to filter for students with last names starting with the letter A.

Classification and Grouping Records

For a query displaying only freshmen, set the Classification field criteria to "Fr" before running.
Use the Totals button to group and summarize records by DeptName and calculate total Credits using the Sum function.

Summary Queries and Criteria

To include criteria in summary queries, set the Days field criteria to "TTh" without including the Days field in the grouping.
For filtering records with Credits less than 90, add criteria for the classification as either "Jr" or "Sr" without punctuation, then execute the query.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Description

Test your knowledge of Microsoft Access with these simulation flashcards focused on Chapter 3. Learn how to display totals in tables and add criteria to queries. Perfect for students looking to master database management skills.