1 Access Tutorial 1 Creating a Database Microsoft Office 2013 EnhancedĢ Objectives Session 1.1 Learn basic database concepts and terms Start and exit Access Explore the Microsoft Access window and Backstage view Create a blank database Create and save a table in Datasheet view Enter field names and records in a table datasheet Open a table using the Navigation Pane 2ģ Objectives (Cont.) Session 1.2 Open an Access database Copy and paste records from another Access database Navigate a table datasheet Create and navigate a simple query Create and navigate a simple form Create, preview, navigate, and print a simple report Use Help in Access Learn how to compact, back up, and restore a database 3Ĥ Creating a Database Case - Chatham Community Health Services All Tutorials use this Case A nonprofit health clinic located in Hartford, Connecticut, specializes in the areas of pulmonology, cardiac care, and chronic disease management Cindi Rodriguez, the office manager for Chatham Community Health Services, oversees a small staff and is responsible for maintaining the medical records of the clinic s patients 4ĥ Creating a Database (Cont.) Case - Chatham Community Health Services Cindi and her staff rely on electronic medical records for patient information, billing, inventory control, purchasing, and accounts payable The clinic recently upgraded to Microsoft Access 2013 (or simply Access) Using the software to enter, maintain, and retrieve related data in a format known as a database 5ġ0 Databases and Relationships A relational database is a collection of related tables Records in the separate tables are connected through a common field A primary key is a field, or a collection of fields, that uniquely identify each record in a table Including the primary key from one table as a field in a second table to form a relationship between the two tables, it is called a foreign key in the second table 10ġ1 Relational Database Management Systems A database management system (DBMS) is a software program that lets you create databases and then manipulate the data they contain In a relational database management system, data is organized as a collection of tables.
0 kommentar(er)
