Microsoft Access 365 / 2019 / 2016 Level 1
Make more informed decisions by effectively tracking, reporting, and sharing information with Microsoft Access.
With our extensive knowledge of the different software currently on the market, including all Microsoft and Adobe applications, ON-TRACK Corporate Training Ltd. has a diverse and flexible schedule that can be customized to your needs – we offer group course (both public and corporate), one-on-one training, and on-site training options. We also have easily accessible on-line training videos available.
Duration: 1 Day
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 and keyboard and mouse
- 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