Tutorial_01

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 DocumentRight 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 n We will use Access to: n create new tables n define relationships between tables n add and delete records n change field values so they’re up-to-date n retrieve data to answer questions n create customized forms n create customized reports n utilize a switchboard n use database startup options 8 6 Types of Access Objects n Table (Tutorials 2, 5, 9) n an object that stores data in rows (records) and columns (fields) n Query (Tutorials 3, 5, 9) n an object that selects requested fields and records from a table
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

Tutorial_01 - Tutorial 1 Creating a Database Introduction...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online