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 .

• Quản trị kinh doanh
• Business driven technology
• Lecture Business driven technology
• Technology plug in
• Business plug ins
• Microsoft Access
• New blank database
• Business process
• Business process improvement
• Mobile technology
• Personal digital assistants
• Business basics
• Financial statement
• Business intelligence
• Data mining
• Global information systems
• Cultural business challenges
• Creating strong passwords
• Monitor your accounts
• Creating conditional formatting
• Using autofilter
• Goal Seek Command
• Decision making using excel
• Designing database applications
• Database management system
• Simple query wizard
• Advanced queries
• Form wizard in access
• Report wizard
• Designing web pages
• World wide web
• Hypertext Markup Language
• Improving readability
• Navigating in dreamweaver
• Dreamweaver setup
• Gantt chart
• Creating gantt charts with excel
• Central processing unit
• Primary storage
• Enterprise architectures
• Disaster recovery
• Network basics
• Server network
• Information security
• Information security policies
• Information privacy policy
• Ethical computer use policy
• Supply chain management
• Supply chain drivers
• Customer relationship management
• Operational CRM
• Enterprise resource management
• Core ERP component
• Ebusiness model
• Accessing internet information