Data management software compatible with MS Access data tables and queries. Includes single click automatic form and report creation component based querying (column views sort orders filter selection) and VB Script macr...
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...
Introduction - Databases ShowWhat is a database?
A database (abbreviated DB) is an entity in which data can be stored in a structured manner, with as little redundancy as possible. Different programs and different users must be able to use this data. Therefore, the concept of...
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...
Database Replication ShowIntroduction to Replication
Replication consists in ensuring data availability by synchronising copies of a data source on different servers.
Replication is mainly used for database management systems that manage thousands or even millions of...