Lesson SummaryPlanning a DatabaseKnow how to plan a good database design. Creating a Database Using the Database WizardTo Create a Database Using the Database Wizard: Click the New button on the toolbar or select File On my computer link in the task pane, click the Databases tab in the Templates dialog box, then double-click the type of database you want to create. Follow the onscreen instructions and specify what you what to appear in your database. Creating a Blank DatabaseTo Create a New Blank Database: Click the New button on the toolbar, or select File Ctrl + N. Select Blank Database from the task pane, then navigate to the drive and folder where you want to save the new database. Type a name for your new database in the File name box and click Create. Creating a Table Using the Table WizardTo Create a New Table Using the Table Wizard: In the database window, click the Tables icon in the Objects bar, double-click Create table by using wizard, then select the type of table you want to create. Follow the onscreen instructions and specify what you what to appear in your database. Modifying a Table and Understanding Data TypesTo Display a Table in Design View: Open the table and click the View button on the toolbar, or, in the database window, click the Tables icon in the Objects bar, select the table, and click the Design button. To Change the Data Type for a Field: Display the table in Design view, click the field's Data Type box, click the list arrow, and select the data type. To Save Changes to a Database Object: Click the Save button on the toolbar, or select File Ctrl + S. Creating a New Table from ScratchTo Create a Table from Scratch: In the database window, click the Tables icon in the Objects bar and then double-click Create table in Design view. Type a field name in the Field Name column, press Tab, click the list arrow in the Data Type box, and select a data type for the field. Repeat the preceding steps as necessary to add additional fields. When you're finished, close the table window, click Yes to save the table, enter a table name, and then click OK. Creating a Query in Design ViewTo Create a Query in Design View: In the database window, click the Queries icon in the Objects bar and then double-click Create query in Design view. Select the table you want to add to the query and click Addrepeat as necessary to add additional tables or queries. When you're finished, click Close. In the field list, double-click each field you want to include in the query or drag the field from the field list onto the design grid. In the design grid, enter any desired search criteria for the field in the Criteria box and uncheck the field's Show box if you don't want it to be displayed in the query results. Close the query window, click Yes to save the query, enter a query name, and then click OK. Modifying a QueryTo Add a Field to a Query: In the field list, double-click each field you want to include in the query or drag the field from the field list onto the design grid. To Delete a Query Field: Click the top of the field you want to delete and press Delete. To Rearrange Fields: Position the pointer over the field and then click and drag the field to a new location. Sorting a Query Using Multiple FieldsTo Sort a Query Using Multiple Fields: Open/display the query in Design view, and, if necessary, add the field you want to use to sort the query to the design grid. Click the Sort box list arrow for the first field you want to use to sort the query and select a sort order. Repeat for each additional field you want to use to sort the query, bearing in mind that the fields will be sorted from left to right. Developing AND and OR OperatorsTo Create AND/OR Criteria: Open/display the query in Design view, enter your criteria in the appropriate field's first Criteria box. Enter additional criteria as follows: AND: Enter additional criteria for one or more fields in the appropriate field's Criteria box. All AND criteria should appear on the same row. OR: Enter additional criteria for one or more fields in the appropriate field's Criteria box, using a different row for each OR criteria. Creating a Form with the Form WizardTo Create a Form Using the Form Wizard: In the database window, click the Forms icon in the Objects bar and then double-click Create form by using wizard. Select the table or query you want to use to create your form, select the fields that you want to appear on the form, and click Next when you're finished. Select the type of form you want to create and click Next. Select a format for your form and click Next. Give your form a name and click Finish. Creating a Report with the Report WizardTo Create a Report Using the Report Wizard: In the database window, click the Reports icon in the Objects bar and then double-click Create reports by using wizard. Select the table or query you want to use to create your report and select the fields that you want to appear on the report. Click Next when you're finished. Select a field to group the report by and click Next (optional), then specify the field(s) you want to use to sort the report and click Next (also optional). Select a format for the report and click Next. Give your report a name and click Finish. Creating Mailing Labels with the Label WizardTo Create Labels: In the database window, click the Reports icon in the Objects bar, click the New button on the toolbar, select Label Wizard from the list and click OK. Select the table or query you want to use to create your labels, and click OK. Select the font you want to use for your labels and click Next. Select the product number for your labels and click Next. Select the fields that you want to appear on the report, enter any text, and click Next when you're finished. Double-click the field you want to use to sort your labels and click Next. Give your report a name and click Finish. Database Object ManagementTo Cut/Copy and Paste a Database Object: Select the database object, click the Cut button or Copy button on the toolbar, click the Paste button on the toolbar, enter a name for the new object, and click OK. To Rename an Object: Right-click the object, select Rename from the shortcut menu, and enter a new name for the object. To Delete an Object: Select the object and press the Delete key. File ManagementBasic File Management in the Open Dialog box: Open the Open dialog box by selecting File To Change How Files Are Displayed: Click the Views button list arrow and select a view. Compacting and Repairing a DatabaseTo Compact and Repair a Database: Select Tools Converting an Access Database To Convert an Access Database: Close the database you want to convert and select Tools Save. Click OK to acknowledge the warning message. Which of the following is NOT a step in planning a database? Determine the fields you'll need and their data type. Determine the tables you'll need. Use the Database Planning Wizard to help determine the structure of your database. Determine the purpose of the database: the information you want to put into it and the reports you want to come out of it. Which of the following statements is NOT true?
Which of the following is NOT a data type?
You can add a field to a query without displaying it in the query results. (True or False?) Which of the following statements is NOT true? (Select all that apply.)
The fastest and easiest way to create a form or report is with the Form Wizard or the Report Wizard. (True or False?) Microsoft Word is required in order to print mailing labels with Microsoft Access. (True or False?) Which two of the following statements are NOT true? (Select all that apply.)
What is the maximum length a text field can be?
What is the memo data type field used for?
Which of the following criterion would find records whose Personality field does not equal "Nice"?
What happens when you add the asterisk (*) from any Field List to a query?
You want to sort a query by a table's Last Name field. In order to do this, the Last Name field MUST appear in the displayed results of the query. (True or False?) Where do reports and forms get their information from? (Select all that apply.)
What is the first step in creating a form or report with the Form Wizard or Report Wizard?
Homework
Quiz Answers
|