Simnet Access UPDATED Exam Questions and CORRECT Answers

Simnet Access UPDATED Exam Questions
and CORRECT Answers
Change the Filter By setting to All Tables. - CORRECT ANSWER - HINT: Click the
Navigation Pane arrow. Select All Tables in the Filter By Group area.


Set the Navigate To Category to Tables and Related Views. - CORRECT ANSWER --
Click the Navigation Pane arrow to the right of All Access Objects. Select the Tables and Related
Views category


Create a new blank desktop database named PP A1-2. - CORRECT ANSWER - -Click the
File tab and select New. Select the Blank database button. Type PP A1-2 and click Create


Save a backup of the database. Accept the file name suggested by Access. - CORRECT
ANSWER - -Click the File tab. Click Save As. Click Back Up Database in the Save
Database As section at the right side of the screen. Click the Save As button. Click Save


Create a new table in Datasheet view. - CORRECT ANSWER - -Click the Create tab.
Click the Table button-


Change the Primary Key ID to EmpID and the data type to Short Text. - CORRECT
ANSWER - -Double-click the ID field. Type EmpID press the down arrow. Navigate to the
Table Tools Fields tab. Click the Data Type drop down arrow. Select Short Text


Add a new field with the Short Text data type and is named FirstName. - CORRECT
ANSWER - -Click the Click to Add column header. Select Short Text. Type FirstName and
press Enter-


Using Datasheet view, set the Caption of the selected field to First Name. Set the Description to
Employee's First Name. Change the Field Size to 25. - CORRECT ANSWER - -Click the
Name & Caption button [Table Tools Fields tab, Properties group]. Type First Name in the
Caption property. Type Employee's First Name in the Description property. Click OK. Type 25 in
the Field Size property [Table Tools Fields tab, Properties group] and press Enter-

, Save the table with the name Employees. - CORRECT ANSWER - -Click the File tab.
Select Save. Type Employees in Save As dialog. Click OK


Open the Employees table. - CORRECT ANSWER - -Double-click the Employees table-



Add 101 to the Employee ID field and move to the next field. - CORRECT ANSWER --
Type 101 and press Tab-


Append the CentralSierraDataFile-01 Excel file to the Employees table. - CORRECT
ANSWER - -Click the Excel button [External Data tab, Import & Link group]. Click the
Browse button. Select the CentralSierraDataFile-01 Excel file. Click the Open button. Select the
Append a copy of the records to the table radio button. Click OK. Click the Next button. Click
Finish. Click the Close button-


Use the Navigation buttons to move to the Next record. - CORRECT ANSWER - -Click
the Next record button- tiny right arrow at bottom left


Use the Navigation buttons to move to the Last record with one click. - CORRECT
ANSWER - -Click the Last record button
right arrow with line in bottom left corner


Navigate directly to the 7th record using the Navigation buttons. - CORRECT ANSWER -
-Click the Current record box. Type 7 and press Enter-


Use the Navigation buttons to move directly to the first record. - CORRECT ANSWER --
Click the First record button- left arrow with line


Move the Branch field to the right of the Title field. - CORRECT ANSWER - -Click the
Branch field. Click and drag the Branch field to the right of the Title field