Use database file locations from template

If you use Microsoft Outlook, you can add contacts from that program without having to re-type the information. In the Select Names to Add dialog box, select the names that you want to add to the database. The Quick Search box lets you quickly find a contact on the Contact List form. Access filters the list to show only those records that contain the text you searched for. To return to the full list, click Clear the current search. It's the X inside the search box. On the Contact List form, some fields columns are hidden by default.

To change which fields are displayed:. In the Unhide Columns dialog box, select the check box beside each column that you want to show. Clear the check box to hide the column. The Contact Details form lets you see and enter more information about each contact. To display the Contact Details form:. On the Contact List form, click Open next to the contact that you want to see. Note: You can attach multiple files to each contact, including different file types such as documents or spreadsheets.

On the Contact Details form, if you have entered a street address for the contact, you can display a map of that location:. To display a report:. In the Navigation Pane, under Reports , double-click the report you want to display. You can create your own custom reports. In the SID box enter the database name. Then click Next. Database Configuration Assistant - Database Credentials In the next step you specify the storage type and storage locations for the database files. You can choose one of the following option for storage location - Use Database File Locations from Template - The file locations specfied in the template are used.

Use Oracle Managed Files - With this option you only specify a default location and Oracle database will take care of the management of the database files by itself. Selet one option and click Next. Database Configuration Assistant - Database File Locations In the Recovery Configuration screen you can specify a location to store and manage file related to backup and recovery such as redo logs, archive logs etc.

Click Next. Memory Use this tab to specify memory management methods. Typical - Using the slider you can select the percentage of physical memory that should be allocated. Custom - Lets you specify advanced memory configurations. Sizing In this tab you can specify the block size and the maximum number of operating system user processes that can be simulataneously connected to this database.

Right-click the template you created, and then select Edit. The New Query Window opens. The best way to get acquainted with SSMS is through hands-on practice. These tutorial and how-to articles help you with various features available within SSMS.

These articles teach you how to manage the components of SSMS and how to find the features that you use regularly.

Skip to main content. This browser is no longer supported. Download Microsoft Edge More info.