MS Access ppt for you my student -1.pptx

Just see

1. MS Access Unit-5

2. MS-Access  is application software for managing the databases. It is released by  Microsoft  in November 1992. It actually stores the data on the basis of the  relational Jet Database Engine . It mainly provides the graphical user interface for accessing the data and the tools for software development. It helps the users for managing the related data more efficiently than Microsoft Excel or other applications of spreadsheets. Users can easily analyze the large amount of data stored in it. It is not used to create large or enterprise-level databases but mainly used to create small databases. For the large databases, Microsoft provides the SQL server database engine.

3. Uses of MS Access Those users who have a basic knowledge of computers can easily create and manage the database in Access. It is a software program which can be used in schools for making the schedules. Any user can easily insert the data in the database of MS Access. It is also used to create user-friendly front ends. In MS-Access, repetitive tasks can be easily performed by the help of macros. Any user can access the data or information quickly with the help of commands. It allows users for developing web applications. Various software developers also use this software for developing the application software. This software works with the SQL Server, DB2, and Oracle databases. Because these three databases support the (ODBC) standard. Any user can easily import data from and export data to word processing files, or spreadsheet files.

4. It is also used to link directly to those data which is stored in following different databases and applications: Microsoft Excel Text Hypertext Mark-up Language (HTML) dBase Extensible Mark-up Language (XML) Paradox Oracle Microsoft SQL Server Postgre SQL MySQL.

5. Features of MS Access Any user can easily create the framework (i.e. tables) which stores the data or information in the database. There is a  Tell Me Function  in MS Access, which allows you to create queries, tables, reports, and forms easily. Any user can easily  import  the information in the created table of MS Access from the other applications of Microsoft. The users who work with MS Access can easily create a  report  from the table which is selected by them. For creating a report, users need to click on the  Report Wizard  icon available in the toolbar. One of the important features of  MS Access  is  Forms . Another important feature of MS Access is the  template . Any user can use the templates which are available in software MS access.

6. Queries  can also be considered as an essential feature of MS Access. It helps for processing the data in the tables, and for displaying the data to the users. Microsoft Access 2010 introduced the new feature which allows the users to publish the web databases to SharePoint sites, after developing them. A powerful feature also exists in this application software. This feature helps the developers by creating custom solutions for their databases using the  VBA (Visual Basic Application)  Code. The users who work with Microsoft Access can easily view their reports in following different ways: Print preview Design View Layout View Report View It also introduced the multi-valued fields. This feature allows you to select and store more than one values in one field.

7. The major components of MS Access are as follows: Tables Queries Relationships Macros Forms Reports Module

8. Benefits and Limitations of using MS Access Benefits : Easy to create database within lesser time duration Used a very comprehensive programming language which made it user friendly With each revised version, new options and features were made available to the users for their convenience It is easy to install and then easy to understand its working Importing data was easy Graphical user interface made it easy to use Limitations: Not too many people can use the same database at a single time. This may affect its speed and efficiency The same database was tough to use with different Operating systems Better database systems can be used for confidential data