What is Microsoft Access 2010? What are the steps to start Microsoft Access 2010.
Answers
Answer:
Access 2010 is a database application design and deployment tool that you can use to keep track of important information. You can keep your data on your computer, or you can publish to the Web — so others can use your database with a web browser.
Many people start using Access when the program that they are using to keep track of something gradually becomes less fit for the task. For example, suppose you are an event planner, and you want to keep track of all the details that you need to manage to make your events successful. If you use a word processor or spreadsheet program to do this, you can easily run into trouble with duplicate and inconsistent data. You can use calendaring software, but tracking financial information in a calendar isn't a good fit.
Explanation:
Find and apply a template
To find and apply a template to your database, do the following:
On the File tab, click New.
Under Available Templates, do one of the following:
To reuse a template that you’ve recently used, click Recent Templates, and then select the template that you want.
To use a template that you already have installed, click My Templates, and then select the template that you want.
To find a template on Office.com, under Office.com Templates, click a template category, select the template that you want, and then click Download to download the template from Office .com to your computer.
You can also search for templates on Office.com from within Access. In the Search Office.com for templates box, type one or more search terms, and then click the arrow button to search.
Optionally, click the folder icon next to the File Name box to browse to a location where you want to create the database. If you don't indicate a specific location, Access creates the database in the default location that is displayed below the File Name box.
Click Create.
Create a database from scratch
If you want a more thorough introduction to the concepts behind using Access to create a database, see the article Database design basics.
If none of the templates fits your needs, or if you have data in another program that you want to use in Access, you may decide that it is better to create a database from scratch. In Access 2010, you have a choice: a standard desktop database, or a web database.
For more information about web databases, see the article Build a database to share on the Web.
To create a new database, do the following:
Start Access.
On the New tab in Backstage view, click Blank Database or Blank Web Database.
Important: The choice that you make here will determine what features are available in the database. Desktop databases cannot be published to the Web, and web databases do not support some desktop features, such as totals queries.
On the right, type a name for your database in the File Name box.
To change the location in which you create the file, click Browse Button image next to the File Name box, browse to and select the new location, and then click OK.
Click Create.
Access creates the database, and then opens an empty table (named Table1) in Datasheet view.
Access puts the cursor in the first empty cell in the Click to Add column of the new table.
To add data, begin typing — or you can paste data from another source, as described in the section Paste data from another source into an Access table, later in this article.
Notes:
Entering data in Datasheet view is designed to be very similar to entering data in an Excel worksheet. The main restriction is that data must be entered in contiguous rows and columns, starting at the upper-left corner of the datasheet. You should not try to format your data by including blank rows or columns as you might do in an Excel worksheet, because doing so will waste space in your table. The table merely contains your data. All visual presentation of that data will be done in the forms and reports that you design later.
The table structure is created while you enter data. Any time that you add a new column to the datasheet, a new field is defined in the table. Access sets the data type of the field based on the type of data that you enter. For example, if you have a column in which you have entered only date values, Access will set the data type of that field to Date/Time. If you later attempt to enter a non-date value (such as a name or a phone number) in that field, Access displays a message informing you that the value does not match the data type of the column. When possible, you should plan your table so that each column contains the same type of data, whether it is text, dates, numbers, or some other type.
Explanation:
इन इन एक्सेस 210 10 टेंप्लेट कैन वी डाउनलोड फ्रॉम office.com ट्रू या फॉल्स