What Development Is Done In Microsoft Access?

Access permits relatively sharp development reason is that all database tables, queries, report and forms are saved in the database. For query development, Access uses the Query Design Grid, a graphical user interface that permits users to make queries without any know how of the SQL programming language. In the Query Design Grid, programmer can show the source tables of the query and chose the fields they require to  send back by clicking and dragging them into the grid. Joins can be made by clicking and dragging fields in tables to fields in other tables. Access permits users that if require they can  see and arrange the SQL code.

The facility of the programming language is also find in Access, Two libraries of  database access of COM components are given:
1) the legacy Data Access Objects (DAO),it is  only available with Access.
2) and the new ActiveX Data Objects (ADO).
Access can be used to small projects easily but scales badly to larger projects including many concurrent users reason is that it is not a true client server database actually it is a desktop application.

Since all database queries, forms, and reports are stored in the database, and in keeping with the ideals of the relational model, there is no possibility of making a physically structured hierarchy with them.

One design method is to distribute an Access program between data and programs. One database should keep only tables and relationships, while another would keep all programs, forms, reports and queries, and connects to the table of first database. Developers use this devision for more then one user mission-critical programs.
Access do not permits any similar way when linking because of it the environment of creation muct have the same way.