cgsAccess 2021 Skills Approach – Ch 1 Skill Review 1.1

• If necessary, enable active content by clicking the Enable Content button in the Message Bar.
• The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor.
• Use the Navigation Pane.By default, the Navigation Pane displays the Tables and Related Views All tables and related objects are visible.Click the top of the Navigation Pane and select the Object TypeObserve that now all database objects are visible in the Navigation Pane, grouped by object type.
• Open the Items table.In the Navigation Pane, double-click the table object named Items.Review the fields in this table:

  ItemID

  Save Time On Research and Writing

  Hire a Pro to Write You a 100% Plagiarism-Free Paper.

  Get My Paper

  ,

  ItemName

  ,

  Description

  Save Time On Research and Writing

  Hire a Pro to Write You a 100% Plagiarism-Free Paper.

  Get My Paper

  ,

  Category

  , and

  Cost

  .If necessary, use the horizontal scroll bar to view all the fields.

• Switch views for the Items table.Note the state of the View button (on the Home tab, in the Views group). When you are in Datasheet view, the Views button displays Design view.On the Home tab, in the Views group, click the View button.Observe that the View button has switched to Datasheet view to indicate that clicking the button will return you to Datasheet view.Review the field names in Design view.Go back to Datasheet view by clicking the View button again.
• Navigate records in a table.Observe the record navigation buttons at the bottom of the table. Move your mouse over the different arrow buttons and observe the ScreenTips.Observe which record in the table becomes highlighted as you click the following record navigation buttons: Last record, First record, Next record, Previous record.Find the Current Record box, which indicates the current record number and the total number of records. Click to select the number in the Current Record Type the number 7 in this box and press Enter. The Current Record box should now display 7 of 21 and the seventh record in the table should be highlighted.Click in any record in the table. Use the following shortcut keys on your keyboard and observe which field/record becomes highlighted: Tab, ↑, ↓, ←, →. In addition, try holding Ctrl while pressing the ↑, or ↓.
• Enter a new record in the Items table.Click the New (blank) record button at the bottom of the table.Enter the following record into your table, using Tab to move from one field to the next. When you reach the Category

  field, observe that it is a lookup field. Use the drop-down arrow to view and select from the available values.

Table AC 1.1 displays the information for a record in Microsoft Access.

ItemID

Cost

$175.00

ItemName	Description	Category
ACC1	AccountingPro 2.0	Accounting software for professionals	Software

• Find the record with an item ID of GRA1 and edit the content.
• Delete the UFD1 item record.Type UFD1 in the Search box at the bottom of the table.Click the record selector box at the left side of that row to highlight the entire record.On the Home tab, in the Records group, click the Delete button.Click Yes to verify that you want to delete the record.
• AutoFit the width of the Description

  column so all the descriptions are visible by double-clicking the right border of the top of the Description column.

• Sort the items in the table so they are sorted alphabetically by category and then by item name within each category.Click anywhere in the ItemName

  field.On the Home tab, in the Sort & Filter group, click the Ascending button.Click anywhere in the Category field.On the Home tab, in the Sort & Filter group, click the Ascending button.Save the table by pressing Ctrl + S.

• Close the Items table by clicking the X at the upper right corner of the table. Be careful not to close the Access database instead.
• Rename the Items form.In the Navigation Pane, right-click the Items form and select Rename. Be careful not to rename the Items table.Type: Enter ItemsPress Enter.
• Enter a new record in a form.In the Navigation Pane, double-click the form object named Enter Items.Observe the record navigation buttons at the bottom of the form and note that they are the same as those in the table.Click the New (blank) record button at the bottom of the form.
• Enter the following record into your form, using Tab to move from one field to the next.

Table AC 1.2 displays the information for a record in Microsoft Access.

ItemID ItemName Description Category Cost

$649.00

TAB1	Tablet	High res tablet	Equipment

• Find and edit the record with the item ID LAP1.On the Home tab, in the Find group, click the Find button.Type LAP1 in the Find What box.Click the Find Next button.Close the Find and Replace dialog by clicking the X in the upper right corner of the dialog.The form should now display the Laptop 1000 item.Click in the Cost

  field and change the value from $550 to $799.

• Find and delete the record with the item ID PB03.On the Home tab, in the Find group, click the Find button.Type PB03 in the Find What box.Click the Find Next button.Close the Find and Replace dialog by clicking the X in the upper right corner of the dialog.The form should now display the Presentation Basics item.On the Home tab, in the Records group, click the Delete button arrow, and select Delete Record.Click Yes to verify that you want to delete the record.
• Close the Enter Items form.
• Open the Items table again.In the Navigation Pane, double-click the table object named Items.Observe that the TAB1 item record you entered in the form was added to the table. It should be listed as the eighth item in the table.Click the Last record button at the bottom of the table.Close the Items table.
• Review the table relationships.On the Database Tools tab, in the Relationships group, click the Relationships button.Verify that all table fields are shown. If necessary, increase the size of the table boxes. Starting with the table at the far left of the Relationships window, right-click the table and selct Size to Fit. Repeat the process with the remaining tables, moving from left to right across the Relationships window.Display all table relationships. On the Relationships Design tab, in the Relationships group, click the All Relationships button.Save the changes to the Relationships window layout by pressing Ctrl + S.Close the Relationships window. On the Relationships Design tab, in the Relationships group, click the Close button.
• Use the Compact and Repair Databases command.Minimize the Access window and navigate to the folder where you saved this database. Observe the file size.Return to Access and click the Database Tools tab.In the Tools group, click the Compact & Repair Database button.Minimize Access and look at your database file again. How much did the file size decrease?
• Back up the database.If necessary, maximize Access and click the File tab.Click Save As.In the Save Database As section, under Advanced, click Back Up Database, and click the Save As button.If necessary, navigate to the location where you save your personal project files. Click the Save button.
• Close the database and exit Access.