Show how to create a new database.

Here are the steps for each task in MS Access: Step 1: Show how to create a new database. To create a new database, open Access, then select File > New. You can choose a blank desktop database or select a template. Give your database a name and click Create. Step 2: Describe how to create a table. To create a table, open your database, go to the Create tab, and click Table. Access will open a new table in Datasheet View. You can then add fields and data. For more control, switch to Design View. Step 3: Explain how to define fields. To define fields, open your table in Design View. For each field, enter a Field Name (e.g., "CustomerID", "ProductName") and select a Data Type (e.g., "Short Text", "Number", "Date/Time"). You can also add a description and set field properties. Step 4: Show how to set a primary key. To set a primary key, open your table in Design View. Select the field you want to designate as the primary key (it must contain unique values). On the Design tab, click the Primary Key button. A key icon will appear next to the field name. Step 5: Describe how to enter records. To enter records, open your table in Datasheet View. Click on the first empty row (marked with an asterisk) and start typing data into each field column. Press Tab or Enter to move to the next field or record. Step 6: Explain how to create a form. To create a form, select the table or query you want to base the form on in the Navigation Pane. Go to the Create tab, then click Form. Access will automatically generate a basic form. You can then customize it in Layout View or Design View. Step 7: Show how to create a query. To create a query, go to the Create tab, then click Query Design. Add the tables or queries you want to use. Drag fields from the tables to the design grid. Set criteria, sort order, or other parameters, then click Run to see the results. Step 8: Describe how to filter data. To filter data in a table, form, or query result, click the dropdown arrow next to a field header. Select specific values to show, or use Text Filters, Number Filters, or Date Filters to apply more complex conditions. Step 9: Explain how to sort records. To sort records in a table, form, or query result, click the dropdown arrow next to the field header you want to sort by. Choose Sort A to Z (ascending) or Sort Z to A (descending). You can apply multiple sorts by sorting the leftmost field first, then subsequent fields. Step 10: Show how to create a report. To create a report, select the table or query you want to base the report on in the Navigation Pane. Go to the Create tab, then click Report. Access will automatically generate a basic report. You can then customize it in Layout View or Design View. Step 11: Describe how to establish relationships. To establish relationships between tables, go to the Database Tools tab, then click Relationships. Drag tables from the Show Table dialog onto the Relationships window. Drag the primary key field from one table to the foreign key field in another to create a relationship. Step 12: Explain how to import data. To import data, go to the External Data tab. In the Import & Link group, choose the source type (e.g., New Data Source > From File > Excel). Follow the wizard to select your file, specify options, and import the data into a new or existing table. Step 13: Show how to export data. To export data, select the object (table, query, form, or report) you want to export in the Navigation Pane. Go to the External Data tab. In the Export group, choose the destination type (e.g., Excel, PDF, Text File). Follow the wizard to specify options and save the exported file. Step 14: Describe how to run queries. To run a query, open the query in Design View and click the Run button (exclamation mark icon) on the Design tab. Alternatively, double-click the query name in the Navigation Pane to run it directly and display its results. Step 15: Explain how to validate data. To validate data, open your table in Design View. For a specific field, use the Validation Rule property to set criteria (e.g., >0 for numbers, Like "???" for text). Use the Validation Text property to provide a message if the rule is violated. Step 16: Show how to edit records. To edit records, open your table or form in Datasheet View or Form View. Click on the field you want to change and type the new data. Access automatically saves changes as you move to another field or record. Step 17: Describe how to delete records. To delete records, open your table or form in Datasheet View or Form View. Select the entire record (click the record selector on the left). Press the Delete key or right-click and choose Delete Record. Confirm the deletion when prompted. Step 18: Explain how to backup a database. To backup a database, go to File > Save As. Under Database As, select Backup Database, then click Save As. Choose a location and name for your backup file, then click Save. Step 19: Show how to compact and repair database. To compact and repair a database, close the database you want to repair. Open Access, but do not open any database. Go to File > Info > Compact & Repair Database. Select the database file you want to compact and repair, then click Compact. Step 20: Describe how to use lookup fields. To use lookup fields, open your table in Design View. For the field you want to be a lookup field, set its Data Type to Lookup Wizard. Follow the wizard to specify whether the field should look up values from another table/query or from a list of values you type. 3 done, 2 left today. You're making progress.