1 / 19

MGS 351 Introduction to Management Information Systems

MGS 351 Introduction to Management Information Systems. RECITATION 11. Agenda. Attendance Collect HW #4 Guided Exercise Questions Introduce HW #5: Switchboards and Macros Project Reminders Assign HTML Project Website Project Work Reminders. Homework 5. Chapter 7: Switchboards & Macros

zack
Download Presentation

MGS 351 Introduction to Management Information Systems

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MGS 351Introduction to Management Information Systems RECITATION 11

  2. Agenda • Attendance • Collect HW #4 Guided Exercise Questions • Introduce HW #5: Switchboards and Macros • Project Reminders • Assign HTML Project Website • Project Work • Reminders

  3. Homework 5 • Chapter 7: Switchboards & Macros • Guided Exercise Questions Chapter 7 • Due Two Weeks From Today: • Thursday Recitations November 21, 2013 • Friday Recitations November 22, 2013

  4. Project Reminders • You should officially have your Project Proposal APPROVED by the professor by the end of today. • Check: • Project Checklist • Project Overview • PowerPoint on additional ways to earn points posted on my discussion board • Only 2 LAB classes remain to work on Projects

  5. Project Stage 1: Entity Creation/Data • At least 10 records for main tables • At least 3 records for periphery tables • (subforms, etc.) • Formatting • Establish Relationships (from Homework 4)

  6. Project Stage 2: Forms & Subforms • One form for each table must be created (this includes subforms) • At least one subform or linked form in your database • Do not create subforms until you create/ set your relationships • Buttons on the forms: • Ex. Add, Delete, Find, Print, Close • User-friendly interface • Different & Labeled controls • Aligned & formatted • Tab order • Use techniques learned in homework

  7. Project Stage 3: Queries & Reports • Start Queries & Reports • Remember • Formatting • Business Value • Use Grouping & Sorting • Use Relevant Titles/Control Names/Controls • (Do not use all ID #’s) • Titles should BRIEFLY describe what the report is displaying

  8. Final Project Website (using HTML) • See • HTML HELP Powerpoint-explains how to access your website on campus and off campus • HTML Code document - provides code you will need to achieve minimal requirements Both posted on UBlearns on my discussion board • Discussed in lecture this week & next week

  9. Important to Note • Every person has access to their own website • For your teams you will only use ONE person’s website to generate it for your company • You can all test code in your individual websites, but only one hyperlink should be submitted

  10. Getting Started: Activate Your Website • To check if your website has been activated: • http://www.acsu.buffalo.edu/~yourUBITusername/ Mine is: http://www.acsu.buffalo.edu/~nicolech/ • If you get it means that you have not activated your website

  11. Activate your website • To activate your website: • https://ubfs.buffalo.edu/cgi-bin/ubfs_activatepersonalwebsite.cgi • Click on activate your website • Test it again! • http://www.acsu.buffalo.edu/~yourUBITusername/ This should now display something like :

  12. What does that mean? • This is saying that you are using the default page that UB creates for you once you activate it. If you right click the page and press “view page source,” it will show you all the code.

  13. In Order to Edit the Code • On your desktop, click the UBFS drive, then public_html (this folder will contain all your website files such as: code, pictures, database, etc.)

  14. To Edit Code • The file “index” is where you will store all your code. It is a text file • Open your index file with a text editor • Delete all the default code that you have in there. • Paste this into the index file: <body bgcolor="#80FF00"> This will change the background color to green • Color codes can be found online: http://html-color-codes.info/ • You can also use pictures as background

  15. Editing Code • So far we wrote: <body bgcolor="#80FF00"> • Add in: <h1> anything you write here will be displayed</h1> Always need an opening and closing tag • In order to center the text: <center> <h1> Blah blah blah </h1> </center>

  16. The file HTML CODE that I posted has all the code you will need to fulfill the minimal requirements.

  17. Project Work • Finish Stage 1 : Entity Creation • Continue/finish Stage 2: Form Creation • Start Stage 3: Report Creation (using queries) • Work on your Company Website • Look at the HTML CODE file I posted

  18. Reminders • Homework #5 • Due in two weeks • Homework #5 Help next lab • Entity/Table creation should be completed • Form/ Subforms should be completed by the end of lab next week • Queries and Reports should be started • Start/Attempt Project Website

  19. Reminders • Next Week in Lab: • Homework #5 Help • 2 weeks left to work on your final project website • This week’s lecture: On HTML • Please watch

More Related