Learn IT - Microsoft Access 2013 : Beginner

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.

Templates
Web Databases
Organize by Objects
The Objects
Tables
Touch Screen Mode
Navigating in a Table
Editing Data
Records are saved immediately
Undo a record
Only 1 Undo for data editing
Datasheet View and Design View
Queries
Data entry in a Query
Closing Objects
Query Design View
Forms
Form Design View
Reports
Report Design View
Find Function
Sort Function
Reverse Sort And Multiple Sort
Filter Function
Filter a Range of Values
Filter Multiple Fields
Remove All Filters
Search For a Template
Planning the New Database
New Database
Create a Table
Table Design View
Create table in Datasheet view
More Field Properties
Input Mask
Descriptions
Phone Input Mask
Change Primary Key Data Type
Primary Key Special Property
More Field Properties

Open QUERY.ACCDB
Leszynski Naming Conventions
Relationships between Tables
Field Captions
The Relationships Window
Delete Relationship Windows
Make Window Relationships
Subtables
Orphan Records
Problem Editing a Relationship
Results of Referential Integrity
Test Referential Integrity
Cascade Updates
Cascade Deletions
Open Beyond Clean 1st Draft
Open Beyond Clean (no draft)
Lookup Wizard
Adding entries to the lookup
Reopen the Veterinarian db
Where will we put the Foreign Key?
Add the Foreign key
Add the Lookup