1 / 20

Lesson 1

Lesson 1. Introduction of Databases Using Microsoft Access. Overview. What is database Steps to design a database Elements, menus, toolbar of MS Access Work with MS Access. What is database. A collection of information eg, lists of names, address, phone no for contact

kelii
Download Presentation

Lesson 1

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. Lesson 1 Introduction of Databases Using Microsoft Access

  2. Overview • What is database • Steps to design a database • Elements, menus, toolbar of MS Access • Work with MS Access

  3. What is database • A collection of information • eg, lists of names, address, phone no for contact • Each item of information in the list such as name, phone no is called a field. • The collection of field information for one person in the list is a record. • Field and record information is contained in a grid called a table.

  4. Fields Record Phone list of teaching staffs

  5. Database Storage and management • Objects you create are stored in a single database file • eg : stafflist.mdb • A computer application that you use to create and maintain databases is database management system (DBMS)

  6. Design a Database • Define purpose • Plan database objects • Create tables • Create queries • Create forms and reports

  7. Assignment • Design your own contact list • Which includes • Class • Name (may set as primary key) • Class no • Favourite subject • Birthday • Phone no

  8. Tasks included • Open a database • Create fields in a table with different data types • Add records to the table using DATASHEET view • Create an AUTOFORM • Add records to the table using the Form

  9. Short Quiz • What is the term describes all the data for one entity in a table? • Record • File • Field • Query

  10. Short Quiz 2. What is the extension of a database file? • Filename.acc • Filename.mdb • Filename.msdb • Filename.dbms

  11. Short Quiz 3. Which of the following should be the most suitable as a datatype of the field DateofBirth? • text • currency • hyperlink • Date/Time

  12. Design your own contact list

  13. Private key

  14. Manage data base

  15. Well Done!! This is the end ~0~

More Related