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...
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...
VNC – Remote Assistance ShowVNC – Remote Assistance
Intro
Implemetation
Links
Via a Website
Intro
VNC which means VIRTUAL NETWORK COMPUTING is a software which allows you to do Remote Assistance / Remote Desktop. The other user must have VNC also installed...
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...
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...
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...