~    Rapid Development of Custom-Made Access Applications with FDGDatabase Prototype     ~

English – Basic Tutorial to maintain the Musicals Hits Application.

Tutorial Objective
To obtain the necessary basic knowledge to add, delete and edit fields in the tables and forms in this

and other Applications developed with FDGDatabase.

Prerequisites
This tutorial requires basic knowledge of Microsoft Access and be able to add, delete and edit fields in

tables and forms.

Steps to follow to complete this Tutorial

1. Download here Musicals Hits and familiarize yourself with the Applicacion.

2. Familiarization with the concepts included in this tutorial.

3. Modify the table and two forms of the application.
In this tutorial you do not need to create or delete tables or forms.

You only add, delete and edit fields in the following table and forms:
- Table ……………………….……….: tbl01table001
- Form (FormView)…………….…....: frmtbl01table001ExitosF
- Form (Datasheet View)……..…….: frmtbl01table001ExitosH

4. Run “Data Integrity Check” from the main menu

Application Functionality
The design used in this Application is only one of the many designs you can be develop.

                        Common Functionality of FDGDatabase Prototype

                        - Register the musicals hits and daily notes of the events
                        - Link all types of documents, images, sounds y videos.
                        - Show images and documents
                        - Play music and videos. It is integrated with Windows Media Player

~ Concepts – Format of the Tables in FDGDatabase ~

Application Table: Musicals Hits:
tbl01table001 – Musicals Hits Data


Format of the Tables required by FDGDatabase: Example: tbl01table001

                        tbl01tableNNN - NNN is the table number = 001, 002, 003, 004, etc.

                        The tables fields:
                        The tables fiels are statics, used by the program and cannot be modified:
                        Field1, Field2, Field3, etc.
                        In all tables, normally, Field1 is the Primary Key and Long Integer

                        The fields descriptions:

                        The fields descriptions are shown in the forms and can be modified any time in Access or in the

                        application.

                        Note: The table name is part of the form names with a short description that indicate its contents.

~ Concepts – Format of the Forms in FDGDatabase ~

Format of the Forms required by FDGDatabase: Examplo: frmtbl01table001ExitosF

frmTTTTTTTTTTTTTDDDDDDDDDDDDDB
TTTTTTTTTTT = Table (tbl01table001)
DDDDDDDDDDDDD = Contents Description (Exitos)

B = The letter F indicates “FormView”

The names of the fields and labels in the forms:

                        - Field names: Field1, Field2, Field3, etc.
                        - Label names: lbField1, lbField2, etc.

Application Form Musicals Hits:
                        Form: frmtbl01table001ExitosF - “FormView”

Application Form Musicals Hits:

Form: frmtbl01table001ExitosH – Datasheet View

~ Concepts – Data Integrity Check ~

Always run “DataIntegrity Check” when you have problems with the application or you have modified the

tables or forms

This function checks the modifications done and refresh the comun functionality of the application.