Access Exam Flashcards
21 Questions
100 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

How do you group a report by values in the Classification field from the current Layout view?

In the Design Ribbon Tab, click the Group & Sort button, then click Add a Group and select Classification.

How do you modify the Gender field to use a lookup list with Male and Female?

Expand the Data Type list for the Phone Type field.

What criteria should be added to return records with Credits less than 90 and Classification as Jr or Sr?

Set criteria for Credits field to <90 and for Classification field to Jr or Sr.

How do you use Filter by Selection to display records where the student's DOB is 10/25/1998 or later?

<p>Click the 10/25/1998 cell, then in Sort &amp; Filter Ribbon Group, select the Selection button and choose On or After '10/25/1998'.</p> Signup and view all the answers

How do you add the DOB field to a form immediately to the right of the LastName controls?

<p>Use the Field List pane to position the DOB field next to LastName without switching views.</p> Signup and view all the answers

What criteria should be added to return records where the DeptCode is ENG or CIS?

<p>Change the DeptCode field's criteria to ENG and add an OR condition for CIS.</p> Signup and view all the answers

How do you create a filter using the Custom Filter dialog for CourseDescription containing the word Foundation?

<p>Right-click the CourseDescription column, use Text Filters, and select Contains, then type Foundation.</p> Signup and view all the answers

How do you group a report by the DOB field by year instead of by quarter?

<p>Go to the Design tab, click the Group &amp; Sort button and add a group by year.</p> Signup and view all the answers

How do you change the navigation pane grouping option so tables and dependent databases are grouped together?

<p>Change the navigation pane grouping option settings.</p> Signup and view all the answers

How do you apply the Short Date input mask format to the StartDate field?

<p>Click the Input Mask property, select Short Date format without changing defaults.</p> Signup and view all the answers

How do you add a new calculated field named Tuition in a query?

<p>Right-click the first empty cell, type Tuition:[Credits]*150 in the Zoom dialog and run the query.</p> Signup and view all the answers

How do you create a new database from the students template named Students?

<p>Open the backstage view, select New, choose Students template and type Students in the File Name box.</p> Signup and view all the answers

How do you create a backup of the database without changing the backup location?

<p>Click the File tab, then Save As, select Back Up Database, and confirm.</p> Signup and view all the answers

How do you change the field size property for the RAStudentID field to 4?

<p>Click on RAStudentID, type 4 in the Field Size input in Properties Ribbon Group, then press Enter.</p> Signup and view all the answers

How do you change the navigation pane grouping option for database objects?

<p>Click the dropdown arrow on the navigation pane and select object type grouping.</p> Signup and view all the answers

How do you add a title to the form header and change the text to 'REVIEW'?

<p>Insert a title in the form or report in Design View, then type 'REVIEW' and press enter.</p> Signup and view all the answers

How do you modify a query so the DeptCode field is hidden in the results?

<p>Uncheck the Show box under the DeptCode field in the query design.</p> Signup and view all the answers

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

<p>Select the Credits field's sort row, choose Descending sort option, and run the query.</p> Signup and view all the answers

How do you move the Tuition Paid label to the layout area directly below the FirstName controls?

<p>Click the Tuition Paid label, hold 'Ctrl', then click the bound control and drag it below FirstName.</p> Signup and view all the answers

How do you preview a query's results when the page orientation is changed to landscape?

<p>Click the FILE tab, then Print, and select the Print Preview button, then click Landscape.</p> Signup and view all the answers

How do you create a parameter query for the DeptCode field using the prompt 'Enter Department Code'?

<p>Change the DeptCode criteria to [Enter Department Code] and run the query inputting FIN.</p> Signup and view all the answers

Study Notes

Access Exam Flashcards Summary

  • Grouping a report by the Classification field involves using the Group & Sort features in the Design Ribbon Tab.
  • Modifying the Gender field includes implementing a lookup list with "Male" and "Female" while restricting values to this list.
  • To filter a query based on Credits and Classification fields, apply criteria for less than 90 credits and classifications of either "Jr" or "Sr."
  • Use Filter by Selection to limit table records to students born on or after 10/25/1998.
  • Add the DOB field in the form next to the LastName control without changing views.
  • Set criteria in a query for the DeptCode field to include only "ENG" or "CIS."
  • Create a Custom Filter to display records in the CourseDescription field containing the word "Foundation."
  • Adjust report grouping by the DOB field to group records by year instead of quarters.
  • Change navigation pane groupings to combine tables and their dependent databases.
  • Apply the Short Date input mask format to the StartDate field without altering default settings.
  • Create a calculated field named Tuition to compute values based on the Credits field multiplied by 150.
  • Initiate a new database using the Students template, naming it "Students."
  • Backup the database by navigating to the Save As options and selecting Back Up Database.
  • Alter field size property for the RAStudentID field to 4 from datasheet view.
  • Group navigation pane objects by their types for organized access to tables, forms, etc.
  • Add a title "REVIEW" to the form header in layout view, saving changes after editing.
  • Hide the DeptCode field in a query before running it to display without showing this field.
  • Sort query results by Credits in descending order to prioritize records with the most credits.
  • Move tuition paid label control below FirstName controls in the layout area for better organization.
  • Preview query results in landscape format via the Print Preview options in the FILE tab.
  • Create a parameter query to allow user input for DeptCode criteria, prompting them to enter a department code like "FIN."

Studying That Suits You

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

Quiz Team

Description

Test your knowledge of Microsoft Access with these flashcards designed for exam preparation. Each card presents practical scenarios involving report grouping, field modifications, and lookup lists. Perfect for students or professionals looking to enhance their Access skills.

More Like This

Use Quizgecko on...
Browser
Open
Browser
Browser