Learn IT – Microsoft Access 2013 Intermediate
English | 2 hours+ | .MP4 | h264, yuv420p, 800×600, 15.00 fps(r) | aac, 44100 Hz, stereo | 408 MB
Genre: E-learning
Access provides a powerful set of tools that are sophisticated enough for professional data managers, yet easy for new users to learn. Access is for users that need to track and report on data in advanced ways. It’s a good idea to be familiar with Excel before you learn Access.
Access is the next step past Excel. It’s useful for tracking, reporting, and working with data, reports, and calculations. Many small businesses use Access as their business database. Because Access doesn’t require programming, normal people use it to develop robust databases instead of hiring an expensive developer.
The first part of Access focuses on tables—how the data is stored, and moves from there. You’ll learn concepts, theories, and how to query for results. You’ll learn advanced database techniques like creating reports and user interfaces to be used by non-technical people.
Open QUERY.MDB
Navigation Pane options
Relationships window
Convert to 2013 format
Trusted Location
Show tabbed document
Hide and UnHide table fields
Query Wizard
Sort by 1 field
Sort by multiple fields
Field order in Design view
Query Design
Filter a query
Multiple criteria
Deleting filtering criteria
Find records with blank data
Using NOT
Using AND
AND vs. OR
Filter by multiple fields
Parameter query
Re-query
Multiple prompts
Queries and Tables
Lookup list
Multitable Query
A common mistake
Too many tables
Temporary Joins
Query Calculations
Expression Builder
Concatenation
Wildcard filters
Wildcard parameter query
Open Query DSN
Turn On Tab Documents
Totals Query
Query from a query
Other kinds of math
Another Totals Query
CrossTab Query
SQL View
Export to Excel
Export to Word (RTF)
Squeeze to 1 pg wide
Import from Excel
Link to Excel
Problem with linked worksheet
Link to Access
Edit in the linked table
Edit in the local table
Actions Querys
Make-Table Query
Add Clear Grid to Quick Access Toolbar
Delete Query
Update Query
Append Query
Download uploaded
http://uploaded.net/file/sjxrl8tn/Learn%20IT%20Microsoft%20Access%202013%20Intermediate.part1.rar
http://uploaded.net/file/oyjfe0f8/Learn%20IT%20Microsoft%20Access%202013%20Intermediate.part2.rar
http://uploaded.net/file/aleicun9/Learn%20IT%20Microsoft%20Access%202013%20Intermediate.part3.rar
http://uploaded.net/file/cvil4uai/Learn%20IT%20Microsoft%20Access%202013%20Intermediate.part4.rar
http://uploaded.net/file/cyjpd4mh/Learn%20IT%20Microsoft%20Access%202013%20Intermediate.part5.rar
Download nitroflare
http://www.nitroflare.com/view/617FE6B687C6C9D/Learn_IT_Microsoft_Access_2013_Intermediate.part1.rar
http://www.nitroflare.com/view/FC41615BC9C27AE/Learn_IT_Microsoft_Access_2013_Intermediate.part2.rar
http://www.nitroflare.com/view/C17CEB864BB2773/Learn_IT_Microsoft_Access_2013_Intermediate.part3.rar
http://www.nitroflare.com/view/400C5B6C37536D7/Learn_IT_Microsoft_Access_2013_Intermediate.part4.rar
http://www.nitroflare.com/view/01D37FEE043D791/Learn_IT_Microsoft_Access_2013_Intermediate.part5.rar
Download 百度云
链接: http://pan.baidu.com/s/1bnEZ3YJ 密码: ecca
转载请注明:0daytown » Learn IT – Microsoft Access 2013 : Intermediate