Главная
Study mode:
on
1
Start:
2
Opening a Sample Database
3
The Database Objects
4
The Interface
5
Introducing Tables
6
Simple Data Entry
7
Introducing Queries
8
Practicing Data Entry in Queries
9
Introducing Forms
10
Data Entry Into Forms
11
Introducing Reports
12
Sorting to Create Groups
13
Finding Data in Tables
14
Filtering
15
Adding Total Rows
16
Starting a New Database
17
Creating Tables in Design View
18
Entering Your First Record
19
Using Quick Starts to Create Tables
20
Entering Data Into Your Second Table
21
Summary
22
Introduction
23
Looking at the First Draft of a Database
24
Creating Relationships with Lookup Lists
25
The Relationships Window
26
Relating by Dragging Field Names
27
Dragging to Create 1-to-1 Relationships
28
Changing Dragged Relationships to Lookup Relationships
29
Limit-To-List Properties
30
Enforced Referential Integrity
31
Seeing the Referential Integrity Being Enforced
32
Cascade Edits and Deletions
33
More Field Properties
Description:
Who it's For: Access is designed for people who are comfortable with spreadsheet programs like Excel. These users need more power and analyzation, as well as a stronger forward-facing interface. What it is: Access is a database creation and management program. It helps you design, build, and interface with a robust database to help your organization run smoothly. Many small to medium-sized businesses use Access for this exact purpose. What You'll Learn: This course starts with database basics, terms, and information you’ll need to confidently build your database later on. Then, you’ll learn how to build tables, determine relationships, query data, and create simple-to-use interfaces that other people at your company can use to interact with your data.

Access Beginner Tutorial

Learnit Training
Add to list
0:00 / 0:00