1 / 17

LECTURE 9 APPLICATION SOFTWARE 4. Microsoft Access

LECTURE 9 APPLICATION SOFTWARE 4. Microsoft Access. Week 10 (2012) Dr. Ghada Drahem. INTENDED LEARNING OUTCOMES. This lecture covers: Describe what Microsoft Access. When and how this program might be used. MICROSOFT ACCESS.

march
Download Presentation

LECTURE 9 APPLICATION SOFTWARE 4. Microsoft Access

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. LECTURE 9 APPLICATION SOFTWARE 4. Microsoft Access Week 10 (2012) Dr. Ghada Drahem

  2. INTENDED LEARNING OUTCOMES • This lecture covers: • Describe what Microsoft Access. • When and how this program might be used

  3. MICROSOFT ACCESS • Databases contain a variety of objects(such as tables, queries, forms, reports)

  4. CREATING A DATABASE • Database file is created first • Tables can then be created • Typically, the table structure is specified first • Includes a list of fields and their properties, including: • Field name (unique identifying name) • Data type (text, number, date, object) • Field size (maximum number of characters) • Default value (initial content of the field) • The table is named and saved • The table structure can be modified using the Design view

  5. CREATING AN INITIAL TABLE

  6. CREATINGA DATABASE (cont.) • After the table structure has been created, data is entered into the table • Datasheet view: Lists all data and looks similar to a spreadsheet • Form: Created by the user and typically displays just one record at a time • In either case, data is entered into the database table • Either Datasheet view or a form can be used to modify data or delete records

  7. QUERIES • Query: A question; a request for specific information from the database • Contain criteria to specify the records and fields to be included in the query results • Are named and saved so they can be run again at a later time • Results always include the current database data • SQL (Structured Query Language) is a comprehensive database language; it has statements for data definition, query, and update. In addition it has facilities for defining views on the database,

  8. SQL (STRUCTURED QUERY LANGUAGE) • SQL is a comprehensive database language • It has statements for data definition, query, and update. • In addition it has facilities for defining views on the database, for specifying security and authorization, for defining integrity constraints, and for specifying transaction controls. • It has rules for embedding SQL statements into a general-purpose programming language such as C.

  9. BASIC QUERIES IN SQL • SQL has one basic statement for retrieving information from a database; the SELECT statement • The basic form of the SELECT statement SELECT <attribute list> FROM <table list> WHERE <condition> • Example: retrieve the birthdate and address of the employee(s) whose name is ‘John B. Smith’ SELECT BDATE, ADDRESS FROM ENPLOYEE WHERE FNAME= ‘John’ AND MNAME=’B’ AND LNAME= ‘Smith’

  10. REPORTS • Reports: Created when a more formal output is desired • Associated with either a table or a query • Data is displayed in the specified format

  11. DATABASES AND THE WEB • Many Web sites use one or more databases • Anytime you type keywords in a search site or hunt for a product on a retail store’s Web site using its search feature, you are using a Web database • Default Access 2007 file format is .accdb

  12. NEW LECTURENETWORKS

More Related