{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Tutorial_01 - Tutorial 1 Creating a Database Introduction...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Tutorial 1 Creating a Database 2 Introduction to Database Concepts n Data is a valuable asset n Need to store , maintain , retrieve , present vital business data n Entity (nib) 3 Organizing Data n Example: issue25.accdb reference sheet n Data hierarchy n Byte n Field n Record n Table n Database
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
2 4 Databases and Relationships n How do we connect related data that has been stored in different tables? n Primary key n Foreign key 5 Issue25 Database n We’ll use periodically throughout the semester n Available in C:\CIS117 Data Files\Issue25\Issue25.accdb n Overview its tables n Writer n Article n Type 6 Opening a Database n Access closes any previously opened database n can have only one database open in the Access User Interface n can open multiple databases simultaneously via macro or VBA n Access creates an .LACCDB file with the same name in the same folder as the ACCDB file n Access is a multiuser database n when multiple users use the same db, conflicts can occur as users try to use/modify/delete the same object n the LACCDB file keeps track of the users connected to the db, which objects they’re using, and locking information n Practice Time n open issue25.accdb n observe the issue25.laccdb file
Background image of page 2
3 7 Relational Database Management System (RDBMS) n Software used to store, maintain, retrieve and present data in structured tables