1 / 24

MS Access Database Connection

MS Access Database Connection. Database?. A database is a program that stores data and records in a structured and queryable format. The tools that are used for managing, maintaining and querying database are called Database Management Systems.

effie
Download Presentation

MS Access Database Connection

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. MS Access Database Connection

  2. Database? • A database is a program that stores data and records in a structured and queryable format. • The tools that are used for managing, maintaining and querying database are called Database Management Systems. • The language that is used for querying and managing databases is called Structured Query Language (SQL).

  3. Where and How?

  4. Creating a file ! ! To connect accdb access file from a C# application you should download 2007 Office System Driver: Data Connectivity Componentsfrom the link below http://www.microsoft.com/en-us/download/details.aspx?id=23734

  5. Creating a table • Table? • A table is a structure that holds relational data in rows and columns. • Rows hold data and columns hold types. • Column count is constant but row count is variable. • Every table stands for an entity. So for each entity we will need another table.

  6. Tree rules in table design • Divide data into smallest pieces. • Don’t try to store two different data in one place. • Make sure that you will be able to separate data from another.

  7. Table Creation

  8. Table Creation

  9. Table Creation

  10. Table Creation

  11. Table Creation

  12. Table Creation

  13. Manual data entry

  14. Changing table structure

  15. Changing table structure

  16. SQL-Query

  17. SQL-Query

  18. SQL-Query

  19. SQL-Query

  20. SQL Language

  21. SQL Language

  22. Select? • It is one of the most used commands. • Used for fetching data from one or more tables. • Includes at least two keywords. • What will be selected? • Where will be selected?

  23. Select? • SELECTcolumn_namesFROMtable_names

  24. Select? Column names Table name • SELECTTCKIMLIK, AD, SOYADFROMPersonel • We will write our very own SQL statements • Select • Insert • Update • Delete • Where

More Related