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?
Signup and view all the answers
How do you add the DOB field to a form immediately to the right of the LastName controls?
Signup and view all the answers
What criteria should be added to return records where the DeptCode is ENG or CIS?
Signup and view all the answers
How do you create a filter using the Custom Filter dialog for CourseDescription containing the word Foundation?
Signup and view all the answers
How do you group a report by the DOB field by year instead of by quarter?
Signup and view all the answers
How do you change the navigation pane grouping option so tables and dependent databases are grouped together?
Signup and view all the answers
How do you apply the Short Date input mask format to the StartDate field?
Signup and view all the answers
How do you add a new calculated field named Tuition in a query?
Signup and view all the answers
How do you create a new database from the students template named Students?
Signup and view all the answers
How do you create a backup of the database without changing the backup location?
Signup and view all the answers
How do you change the field size property for the RAStudentID field to 4?
Signup and view all the answers
How do you change the navigation pane grouping option for database objects?
Signup and view all the answers
How do you add a title to the form header and change the text to 'REVIEW'?
Signup and view all the answers
How do you modify a query so the DeptCode field is hidden in the results?
Signup and view all the answers
How do you set the sort order to display records with the highest number of credits first?
Signup and view all the answers
How do you move the Tuition Paid label to the layout area directly below the FirstName controls?
Signup and view all the answers
How do you preview a query's results when the page orientation is changed to landscape?
Signup and view all the answers
How do you create a parameter query for the DeptCode field using the prompt 'Enter Department Code'?
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.
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.
