Lynda - Access 2007 Queries in Depth
- کاربرد : ارائه گزارشات ساده و تجزیه و تحلیل داده ها
- نوع فایل : فیلم آموزشی
- زبان : انگلیسی
- سیستم عامل : Windows-Mac-Linux-Android-iOS
- تولید کننده : Lynda
- سال تولید : 2010
توضیحات
همانطور که می دانید عمدتا از دیتابیس ها در مقاصد تجاری استفاده می گردد و یکی از مهمترین قابلیت هایی که از دیتابیس ها در امور تجاری انتظار می رود امکان ارائه گزارشات ساده و تجزیه و تحلیل داده ها می باشد
Description
In Access 2007: Queries in Depth, author Adam Wilbert illustrates how to create and leverage real-world queries and turn raw data into usable information The course covers setting up queries, performing calculations, using the built-in Access functions to further refine query results, and identifying top performers or areas for improvement based on a range of criteria Exercise files are included with the course
Topics include:
Naming conventions and best practices
Working with joins and primary keys
Using comparison operators
Printing query results
Creating parameter queries
Creating calculated fields
Using the Expression Builder
Making conditional statements
Appending queries
Updating queries
Topics include:
Naming conventions and best practices
Working with joins and primary keys
Using comparison operators
Printing query results
Creating parameter queries
Creating calculated fields
Using the Expression Builder
Making conditional statements
Appending queries
Updating queries