120 likes | 415 Views
Databases. Flat FileAll information kept in one tableRelationalRedundant information kept in separate tables that populate drop down menus in other tables. (Main Table)Examples: States, Countries, Companies, etc. . Flat File Databases. ExcelAccess. Relational Databases. Primary Keys. Unique identifier for each record in the database. .
E N D
1. Displaying Interactive Access Database Information in a FrontPage Web Brenda KerrInstructional Technology Specialist
Faculty Instructional Technology Center
MTSU: Information Technology Division
2. Databases Flat File
All information kept in one table
Relational
Redundant information kept in separate tables that populate drop down menus in other tables. (Main Table)
Examples: States, Countries, Companies, etc.
3. Flat File Databases Excel
Access
4. Relational Databases
5. Primary Keys Unique identifier for each record in the database.
6. Look Up Fields Populated by another table in your database
7. FrontPage and Databases Form can store submissions in a database:
Created Automatically by FrontPage through Form Properties (Flat File – Easiest)
Created by you and then linked to the form. Through Form Properties or the Database Interface Wizard (Relational or Flat File)
8. FrontPage and Databases Database Results Wizard
9. Database Interface Wizard
10. Database Interface Wizard
11. Database Editor, Submission Form, and Results Page
12. Active Server Pages One type of file used to access database information on the web
“.asp” file extension
FrontPage prompts you to save all database populated pages as “.asp” files.