Questions and Answers
What do you do to enable active content in a database?
You clicked the Enable Content button.
How do you preview how the results of a table will look when printed?
You opened the backstage view, clicked the Print navigation button, and clicked the Print Preview button. In the Print Preview Ribbon Tab, you clicked the Two Pages button.
How do you add criteria to return only records where the value in the DeptCode field is ENG or CIS?
You clicked the DeptCode field's criteria row, changed it to ENG, then changed the or row to CIS and clicked the Run button.
What steps do you follow to create a Split form from the Classes table?
Signup and view all the answers
How do you use Filter by Selection to filter the table to show records where the student's DOB is 10/25/2006 or later?
Signup and view all the answers
What is the process to add a new calculated field named Tuition?
Signup and view all the answers
How do you preview how the results of a query will look when printed?
Signup and view all the answers
From the current view, how do you set the Default Value property for the Classification field to Fr.?
Signup and view all the answers
How do you preview how a report will look when printed and show two pages at once?
Signup and view all the answers
What is the method to apply the Short Date input mask format to the StartDate field?
Signup and view all the answers
How do you go to the last record?
Signup and view all the answers
How do you modify a query to show only students who are freshmen?
Signup and view all the answers
What steps are involved in adding a new record to the table with student ID 6412?
Signup and view all the answers
How do you use AutoFilter to show only records where the Department field is Economics?
Signup and view all the answers
What steps do you follow to create a new blank report that will open in Layout view?
Signup and view all the answers
How do you set the Default Value property for the Classification field from Datasheet view?
Signup and view all the answers
Study Notes
Active Content
- Enable active content in a database by clicking the "Enable Content" button.
Print Preview
- To preview printed table results, access backstage view: click "Print" then "Print Preview".
- Adjust preview options to show two pages simultaneously by selecting the "Two Pages" button in the Print Preview Ribbon Tab.
Query Criteria
- Modify query to filter records in the DeptCode field for values ENG or CIS.
- Adjust the criteria by selecting the criteria row in the DeptCode field and altering as needed. Run the query to display results.
Split Forms
- Create a Split form using the Classes table via the Create Ribbon Tab: select "More Forms" and then choose "Split Form".
Filtering Records
- Use "Filter by Selection" to display records where student's DOB is on or after 10/25/2006.
- Click on the date cell, navigate to the Sort & Filter group, and select "On or After '10/25/2006'" from the selection menu.
Calculated Fields
- Introduce a calculated field named "Tuition" adjacent to the Credits column, computed as Credits * 150.
- Right-click to access the Zoom dialog and enter the calculation formula. After setting it, run the query to view the outcomes.
Reporting
- Preview query results for printing by accessing backstage view and selecting "Print" then "Print Preview".
- In Print Preview, set to view two pages at once using the "Two Pages" button.
Default Value Setting
- From Design view, alter the Default Value property of the Classification field to "Fr". Confirm changes by pressing Enter.
Last Record Navigation
- Move to the last record by clicking the "Last Record" button.
Freshmen Classification Filter
- Adapt query criteria to filter students classified as freshmen (Fr) by adjusting the Classification field's criteria. Run the query to see results.
Adding Records
- Add a new record with student ID 6412 by clicking the "New" button and entering the ID in the Access Table, using Tab to progress to the next field.
AutoFilter Usage
- Apply AutoFilter on the Department field to display records specific to the value "Economics".
- Access the filter by clicking the dropdown arrow in the Department column, unchecking "Select All", checking "Economics", and confirming with OK.
Creating Reports
- Generate a new blank report that will appear in Layout view by selecting the "Blank Report" option from the Create Ribbon Tab.
Additional Default Value Setting
- From Datasheet view, set the Default Value property for the Classification field to "Fr" by navigating within the Fields Ribbon Tab and making changes in the properties.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Test your knowledge with these flashcards covering key concepts in Microsoft Access relevant to the CGS2100 course. Each card highlights important terminology and definitions that will help you prepare for the exam. Perfect for quick revision and self-assessment!