microsoft access 4 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Microsoft Access 4 PowerPoint Presentation
Download Presentation
Microsoft Access 4

Loading in 2 Seconds...

play fullscreen
1 / 6

Microsoft Access 4 - PowerPoint PPT Presentation

  • Uploaded on

Microsoft Access 4. Database Creation and Management. Creating Web-Enabled Information.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

Microsoft Access 4

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
microsoft access 4

Microsoft Access 4

Database Creation and Management

creating web enabled information
Creating Web-Enabled Information
  • Barbara feels that other employees in the company would benefit from gaining access to the Restaurant Database. Leonard asks whether the database can be made available to employees over the company network (I.e., Intranet). That way, employees could obtain company information using their desktop computers rather than using paper forms. Most employees, such as the customer representatives in the marketing department, do not need to access to the entire database, nor should they be able to make changes to the database objects.
creating a static web page
Creating a Static Web Page
  • Leonard has asked you to create an HTML document for the Customer table. He wants this data to be available to customer representatives working outside the office. Leonard wants you to create static Web pages because the customer representatives need to view them only once a month to complete their monthly status reports.
  • Select the Customer table from Restaurant Database
  • Export the table as HTML file.
    • Select nothing
    • Select: “Export data with formatting and layout”
creating an static web page
Creating an Static Web Page
  • Easy to create and maintain
    • Stored outside the database
  • Simple to publish
  • Only reflect the state of the Customer table at the time it was created.
  • Does not allow continuous update because it’s not linked to the Customer table on which it is based.
importing an html document as an access table
Importing an Html Document as an Access Table
  • Download and then open NewRest HTML document.
  • Close NewRest HTML document.
  • Import NewRest HTML document into Restaurant database.
    • Let the Access choose the primary key.
  • Save as Potential Customers
importing and exporting an xml document
Importing and Exporting an XML Document
  • Download Loans XMLdocument.
    • Universal way to transmit data because of the Internet
  • Import Loans XMLdocument into Restaurant database.
  • Save as Loans XML
  • Export Customer table as an XML document