MS Access Level 1
Sponsored links
This course provides an introduction to using Microsoft Access for database creation, focussing mostly on table design and select queries. Forms and Reports are introduced mostly using the inbuilt wizards.
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
INTRODUCTION
· Database Basic Concepts
· Database Object Overview
· Database Object Overview
USING TABLES
· Field Names vs Records
· Navigating around a table
· Entering Data
· Deleting Records
· Modifying the datasheet
Moving Columns (Fields)
Hiding/Unhiding Fields
CREATING TABLES
· Defining Field Names
· Selecting Data Types
· Using Descriptions
· Modifying Field Properties
· Using Primary Keys
· Attaching a photo or file to a record
SELECT QUERIES
· What is a query
· Designing a Query
· Using Criteria
· Sorting Results
· Creating a Calculation
· Setting the format property of a calculated column
Simple Forms
· What is a Form
· Why use a Form
· Creating a Form using the wizard
· Making simple formatting changes
· Adding a Form Header
· Adding a Calculation
· Moving and Resizing Objects
· Understanding Properties of a Form
Simple Reports
· What is a Report
· Why use a Report
· Creating a Report using the wizard
· Making simple formatting changes
· Moving and Resizing Objects
· Understanding Properties of a Form
This Training Course is taught in classrooms in the following locations:
London SE
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
