Learn IT - Microsoft Access 2013 Intermediate

English | 2 hours+ | .MP4 | h264, yuv420p, 800x600, 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