Access is a general front end program which comes with Microsoft for client database. Microsoft Access is useful for the users in managing, retrieving, and organizing data. This also helps very large corporate to small businessmen in indexing and other DBA related functions. This program can perform many difficult calculations and organize information. This is an advanced UI and very easy to access. It is very sensitive; hence, it displays most of the needed commands while working. You have to follow some steps to use this program ko cuce.
First, you have to remember that this is not a database; instead, this is a tool for managing DBA. When you run Access, you will get an open tab option. From that, select the option so that a dialogue box will appear and you can select your database file by browsing through it. After that, click on the open database connectivity from the dialogue box. You can also connect to a MySQL in the same way.
The remarkable feature of the program is that it can create interactive reports. This program can create all sorts of reports based on the information available in the database. Managing table is the process of creating, removing and changing the fields of a table. This needs a vast knowledge of SQL, but in Access you don't need SQL knowledge to manage the tables. This is an easy GUI. A table can be created just by double clicking on the create table.
Further, you cannot delete a linked table. You can only delete the link to the table. But you can edit and add data on a remote server. Another tool available in this is report utility. You can create reports according to your will, wish and specifications.
Finally, one can attach and host many external files like audio files, text files, spreadsheets, and presentations. The web collaboration feature allows you to share the database with many users at the same time. This is also featured with security protocols for security of the users. The user can lock specific files from the unauthorized viewers.
No comments:
Post a Comment