SM Transcripts In Practice Access Chapter 02

Show Me Transcripts SIMnet 2019 – In Practice – Access Chapter 2 Create a New Table in Design View To create a new table in Design view, click the Create tab on the Ribbon. Then, click the Table Design button [Tables group]. Add a New Field To add a new field, click the Field Name property box in the first empty row in the field list and type the desired name. Press the Enter key to add the field. Click the drop-down arrow in the Data Type property box and select the appropriate Data Type. Insert a Blank Row to Add a New Field between Existing Fields To insert a blank row to add a new field between existing fields, click the row selector where the new field should be added. Click the Insert Rows button [Table Tools Design tab, Tools group]. Define a Primary Key To define a primary key, click the row selector for the desired field. Click the Primary Key button [Table Tools Design tab, Tools group]. Delete a Field in a Table To delete a field in a table, click the row selector for the field to delete. Click the Delete Rows button [Table Tools Design tab, Tools group]. If there is data in the table, Access displays a message box asking you to confirm the deletion of the field. Click Yes to permanently delete the field. Switch Between Datasheet and Design Views To switch between datasheet and design views, click the View button [Home tab, Views group]. Set the Field Size Property To set the field size property for a Short Text field, click the Field Size property box and type the desired field size. 1 The Format Property To set the format property, click the row selector to select the desired field. Click the Format property to select it. Click the drop-down arrow and select the desired format. Set the Default Value To set the default value, click the row selector to select the desired field. Click the Default Value property box and type the desired value. Create a Field Validation Rule To create a field validation rule, click the row selector of the desired field. Click the Validation Rule property box and type the text of the desired rule. Create a Field Validation Rule Using the Expression Builder To create a field validation rule using the expression builder, click the row selector of the desired field. Click the Validation Rule property box and click the Build button. The Expression Builder dialog box opens. Type the text of the desired rule in the Expression box and click OK. Create a Record Validation Rule To create a record validation rule, click the Property Sheet button [Table Tools Design tab, Show/Hide group]. Click the Validation Rule property box. Type the text of the desired rule directly in the property box. Create Validation Text To create validation text, open the Property Sheet for the table by clicking the Property Sheet button [Table Tools Design tab, Show/Hide group]. Click the Validation Text property box and type the text of the desired message. Create a Combo Box Lookup Field Using the Lookup Wizard To create a combo box lookup field using the lookup wizard, click the row selector of the desired field. Click the property box for the Data Type property and click the drop-down arrow to display the list of data types. Select Lookup Wizard. The Lookup Wizard dialog box opens. Select the radio button for I will type in the values that I want. Click the Next button. Click the first cell in the Col1 column and type the first value in the list. Press the down arrow key to move to the next row. Continue typing all values in the list. Click the Next button when done entering all items on the list. The label defaults to the original field name you entered. As desired, you can change the field name. Click the Limit To List check box as desired. Click the Finish button when done. 2 Create an Input Mask To create an input mask, click the row selector of the desired field. Click the Input Mask property box. Click the Build button to launch the Input Mask Wizard. Select the preformatted mask you wish to use or an option that you can modify. Click the Next button to move to the next step of the Input Mask Wizard. Edit the Input Mask as desired and click the Next button to move to the next step of the wizard. Click the Finish button. Define a Relationship Using the Relationships Window To define a relationship using the relationships window, click the Relationships button [Database Tools tab, Relationships group]. Select the first table to add and click the Add button. Continue adding the remaining tables. Click the Close button when all tables have been added. Click, hold, and drag the primary key field from the table on top of the foreign key field in the related table. Release the pointer when you are positioned on top of the foreign key field in the related table. Check the Enforce Referential Integrity box. Click Create. Click Close [Relationship Tools Design tab, Relationships group] when you are finished with all changes to the relationships. Delete a Relationship between Tables To delete a relationship between tables, click the Relationships button [Database Tools tab, Relationships group]. Select the relationship line you wish to delete. Right-click the relationship line to open the context menu. Click Delete. Click Yes to confirm the deletion. Click Close. Edit a Relationship between Tables To edit a relationship between tables, click the Relationships button [Database Tools tab, Relationships group]. Select the relationship line you wish to edit. Click Edit Relationships [Relationship Tools Design tab, Tools group]. Change the referential integrity options or selected fields. Click OK. Save the changes made to the relationships. Click Close [Relationship Tools Design tab, Relationships group]. Preview the Data Records before Printing To preview the data records before printing, select the table you want to print from the Navigation Pane. Click the Print button [File tab] to display the printing options. Click the Print Preview button. Click the Landscape button [Print Preview tab, Page Layout group] to change the page orientation. Click the Margins button [Print Preview tab, Page Size group] and select the Normal button. Click the Close Print Preview button [Print Preview tab, Close Preview group]. 3 Compact and Repair a Database To compact and repair a database, click the File tab and then click the Compact & Repair Database button. 4