Make more informed decisions by effectively tracking, reporting, and sharing information with Microsoft Access.
DurationMake more informed decisions by effectively tracking, reporting, and sharing information with Microsoft Access.
Objectives
To give an introduction to database design concepts. This course offers grounding in creating the core objects of a database and covers data manipulation and extraction at an introductory level.
Prerequisites
Familiarity with personal computers, keyboards, and mice
Basic Microsoft Windows Skills
Knowledge of Excel data management (Optional)
Outline
Introduction to Databases
Database concepts
Database Layout
Launching Access
The Access Menu System
Dialog Boxes
Getting Help
Creating A New Database
Creating an Access Web App
Closing A Database (Vs Exit Access)
Opening A Database
Tables
Database Design
Creating Tables Using The Table Wizard
Creating Tables In The Datasheet View
Creating Tables In The Design View
Data Types
Field Properties
Data Display Format Vs Input Mask
The Input Mask
Data Entry Problems
Moving And Copying Records
Working with Tables
Pasting Records
Sorting The Table
Deleting A Table
Table Layout Changes
Find
Replace
Wildcards
Queries
The Simple Query Wizard
The Design View
Modifying The Query
Using Basic Criteria
Additional Criteria
Parameters
Multiple Object Queries
Custom Calculations In A Query
Calculating Fields Continued
Grouping Fields
Introduction to Reports
Reports
The Report Wizard
Introduction to E-mailing database information
E-Mailing Database Information
ON-TRACK Corporate Training Ltd., situated in the downtown core at 609 Granville Street - Suite 650, has been one of Vancouver’s elite computer training providers since 1989.
Throughout our history we have provided quality training solutions to thousands of satisfied clients on a global level – a tradition of quality that we continue with our commitment to client satisfaction.
Our corporate trainers, small class sizes, convenient Vancouver downtown location, and our vast experience in all levels of training create an effective and powerful learning experience for our valued clients.
Microsoft Word is the leading word processing and document creation tool for both personal and business use.
Learn Microsoft Office skills with to get work online and better jobs and take your business to the next level. Our Microsoft Office courses prepare YOU to be great at presentations, crunching data, and preparing documetns that stand out.
The Microsoft Word Level advanced course gives students intermediate- to advanced-level concepts and features of the Microsoft Word application. In this course, students learn to customize Word and build upon the basic skills learned in the Word Fundamentals course.
In this Introduction to Microsoft Excel 2016 training course, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2016 worksheets.
This intermediate-level course is designed to help users who are familiar with Wordâs basic features to take their skills to the next level.
About Coursetakers.com
Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the UAE, UK, USA, India and South Africa, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.
Âİ 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy
Online
USA
UK
India
UAE
South Africa
Canada
New Zealand
Australia
Malaysia
Singapore