MS Access stores all database tablets, queries, reports, forms, macros and modules in the Access Jet database as a simple file.
For query development MS Access offers a Query Designer a graphical user interface that allows users to build queries without knowledge of the SQL programming language, in the Query Designer users can show the data sources of the query and select the field they want returned by clicking and dragging them into the grid, one can set up joins by clicking and dragging fields in tables to field in other tables, Access allows users to view and manipulate the SQL code if desired, any Access table including linked tables from different data sources can be used in a query.
It offers several ways to secure the application while allowing users to remain productive.
Most basic is a database password, once entered then user has full control of all database objects, this is a relatively weak form of protection which can be easily cracked, a higher level of protection is use of workgroup security requiring a user name and a password. Users and groups can be specified along with their rights at that object type or individual object level, this can be used to specify people with read-only or data entry rights but may be challenging to specify.
If you want to create a Microsoft Access Field for Hyperlinks then following are steps to that.
You can open a table in Design view then click in the field directly underneath the location that is to contain your new hyperlink field.
Now you can click on the Insert Row icon in the Toolbar or you can open the Insert menu and then choose Row after that a new Row appears. Now, in this new Row window, select the Hyperlink option.
You can also open the table in Data sheet view for that you can open Hyperlink Column and a new column will appear, when columns appear move your column to the location you want. You can now just enter Hyperlinks in your new fields.
Above mentioned steps is to create a Microsoft Access Field for Hyperlinks.