Microsoft Access - Basic and Intermediate
Course Overview
Some may feel that having knowledge of Microsoft Excel will suffice at work. In fact, Microsoft Access is preferred over Excel for people who deals with numerous reports and queries, especially for small business owners. Microsoft Access is used for collecting and sorting of data, and is part of the RDMS (Relational Database Management Systems).
While both Excel vs Access are important applications, their functions are useful for different purposes. Excel only provides worksheets that are flat or non-relational. On the other hand, Access provides tables that are relational at multiple levels.
Mode of Assessment
No Assessment
Course Duration
2 days
Total Training Duration (Hour)
16 hours
Course Outline
- Introduction to Databases
- What’s New in Access 2019
- Understanding the Access Program Screen
- Working with Database Objects
- Tour of a Table, Form, Query & Report
- Adding, Editing and Deleting Records
- Selecting Data & Using the Zoom Box
Creating and Working with a Database
- Planning a Database
- Creating a New Database
- Converting an Access Database
Working with Tables and Fields
- Modifying a Table
- Understanding Field Properties
- Indexing a Field
- Adding a Primary Key to a Table
- Inserting, Deleting, and Reordering Fields
- Adding Field Descriptions and Captions
- Changing the Field Size
- Formatting Number, Currency & Date/Time Fields by Hand
- Formatting Text Fields
- Using Hyperlink Fields
- Setting a Default Value
- Requiring Data Entry
- Validating Data
- Creating an Input Mask
- Creating a Lookup Field
- Creating a Value List
- Modifying a Lookup List
- Understanding Table Relationships
- Creating Relationships Between Tables
- Enforcing Referential Integrity
- Printing and Deleting Relationships
- Understanding Relationship Types
- Creating & Sorting a Query
- Using AND and OR Operators in a Query
- Understanding Different Types of Queries
- Creating a Multiple Table Query
- Creating a Calculated Field
- Summarizing Groups of Records
- Display Top or Bottom Values
- Creating a Form with the Form Wizard
- Creating and Using a Form
- Understanding Form Views
- Modifying a Form in Layout View
- Form Design View Basics
- Creating a Subform
- Modifying and Working with Subforms
- Creating a Report with the Report Wizard
- Creating a Report
- Working in Layout View
- Adding a Logo
- Working in Design View
- Adjusting Page Margins and Orientation
- Adding Page Numbers and Dates
- Creating Mailing Labels with the Label Wizard
- Formatting Fonts
- Changing Text Alignment
- Changing Colors
- Using Conditional Formatting
- Adding Pictures, Lines, and Gridlines
- Working with Number Formatting
- Using Themes
Certification Obtained and Conferred by
Upon successful completion of the Microsoft Access – Basic and Intermediate course, participants who have attended at least 75% of the course will receive a Certificate of Attendance by @ASK Training.
Course Learning Outcome
As a beginner, we make sure you understand the key Access functionality, such as entering data and the basics of tables, forms, queries and reports. Upon completion of the course, you will be able to:
- Create and work with Access tables and fields, understand field properties, index a field, and add a primary key to the table.
- Create relationships between tables.
- Query data easily using joins, sorting, and filtering from different tables.
- Create and use forms to make it easier to view, access, and input data.
- Create and format custom reports.
Pre-requisites
Regularly use Microsoft Office applications such as Excel. Familiarity with data management would be advantageous.
Course Pre-Requisites
Price
| Course Fee Payable | ||
|---|---|---|
| Original Fee | Before GST | With GST (9%) |
| Course Fee | $500.00 | $545.00 |
Full Course Fee: $545 (inclusive 9% GST)
Please note that prices are subjected to change.