1Tutorial 1Creating a Database2Introduction to Database ConceptsnData is a valuable assetnNeed to store, maintain, retrieve,presentvital business datanEntity (nib)3Organizing DatanExample: issue25.accdb reference sheetnData hierarchynBytenFieldnRecordnTablenDatabase
has intentionally blurred sections.
Sign up to view the full version.
24Databases and RelationshipsnHow do we connect related data that has been stored in different tables?nPrimary keynForeign key5Issue25 DatabasenWe’ll use periodically throughout the semesternAvailable in C:\CIS117 Data Files\Issue25\Issue25.accdbnOverview its tablesnWriternArticlenType6Opening a DatabasenAccess closes any previously opened databasencan have only one database open in the Access User Interfacencan open multiple databases simultaneously via macro or VBA nAccess creates an .LACCDB file with the same name in the same folder as the ACCDB filenAccess is a multiuserdatabasenwhen multiple users use the same db, conflicts can occur as users try to use/modify/delete the same objectnthe LACCDB file keeps track of the users connected to the db, which objects they’re using, and lockinginformationnPractice Timenopen issue25.accdbnobserve the issue25.laccdb file
37Relational Database Management System (RDBMS)nSoftware used to store, maintain, retrieve and present data in structured tables