MS Access uses “objects" to help the user list and organize information, as well as prepare specially designed reports. When you create a database, Access offers you Tables, Queries, Forms, Reports, Macros, and Modules. Databases in Access are composed of many objects but the following are the major objects −
Together, these objects allow you to enter, store, analyze, and compile your data. Here is a summary of the major objects in an Access database; TableTable is an object that is used to define and store data. When you create a new table, Access asks you to define fields which is also known as column headings.
QueryAn object that provides a custom view of data from one or more tables. Queries are a way of searching for and compiling data from one or more tables.
FormForm is an object in a desktop database designed primarily for data input or display or for control of application execution. You use forms to customize the presentation of data that your application extracts from queries or tables.
ReportReport is an object in desktop databases designed for formatting, calculating, printing, and summarizing selected data.
Other MS Access ObjectsLet us now take a look at other MS Access objects. MacroThis object is a structured definition of one or more actions that you want Access to perform in response to a defined event. An Access Macro is a script for doing some job. For example, to create a button which opens a report, you could use a macro which will fire OpenReport action.
ModuleModule is an object in desktop databases containing custom procedures that you code using Visual Basic. Modules provide a more discrete flow of actions and allow you to trap errors.
|