Access exam
16) From the current view (Layout view), group this report by values in the DOB field. Change the grouping to group by year instead of by quarter.
Go to the Design tab, in the grouping & totals click group &sort button, window should pop up, click "add a group" ...? year instead of quater
25) Add a new calculated field named Tuition in the first empty column to the right of the Credits field. The new field should calculate the value in the Credits field multiplied by 150. Run the query to view the results.
Right-click the first empty cell in the Field row of the query design grid. Then click Zoom from menu. Inside the Zoom dialog, you typed Tuition:[Credits]*150 in the Zoom Value Input input, click Ok Button button. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
43) Set the sort order so the results will display records with the highest number of credits first. Run the query and review the results.
click the Credits field's sort row, expanded the Credits field's sort options list(drop down list), and selected the Descending option. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
50) Create a parameter query where the user will enter a value to use as the criterion for the DeptCode field. Use the prompt Enter Department Code. Run the query using the Department Code FIN.
click the DeptCode field's criteria row box, change the DeptCode field's criteria to [Enter Department Code]. In the Design Ribbon Tab, click the Run button. Inside the Enter Parameter Value dialog, you typed FIN in the Enter last name input, clicked the OK button.
33) change the navigation pane grouping option so all database objects of the same type are grouped together (all tables together, all forms together, etc)
click the little arrow drop down on the navigation pane and the click object type
47) move the tuition paid label control and its bound control to the layout area directly below the FirstName controls.
click the tuition paid label, press ctrl and then click bound control, then drag it directly below the firstname controls.
26) create a new database from the students template. do not the location. name the database students
Opened the backstage view, clicked the New, clicked the Students template, and typed Students in the File Name box
48) preview how the results of this query will look when printed when the page orientation is changed to landscape
Click the FILE tab, click the Print, click the Print Preview button. In the Print Preview Ribbon Tab in the Page Layout Ribbon Group, you clicked the Landscape button. close print preview
38) modify this query so the DeptCode field is hidden in the query results and then run the query
Click the Show box under the Location field to remove the checkmark, then click RUN
31) Create a backup of the database. you do not need to change the backup location.
Click the file tab, click Save as, Click Back Up Database, then click save as again
4)Use Filter by Selection to filter the table to show only records where the student's DOB is 10/25/1998 or later.
In the Access Table, you clicked in the 10/25/1998 Cell, clicked in the 10/25/1998 Cell. In the Home Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Selection button. In the Selection menu, you clicked the On or After "10/25/1998" menu item.
14) Create a filter using the Custom Filter dialog to show only records where the value in the CourseDescription field contains the word Foundation.
In the Access Table, you clicked on CourseDescription, clicked the arrow at the top of the CourseDescription column, right-clicked the CourseDescription column header, and clicked the arrow at the top of the CourseDescription column. In the Table Column Filter Right-Click menu in the Text Filters menu, you clicked the Contains... menu item. Inside the Custom Filter dialog, you typed Foundation in the CourseDescription contains input, clicked the OK button.
32)From the current view (datasheet view) change the field size property for the rastudentid field to 4
In the Access Table, you clicked on RAStudentID. In the Fields Ribbon Tab in the Properties Ribbon Group, you typed 4 in the Field Size input, pressed the Enter key. Inside the Spa : Database dialog, you clicked the Yes button OR in the table tools, fields ribbon, change the field size in the box and click enter
20) Apply the Short Date input mask format to the selected field (StartDate). Do not change default format or placeholder characters.
In the Access Table, you clicked the Input Mask property box, clicked the Input Mask property box, and clicked the Input Mask Build... Button. Inside the Input Mask Wizard dialog from the Input Mask list, you selected Zip Code. Inside the Input Mask Wizard dialog, you clicked the Next > button, clicked the Next > button, clicked the Next > button, and clicked the Finish button. WORD DOC
1) From the current view (Layout view), group this report by values in the Classification field.
In the Design Ribbon Tab in the Grouping & Totals Ribbon Group, you clicked the Group & Sort button. You clicked the Add a Group button. In the Field Name menu, you clicked the Classification menu item.
34) from the current view (layout view) add a title to the form header and change the text to: REVIEW press enter when you are finished
Insert a title into a form or report Open the form or report in Design View or Layout view. ... On the Design tab, in the Header/Footer group, click Title. ... When the label is created, the text in the label is automatically selected so that you can change the text by typing the title you want. Press ENTER when you have finished.
2) From Design view, modify the Gender field to use a lookup list with Male and Female in a single column. Limit the field to values in the list only.
PIC Expand the Data Type list for the Phone Type field.
13) Add criteria to this query to return only the records where the value in the DeptCode field is ENG or CIS. Run the query to view the results.
You clicked the DeptCode field's criteria row, changed the DeptCode field's criteria to ENG, clicked the deptCode field's or row, and changed the deptCode field's or row to CIS. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
