Make database software

This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback? Note The Use full-text indexing option is always checked and dimmed because, beginning in SQL Server , all user databases are full-text enabled.

Submit and view feedback for This product This page. View all page feedback. In this article. Application parts are a feature that let you use several related database objects together as if they were one. For example, an application part might consist of a table and a form that is based on the table.

You can add the table and the form at the same time by using the application part. You can also create queries, forms, reports, macros - all the database objects that you are used to working with. Access comes with a variety of templates that you can use as-is or as a starting point. A template is a ready-to-use database that contains all the tables, queries, forms, macros, and reports needed to perform a specific task.

For example, there are templates that you can use to track issues, manage contacts, or keep a record of expenses. Some templates contain a few sample records to help demonstrate their use.

If one of these templates fits your needs, using it is usually the fastest way to get a database started. However, if you have data in another program that you want to import into Access, you might decide it is better to create a database without using a template. Templates have a data structure already defined, and it might require a lot of work to adapt your existing data to the template's structure.

If you have a database open, on the File tab, click Close. Backstage view displays the New tab. Several sets of templates are available in the New tab, some of which are built into Access.

You can download additional templates from Office. See the next section in this article for details. Access suggests a file name for your database in the File Name box — you can change the file name, if you want.

To save the database in a different folder from the one displayed below the file name box, click , browse to the folder in which you want to save it, and then click OK. Optionally, you can create and link your database to a SharePoint site. Access creates a database from the template that you chose, and then opens the database. For many templates, a form is displayed in which you can begin entering data. If your template contains sample data, you can delete each record by clicking the record selector the shaded box or bar just to the left of the record , and then doing the following:.

On the Home tab, in the Records group, click Delete. To begin entering data, click in the first empty cell on the form and begin typing. Use the Navigation Pane to browse for other forms or reports that you might want to use. Some templates include a navigation form which allows you to move between the different database objects. For more information about working with templates, see the article Use a template to create an Access desktop database.

If you are not interested in using a template, you can create a database by building your own tables, forms, reports, and other database objects. In most cases, this involves one or both of the following:. Entering, pasting, or importing data into the table that is created when you create a new database, and then repeating the process with new tables that you create by using the Table command on the Create tab.

On the File tab, click New , and then click Blank Database. Type a file name in the File Name box. To change the location of the file from the default, click Browse for a location to put your database next to the File Name box , browse to the new location, and then click OK. Access creates the database with an empty table named Table1, and then opens Table1 in Datasheet view.

The cursor is placed in the first empty cell in the Click to Add column. Begin typing to add data, or you can paste data from another source, as described in the section Copy data from another source into an Access table.

Entering data in Datasheet view is designed to be very similar to working in an Excel worksheet. The table structure is created while you enter data. When you add a new column to the datasheet, a new field is defined in the table.

Access automatically sets each field's data type, based on the data that you enter. If you do not want to enter data in Table1 at this time, click Close. If you made any changes to the table, Access prompts you to save the changes. Click Yes to save your changes, click No to discard them, or click Cancel to leave the table open.

Tip: Access looks for a file named Blank. If it exists, Blank. Any content it contains is inherited by all new blank databases. This is a good way to distribute default content, such as part numbers or company disclaimers and policies. Important: If you close Table1 without saving it at least once, Access deletes the entire table, even if you have entered data in it.

You can add new tables to an existing database by using the commands in the Tables group on the Create tab. Create a table, starting in Datasheet view In Datasheet view, you can enter data immediately and let Access build the table structure behind the scenes. Field names are assigned numerically Field1, Field2, and so on , and Access automatically sets each field's data type, based on the data you enter.

On the Create tab, in the Tables group, click Table. Access creates the table and selects the first empty cell in the Click to Add column. If you don't see the type that you want, click More Fields. Access displays a list of commonly used field types. Click the field type that you want, and Access adds the new field to the datasheet at the insertion point. You can move the field by dragging it. When you drag a field in a datasheet, a vertical insertion bar appears where the field will be placed.

To add data, begin typing in the first empty cell, or paste data from another source, as described in the section Copy data from another source into an Access table. You should give a meaningful name to each field, so that you can tell what it contains when you see it in the Field List pane. To move a column, click its heading to select the column, and then drag the column to the location that you want. You can also select multiple contiguous columns and then drag them to a new location all at once.

To select multiple contiguous columns, click the column header of the first column, and then, while holding down SHIFT, click the column header of the last column. Create a table, starting in Design view In Design view, you first create the table structure. Whether you want a dashboard with sales and service figures, project status update screens, a web page with a subscription form, or an invoice template with your vendor's details prefilled and ready to print, you can design pages that are as focused or as broad as you want.

All database-backed apps you build on Zoho Creator automatically connect with each other. You can also enable team-wide access to specific components of your online database, and limit access controls and define permissions by roles.

Represent your data in a variety of ways: kanban, spreadsheet, list, calendar, pivot, and timeline views, to name a few. Each view includes options to sort, filter, and group data, while also allowing you to export and print your records rows.

You can even display your data: Just choose our design templates or create your own. Automate tedious tasks, like sending scheduled emails and reports. Your workflows can run with or without conditions, or they can add, delete, or update information in your database based on custom actions you define. You can also set processes by day and time or by organization-wide approval. Create online databases on your own Create and manage your databases on our cloud-based platform.

Watch a video Get Started. Create your database now. What is Zoho Creator's online database platform It's an innovative software that lets you build, migrate, and manage your databases with the help of its intuitive drag-and-drop features.