What is the feature of MS Access 2010?

What is the feature of MS Access 2010?

In Microsoft Access 2010, you can build web databases and publish them to a SharePoint site. SharePoint visitors can use your database application in a web browser, using SharePoint permissions to determine who can see what.

How do you create a table in Access 2010?

Create a new table in an existing database

1. Click File > Open, and click the database if it is listed under Recent. If not, select one of the browse options to locate the database.
2. In the Open dialog box, select the database that you want to open, and then click Open.
3. On the Create tab, in the Tables group, click Table.

What does Microsoft Access 2010 database contains?

Databases in Access 2010 are composed of four objects: tables, queries, forms, and reports. Together, these objects allow you to enter, store, analyze, and compile your data however you want.

What is the main purpose of MS Access?

Microsoft Access is an information management tool, or relational database, that helps you store information for reference, reporting and analysis. Access can also overcome the limitations found when trying to manage large amounts of information in Excel or other spreadsheet applications.

How do you create a database and table in Access 2010?

In Access 2010, you can create a new database by clicking the “File” tab in the Ribbon. Then click the “new” command. Then select the “Blank database” choice in the “Available Templates” section.

What can I do with Microsoft Access 2010?

Microsoft Access 2010 is a powerful relational database program that includes hundreds of tools you can use to quickly start tracking, sharing, and reporting information, even if you are new to database development.

What can you do with Microsoft Access advanced features?

Advanced features allow you to create sophisticated executable database applications that your employees and customers can use to gather and view data without needing to know anything at all about database design or development. This book gives you straightforward instructions for using Access to create databases.

What kind of database is Microsoft Office access?

Microsoft Office Access 2010—a relational database—is made up of groups of related data stored in individual tables. Users can selectively combine pieces information from any or all of those tables through a process known as querying.

What do I need to know about Microsoft Access?

Access supports sharing data with other sources, including other Microsoft Office 2010 programs, Microsoft SQL Server, Windows SharePoint Services, and documents in XML, HTML, XPS, and PDF formats.