CGS2100 Access Exam Flashcards

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?

In the Create Ribbon Tab, click the More Forms button and then click the Split Form menu item. 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?

You clicked in the 10/25/2006 cell, then in the Home Ribbon Tab, clicked the Selection button and chose On or After '10/25/2006'. Signup and view all the answers

What is the process to add a new calculated field named Tuition?

Right-click the Drop-Down Menu, select Zoom..., type Tuition:[Credits]*150, and then click the Run button. Signup and view all the answers

How do you preview how the results of a query will look when printed?

You opened the backstage view, clicked the Print navigation button, and clicked the Print Preview button. Signup and view all the answers

From the current view, how do you set the Default Value property for the Classification field to Fr.?

You clicked the Default Value property box, typed Fr in the box, and pressed the Enter key. Signup and view all the answers

How do you preview how a report will look when printed and show two pages at once?

You opened the backstage view, clicked the Print navigation button, and clicked the Print Preview button. Then, in the Print Preview Ribbon Tab, you clicked the Two Pages button. Signup and view all the answers

What is the method to apply the Short Date input mask format to the StartDate field?

You clicked the Input Mask property box, then selected Short Date from the Input Mask Wizard and completed the process. Signup and view all the answers

How do you go to the last record?

You clicked the Last Record button. Signup and view all the answers

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

You clicked the Classification field's criteria row, changed it to Fr, and clicked the Run button. Signup and view all the answers

What steps are involved in adding a new record to the table with student ID 6412?

In the Home Ribbon Tab, click the New button, type 6412, and press Tab. Signup and view all the answers

How do you use AutoFilter to show only records where the Department field is Economics?

You clicked the arrow at the top of the Department column, selected Economics from the filter options, and clicked OK. Signup and view all the answers

What steps do you follow to create a new blank report that will open in Layout view?

In the Create Ribbon Tab in the Reports Ribbon Group, you clicked the Blank Report button. Signup and view all the answers

How do you set the Default Value property for the Classification field from Datasheet view?

In the Fields Ribbon Tab, click the Default Value property box and set it to Fr. 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.

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!