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

Chapter 7 - Problem solving using access. Learning objectives of this chapter include: Describe the process of using the simple query wizard using access, describe the process of using the design view for creating a query using access, describe the process of adding a calculated field to a query using access, describe the process of using aggregate functions to calculate totals in queries, describe how to format results displayed in calculated fields. | TECHNOLOGY PLUG-IN T7 Problem Solving Using Access LEARNING OUTCOMES Describe the process of using the Simple Query Wizard using Access Describe the process of using the Design view for creating a query using Access Describe the process of adding a calculated field to a query using Access Describe the process of using aggregate functions to calculate totals in queries. Describe how to format results displayed in calculated fields INTRODUCTION A query is a tool for extracting, combining, and displaying data from one or more tables, according to criteria you specify In a query, you can sort information, summarize data (display totals, averages, counts, and so on), display the results of calculations on data, and choose exactly which fields are shown You can view the results of a query in a tabular format, or you can view the query’s data through a form or on a report Creating Simple Queries Use the Simple Query Wizard to create a select query A select query displays data from a table or

• Quản trị kinh doanh
• Business driven technology
• Lecture Business driven technology
• Technology plug in
• Business plug ins
• Simple query wizard
• Advanced queries
• 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
• Microsoft Access
• New blank database
• 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