Make more informed decisions by effectively tracking, reporting, and sharing information with Microsoft Access.
Make 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.
MS Word course is offered by Edge Skills Centre Inc. The mission of EDGE Skills Centre is to inspire, prepare and empower our clients to improve the quality of their lives and to achieve their personal goals through the provision of current and effective language
This course is offered over two weeks and introduces basic tools for using a computer and common software programs such as Microsoft Office (MS).
This course provides students with a tool to easily create a professional-looking visual product. Students will create visually engaging diagrams, maps, and drawings using graphical elements to make information easier to comprehend.
Expand your Microsoft Word skills by exploring essential formatting functionalities such as styles, document sections, and tables. Upon successful completion of this course, you will have the skills to apply intermediate formatting techniques and tools in Microsoft Word.
Learn to create and edit basic Excel worksheets. This course is intended for participants who want to get up to speed with Microsoft Excel and gain a strong foundational understanding of Excel that is necessary to create and work with electronic spreadsheets.
Âİ 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy