MS ACCESS 2007 VBA PROJECT

This visual basic for application project was done using MS ACCESS 2007

Handling Relational Database

By using Access 2007 relationship we integrated more than one table and formed a relational database, where the primary key of the main database table is related with all the other tables as foreign key. So records can be added to the specific tables when needed by using the foreign key.

Handling Multiple Tables with Single Form

Multiple access tables are manipulated from a single form. Each table is represented in the form by adding a separate page for that table in the form. All these table data can be inserted or updated or deleted from the single form. Table fields can be passed from one form to another form dynamically. Using sql query table fields are fetched from one form and populated to another form dynamically.

Using ActiveX Component DBPix for Image Processing

The image field is stored as OLE image field in the table which stores the raw binary data of the image. The ActiveX add-on called DBPix is used to add images to image field. The image field is added to the thumbnail field using the embedded image technique of the ActiveX Component DBPix.

Ms access Reports

All the reports present in the current project are retrieved dynamically and displayed in the Forms. Reports can be pointed to specific tables in the relational database. Reports can be print previewed and then can be printed using the print options.

Ms access Search Form

Database table Records can be searched dynamically by any fields in the table and results are displayed. Database records can be searched for a given criteria from the search form by using queries and the matching results are displayed in the user form where all the details related to the record are viewed.

Validating the Form Fields

Form fields are validated for Mandatory data, datatype etc. Validation can be done in table for mandatory fields. Validations can also be done for all the fields in the form itself when the datas are submitted.