9-Access-T01 - 9-Access-T01Database FundamentalsTutorial...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: 9-Access-T01Database FundamentalsTutorial ObjectivesDefine the terms field, record, table, relational database, primary key, and foreign keyIdentify the components of the Microsoft Access windowreate and save a table in Datasheet viewCreate and save a table in Datasheet viewEnter field names and records in a table datasheetOpen a table using the Navigation PaneNew Perspectives on Microsoft Office 2007: Windows Vista Edition2Tutorial ObjectivesOpen an Access databaseCopy and paste records from another Access databaseNavigate a table datasheetCreate and navigate a simple queryCreate and navigate a simple formCreate, preview, navigate, and print a simple reportLearn how to manage a database by compacting, backing up, and restoring a databaseNew Perspectives on Microsoft Office 2007: Windows Vista Edition3Relational Database Management SystemsA database management system(DBMS) is a software program that lets you create databases, and then manipulate the datacontained in themIn a relational database management system (RDBMS),data are organized as a collection of relationsAccess 2007relations are called tablesNew Perspectives on Microsoft Office 2007: Windows Vista Edition4RDBMS SoftwareNew Perspectives on Microsoft Office 2007: Windows Vista Edition5Organizing DataYour first step in organizing data, is to identify the individual fields, for each entityEntity: a person, object, or eventNext, you use Access to define each particular set of fields as a table, one table per entityEach field (i.e., column) has a specified data-typeA set of field values is called a record (i.e., row)(i....
View Full Document

This note was uploaded on 12/09/2010 for the course COMP SCI 1B03 taught by Professor Dr.dotler during the Spring '10 term at McMaster University.

Page1 / 26

9-Access-T01 - 9-Access-T01Database FundamentalsTutorial...

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

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