Database VE is a database application. It allows you to view, add, edit, import, export XML files, to delete data from MS Access base. You can sort the data while clicking the column heading; perform a general or column research. You can search in a column or enter SQL queries. A grid allows data change and you can print a selected data. The software is a demo version which expires after 30 days of use.
Database administrator ShowDatabase administrator
A database administrator (or DBA for short) is in charge of maintaining and operating the databases which form a company's information system. Skills
Given the critical nature of the data he/she is in charge of, the...
Databases - Using forms ShowUsing forms
In order to use databases, the user must be provided with an interface that allows him or her to view data based on certain criteria. There is a tool for this: forms. A form is an interface with components for displaying, entering, or...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel
Below is a tips of how to connect an Access database (MDB) in an application excel
Add reference
Microsoft DAO object librairy X.X
In a general module (eg Module1) paste the code below...
Backup/Restore Mysql database ShowBackup/Restore Mysql database
Backup
Restore your database
Note
A simple approach on how to backup and restore MySQL databases.
Backup
To save an existing database it is recommended that you create a dump.
To dump all...
Automatic backup of a Database in SQL EXPRESS 2005 ShowAutomatic backup of a Database in SQL EXPRESS 2005
If you want to automate a backup of a database in SQL Server Express, there is a simple solution using a .bat. file.
Create a new text file. This file should contain the following...
Start a database with a missing data file ShowStart a database with a missing data file
In order to start an Oracle database with a misssing data file:
First get connected to SQL*DBA or Server Manager and run "shutdown abort"
Run startup mount
Run the following...
DBMS models ShowThe various database models
Databases appeared in the late 1960s, at a time when the need for a flexible information management system had arisen. There are five models of DBMS, which are distinguished based on how they represent the data...
ODBC ShowWhat is ODBC?
ODBC stands for Open Database Connectivity. This is a Microsoft-defined format for communicating between Windows database clients and consumer DBMSs. The ODBC managier can be found in Windows 3.1 and 9x. In Windows 95 and 98, it is...
SQL injection attacks ShowSQL Injection
SQL injection attacks are attacks against websites that rely on relational databases.
In this type of site, parameters are passed to the database in the form of an SQL query. As such, if the designer does not verify the parameters...