MABS 405:Steps For Data Base Calculations

Steps For Database Calculations

  • OPEN ACCESS DATA BASE.
  • CLICK THE TABLE OBJECT. GO TO THE DESIGN VIEW.
  • ADD THE TABLE STRUCTURE (fields you require).
  • SAVE THE TABLE.
  • GO TO THE DATASHEET VIEW (records view).
  • ENTER SOME RECORDS.
  • CHECK THE FIELDS AND RECORDS.
  • CLICK THE QUERY OBJECT. CLICK THE QUERY WIZARD. THE WIZARD WILL GUIDE YOU THROUGH THE CONSTRUCTION OF THE QUERY. SAVE THE QUERY.
  • OPEN THE QUERY IN DESIGN VIEW (if it is not already opened).
  • PLACE THE CURSOR IN THE FIRST EMPTY COLUMN TO THE RIGHT. THIS IS THE INSERTION POINT.
  • CLICK THE BUILD BUTTON ON THE TOOLBAR AT THE TOP.
  • CREATE THE FORMULA(S) YOU REQUIRE. YOU MUST KNOW HOW TO CREATE YOUR INITIAL FORMULA(S). CLICK OK.
  • CLICK THE SQL VIEW FROM THE VIEWS LOCATED THE LEFT OF THE SAME TOOLBAR THAT CONTAINS THE BUILD ICON.
  • SELECT THE SQL CODE FROM THE DATABASE QUERY.
  • COPY THE SQL CODE TO TH CLIPBOARD.
  • CLICK FILE, CLICK NEW, CLICK WEB, CLICK A ONE PAGE WEB (THIS WILL CREATE A WEB PAGE), OR OPEN YOUR OWN WEB PAGE (CLICK FILE, CLICK OPEN WEB).
  • CLICK FILE, CLICK IMPORT AND IMPORT THE DATABASE YOU CREATED INTO FONT PAGE. PLACE IT IN THE FPDB FOLDER.
  • ADD THE DATABASE CONNECTION FROM THE DIALOG BOX. NAME THE DATABASE CONNECTION.
  • CREATE A NEW PAGE IN FRONT PAGE.
  • CLICK INSERT, CLICK DATA BASE, CLICK RESULTS FROM FRONT PAGE.
  • THE DATABASE RESULT WIZARD (1-5) WILL APPEAR IN SEQUENCE.
  • CHECK, USING AN EXISTING DATA BASE CONNECTION.
  • SELECT A TABLE FROM THE CONNECTION LIST.
  • SELECT A TABLE FROM RECORD RESOURCE LIST.
  • CLICK THE CUSTOM QUERY BUTTON.
  • CLICK EDIT.
  • PASTE THE SQL CODE, USING THE CLIPBOARD TAB. (THIS IS THE SQL CODE YOU PREVIOUSLY COPIED TO THE CLIPBOARD.)
  • CLICK THE VERIFY QUERY TAB.
  • NOW THE SQL CODE IS PASTED/VERIFIED AND POSTED THE THE CUSTOM ENTRY IN THE DIALOG BOX.
  • CHOOSE THE FIELDS AND FORMAT YOU WANT CONCERNING THE DATABASE RESULTS, AS YOU GO THROUGH THE WIZARD DIALOG BOXES.
  • CONTINUE UNTIL YOU GO THROUGH THE REST OF THE WIZARD DIALOG BOXES.
  • CLICK FINISH IN THE LAST DIALOG BOX.
  • YOU NOW SEE THE DATA BASE RESULT REGION.
  • NOTICE THAT YOU CANNOT ADD, DELETE, OR CHANGE THE DATA IN A DATABASE RESULT REGION, BUT YOU CAN ONLY VIEW THE DATA.
  • YOU CAN NOW CENTER COLUMN HEADINGS AND FIELD NAMES, AND SO FORTH.
  • YOU CAN RIGHT CLICK THE TABLE, AND CLICK PROPERTIES.
  • YOU CAN DOUBLE CLICK THE DATA BASE RESULT REGION TO OPEN THE WIZARD DIALOG BOXES (1-6).
  • YOU CAN ALSO RIGHT CLICK THE DATA BASE RESULT REGION, CLICK THE DATA BASE RESULT PROPERTIES, TO OPEN THE WIZARD DIALOG BOXES (1--6).
  • IN THE FOLDERS' VIEW, IN FRONT PAGE, YOU MUST RENAME THE FILE TO AN .asp EXTENSION.
  • WHEN YOU MOVE THE DATA BASE AND QUERY TO A NEW LOCATION, OR CONNECT THE DATA BASE TO THE QUERY, YOU MUST MAP THE DATA BASE FIELDS TO THE QUERY FIELDS (MAPPING).
  • OPEN THE WEB ONLINE AFTER YOU PUBLISHED THE WEB ONLINE. THE WEB/DATABASE MUST HAVE FRONT PAGE SERVER EXTENSIONS, ASP, AND ODBC (OPEN DATA BASE CONNECTIVITY) SUPPORT.
  • CLICK TOOLS, CLICK WEB SETTINGS, CLICK THE DATA BASE TAB, CLICK ADD BUTTON (IF THE CONNECTION NAME IS NOT ALREADY SHOWN) AND SELECT THE CONNECTION NAME, CLICK VERIFY, CLICK OK.
  • SAVE.
  • TEST AND SEE IF THE QUERY/DATABASE RUNS PROPERLY. IF NOT, GO BACK ONLINE AND OPEN THE WEB ONLINE. REDO THE CONNECTION ONLINE. CLICK TOOLS, CLICK WEB SETTINGS, CLICK DATA BASE TAB, AND SO FORTH.

[Syllabus|

[Database Concepts| |Import DB| |Access Page| |Using Access Pages]
[Results of Database| |Using Active Server Pages| |Results Region| |Create Search]