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 windowCreate 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 data contained in themIn a relational database management system (RDBMS), data are organized as a collection of relationsAccess 2007 relations 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)After entering data values into your table(s),...
View Full Document

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