lOMoARcPSD|22014731
CGS Acces s Exam Set the Navigate To Category to Tables and Related Views - correct answers Click the Navigation Pane arrow to the right of All Access Objects. Select the Tables and Related Views category.
Change the Filter By setting to All Tables. - correct answers Click the Navigation Pane arrow. Select All Tables in the Filter By Group area.
Create a new blank desktop database named PP A1-2. - correct answers 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 answers 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 answers Click the Create tab. Click the Table button.
Change the Primary Key ID to EmpID and the data type to Short Text. - correct answers 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 answers 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 answers 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 answers Click the File tab. Select Save. Type Employees in Save As dialog. Click OK.
Open the Employees table - correct answers Double-click the Employees table.
Add 101 to the Employee ID field and move to the next field - correct answers Type 101 and press Tab.
Append the CentralSierraDataFile-01 Excel file to the Employees table. - correct answers 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 answers Click the Next record button
Use the Navigation buttons to move to the Last record with one click - correct answers Click the Last record button.
Navigate directly to the 7th record using the Navigation buttons. - correct answers Click the Current record box. Type 7 and press Enter
Use the Navigation buttons to move directly to the first record - correct answers Click the First record button
Move the Branch field to the right of the Title field. - correct answers Click the Branch field. Click and drag the Branch field to the right of the Title field
Change the width of the Base Monthly Salary field to be just wide enough to show all of the salaries but not wide enough lOMoARcPSD|22014731
to show the field name. Note that the salaries are currently showing as pound signs (#). - correct answers Click the resize arrow on the right side of the column and drag the column wider to show the data
Use the Search box to find the first record with the word Health. - correct answers Click in the Search box at the bottom of
the window and type Health
Using the Drop-down List, sort the Start Date from Newest to Oldest - correct answers Click the drop-down arrow to the right of Start Date. Select Sort Newest to Oldest on the drop-down list.
Sort the records so the results are sorted by Branch and then by Department with the last entry in alphabetical order first - correct answers Click the Branch field and drag to the Department field to select both. Click the Descending button [Home tab, Sort & Filter group].
Filter the data by the Title field for all records that have the text Insurance Agent - correct answers Click Insurance Agent cell in the Title field for Employee 103. Click the Selection button. Select Equals "Insurance Agent" from the drop-down
Filter the data so that any record that contains the text Assistant in the Title field are displayed. - correct answers Click the
drop-down arrow to the right of the Title field name. Hover the mouse over Text Filters and select Contains. Type Assistant in the Title contains box and press Enter to submit the filter.
Create a new table in Design view. - correct answers Click the Create tab. Click the Table Design button
Add a new field named ProductName that is the Short Text data type without leaving Design view - correct answers the first blank field name cell to select it. Type ProductName and press Enter to move to the Data Type cell. Click the Data Type drop down arrow. Select Short Text
In Design view, add a new field before the DailyRentalRate field - correct answers Click the row selector next to the DailyRentalRate field. Click the Table Tools Design tab. Click the Insert Rows button
In Design view change the primary key to the ProductName field - correct answers Click the row selector for the ProductName field. Click the Table Tools Design tab. Click the Primary Key button
In Design view, delete the Comments field. - correct answers Click the Comments row selector. Select the Table Tools Design tab. Click the Delete Rows button. Click Yes
Switch to Datasheet view. - correct answers Click the View button
Switch to Design view. - correct answers Click the View button.
Change the EquipmentID Field Size to 5. - correct answers Click the Field Size property box for the EquipmentID field. Type 5 in the Field Size property box and press Enter.
Change the Format property for the DatePurchased field to Medium Date. - correct answers Click the DatePurchased row selector. Click the Format property. Click the Format property drop-down arrow. Select Medium Date
Set the default value for the State field to CA. - correct answers Click the State row selector. Click the Default Value Field
Property. type CA and press Enter
Add the Validation Rule Like "#####" to the EquipmentID field. - correct answers Click the Validation Rule property box. Type Like "#####" in the Validation Rule property box.
Use the Expression Builder to create the validation rule Like "#####". - correct answers Click the Validation Rule property box. Click the Build button. Type Like "#####". Click OK.
Create this record validation rule: [WeeklyRentalRate]>[DailyRentalRate] And [MonthlyRentalRate]>[WeeklyRentalRate] - correct answers Click the Table Tools Design tab. Click the Property Sheet
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Schoolflix. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.49. You're not tied to anything after your purchase.
