Various components of the database window
A database is in the form of a container or window, in which similar objects in the database are grouped together. The database window consists of several tabs. Database tables and other objects are stored under different tabs, the object to be created is selected from the database window. Below is a brief introduction to the various components of the database window.
Tables: The tables are stored under this tab. From here a table can be changed, modified, or a new database created. Queries: From this tab you can get the list of all the queries in the current database. From here one can manage a query, change the query, modify it or create a new query.
Forms: All reports and forms of the current database can be found from this tab. From here a report can be modified or a new report can be created.
Report: Report is to display or print the information in the format as desired by the users.
Page: Database Access page can be created to work with data stored in Microsoft Access or SQL Server on the Internet or Intranet. -
Macro: A macro is a type of small program. Clicking on this tab will list all the macro programs in the current database. From here one can modify a macro or create a new macro.
Module: One or more procedures of the program is called a module. Clicking on the Module tab will provide a list of programming modules in the current database. From here the required code can be written or modified. The Visual Basic editor is used to write the code.
Comments
Post a Comment