how to create a database in Ms access?
Answers
Answered by
7
Creating a database
When you open Access, Backstage view displays the New tab. The New tab provides several ways that you can create a new database:
A blank database You can start from scratch if you want. This is a good option if you have very specific design requirements or have existing data that you need to accommodate or incorporate.
A template that is installed with Access Consider using a template if you are starting a new project and would like a head start. Access comes with several templates installed by default.
A template from Office.com In addition to the templates that come with Access, you can find many more templates on Office.com. You don't even have to open a browser, the templates are available from the New tab.
Adding to a database
Once you are working in a database, you can add fields, tables or application parts.
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.
Create a database by using a template
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.com. See the next section in this article for details.
Select the template that you want to use.
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.
NOTE: Although they both use SharePoint, a desktop database linked to a SharePoint site is not the same as a web database using Access Services. To use a desktop database, you must have Access installed. A web database can be used with a web browser.
Click Create.
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.
Top of Page
Create a database without using a template
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.
Importing data from other sources and creating new tables in the process.
When you open Access, Backstage view displays the New tab. The New tab provides several ways that you can create a new database:
A blank database You can start from scratch if you want. This is a good option if you have very specific design requirements or have existing data that you need to accommodate or incorporate.
A template that is installed with Access Consider using a template if you are starting a new project and would like a head start. Access comes with several templates installed by default.
A template from Office.com In addition to the templates that come with Access, you can find many more templates on Office.com. You don't even have to open a browser, the templates are available from the New tab.
Adding to a database
Once you are working in a database, you can add fields, tables or application parts.
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.
Create a database by using a template
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.com. See the next section in this article for details.
Select the template that you want to use.
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.
NOTE: Although they both use SharePoint, a desktop database linked to a SharePoint site is not the same as a web database using Access Services. To use a desktop database, you must have Access installed. A web database can be used with a web browser.
Click Create.
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.
Top of Page
Create a database without using a template
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.
Importing data from other sources and creating new tables in the process.
Answered by
9
Database:-
- A database is an organised collection of data or information. It helps access and update data easily. A database has different elements.
• Tables: Tables are used to store data in the form of rows and columns.You can add and rename columns. You can also specify the data type for each column.
• Forms: These are used to collect data from the user. You can create different types of forms like admission forms in Microsoft Access. You can fill data in the form, which is then analysed and stored in the database.
• Reports: Reports are used to display the data stored in different tables. A common example of reports is a student's progress report.
• Queries: These are used to get information that meet certain criteria. You can use queries to answer questions regarding the data stored in a table. You can also use queries to create a new table from the existing tables.
• Relationships: These help you combine data from two different tables. You can create relationships among the common fields of two tables. You need to start Microsoft Access to create a database. You can access Microsoft Access 2010 from the Start menu. You can either create a blank database or use sample templates.
To create a Database :-
- Click the start button
- On the left pane, click All programs option.
- Scroll down and click Microsoft office.
- Click the microsoft access 2010.
- On the middle pane, under the Available templates section, click the Blank Database icon.
- On the right pane, under the file name section , enter the required name.
- On the right pane, click the Create icon.
Similar questions