Learn IT – Microsoft Access 2013 : Intermediate-0daytown

Learn IT – Microsoft Access 2013 Intermediate

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