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...
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 that
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...
[Avast] Manual virus database's update ShowIf your computer doesn't have Internet connexion, you can make a manual avast definitions update :
Download the latest VPS update on a USB key.
Run the vpsupd.exe file on the concerned computer.
Download Database Editor ShowThe database management is a complex task, for the experimented users in general. For a specific task, specific tools are needed.
Database editor is a tool allowing fast and easy access to any sorts of database. It will help database developers and...
Networking - 3-Tier Client/Server Architecture ShowIntroduction to 2-Tier Architecture
2-tier architecture is used to describe client/server systems where the client requests resources
and the server responds directly to the request, using its own resources. This means that the server does not...
Client/Server Environment ShowIntroduction to Client/Server Architecture
Numerous applications run in a client/server environment, this means that client computers
(computers forming part of the network) contact a server, generally a
very powerful computer in terms of...
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...