1 / 22

Day 14: MICROSOFT access – CHAPTER 1

Day 14: MICROSOFT access – CHAPTER 1. Madhuri Siddula masiddula@mix.wvu.edu October 2, 2014. Topics. File processing system Database fundamentals Microsoft access. MANUAL FILE SYSTEM. USER. FILE KEEPER. FILE CABINET. FILE PROCESSING SYSTEM.

daniel-kelley
Download Presentation

Day 14: MICROSOFT access – CHAPTER 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. Day 14:MICROSOFT access– CHAPTER 1 Madhuri Siddula masiddula@mix.wvu.edu October 2, 2014

  2. Topics • File processing system • Database fundamentals • Microsoft access

  3. MANUAL FILE SYSTEM USER FILE KEEPER FILE CABINET

  4. FILE PROCESSING SYSTEM • Information stored as group of records in separate files • File systems consisted of a few data files and many application programs • Each file called a soft file • Flat file contained the processed information for one specific function • Use of programming languages to write applications

  5. File processing systems structure Customer Processing Application Customer file Customer file User 1 Rental file Rental Processing Application Rental file User 2

  6. Limitation of File Processing system • Separate and isolated data • Data redundancy • Data independence for file formats and access techniques • Difficult in representing data from user’s view • Data inflexibility Due to this limitations, the concept of Data base management system (DBMS) was born

  7. A database management system (DBMS) is a software system that provides the tools to create, maintain and use a database. • Some of the databases: • MS Access • Oracle • SQL SERVER • MY SQL

  8. DBMS STRUCTURE USER 1 CPA DATABASE DBMS RPA USER 2 OPA USER 3

  9. Database fundamentals • Database is a collection of data, organized as meaningful information. • It can be accessed, managed, stored, queried, sorted and reported. • Examples • Amazon • Telephone directory • ebay • Cs101 student files

  10. Database Terminologies • Data This is the fact, or about specific entity(person,place or thing) • Information Is the data that have been processed and is useful to the user • Field Is a single item of information or data in entity e.g. employee name • Record Is a group of fields about an entity,example Employee’s particulars

  11. Field • The smallest data element contained in a table • Field types: • Text • Numeric • Date • Field examples: • Birthdates • Last Name • Age • Social Security #

  12. Record • Record – a complete set of all of the data elements (fields) about one person, place, event, or concept • Example record in a employee DB: • Name, Number, E-mail, Class, Section

  13. Table • The foundation of every database • Contains a primarykey (unique field) • Is a collection of related records • Example Table: • All Student records in my CS 101 sections would be added to my Section Roster Table during registration

  14. Key • A field that contains a unique identifier • Foreign key • A field in one table, that is a primary key in another

  15. Microsoft access

  16. Access objects • Tables, Forms, Queries, Reports, Macros Modules

  17. Things to do • Open an access file and work with content security. • Examining the access interface, views and organize information

  18. Things to do • Edit and Delete a record • Save as, compact and repair and backup the database.

  19. Sort table

  20. filter

  21. Other options • Toggle filter • Filter by form • Load from query • Save as query

  22. Thank you

More Related