tailieunhanh - Lecture Business driven technology (Technology plug-in): Chapter 6 - Paige Baltzan, Amy Phillips

Chapter 6 - Database management system. In this chapter you will learn: Describe the primary functions using Microsoft Access, describe the steps for creating a new database file using microsoft access, describe the steps for creating and modifying a table and fields using microsoft access, describe the steps for creating relationships between tables using microsoft access. | TECHNOLOGY PLUG-IN T6 Basic Skills Using Access LEARNING OUTCOMES Describe the primary functions using Microsoft Access Describe the steps for creating a new database file using Microsoft Access Describe the steps for creating and modifying a table and fields using Microsoft Access Describe the steps for creating relationships between tables using Microsoft Access INTRODUCTION TO ACCESS Microsoft Access is a powerful database program that allows you to enter and organize large amounts of data Access allows you to relate tables and databases to one another, it is often referred to as a relational database INTRODUCTION TO ACCESS A relational database is a group of tables related to one another by common fields A table (or datasheet) looks similar to a spreadsheet Each row in the table contains all the data for a single record Each column in the table represents a specific data value called a field All records have the same fields Creating A New Blank Database To start a new database . | TECHNOLOGY PLUG-IN T6 Basic Skills Using Access LEARNING OUTCOMES Describe the primary functions using Microsoft Access Describe the steps for creating a new database file using Microsoft Access Describe the steps for creating and modifying a table and fields using Microsoft Access Describe the steps for creating relationships between tables using Microsoft Access INTRODUCTION TO ACCESS Microsoft Access is a powerful database program that allows you to enter and organize large amounts of data Access allows you to relate tables and databases to one another, it is often referred to as a relational database INTRODUCTION TO ACCESS A relational database is a group of tables related to one another by common fields A table (or datasheet) looks similar to a spreadsheet Each row in the table contains all the data for a single record Each column in the table represents a specific data value called a field All records have the same fields Creating A New Blank Database To start a new database using Microsoft Access, click the Blank Database option in the New File task pane The first thing you do is name your database In Access, the database file cannot be moved to another disk or folder using the Save As command Creating A New Blank Database To create a blank database, follow these steps: Open Access, click the Office button and then click New On the Getting Started with Microsoft Office Access page, under New Blank Database, click Blank Database Enter Slopeside Bikes for the database file name Click Create Creating A New Blank Database Opening An Existing Database When you start Access, the task pane lists the most recently opened databases To open a database: Click the Office button and then click Open In the Open dialog box, browse to the database that you want to open Double-click the name of the database to open it, or click the name of the database once to highlight it, then click the Open button Opening An Existing Database Using The Database Templates Here is an .