Microsoft Access Level 1 – Office 2016/Office 365
This training enables the delegates to use this MS Access database application to enter, store, and retrieve data for referencing and creating reports. This Microsoft 2016/Office 365 Suite application can handle a large amount of data. This training course delivers the knowledge & skills to input data into forms and tables, retrieve results through queries and present data in the form of reports. The graphical user interface facilitates the user to import or link data stored in different databases and application. Join this hands-on training in Dubai.
2 Days
Microsoft Access
7 PDUs
Personal Development Unit
MS Access Level 1
STARTING MICROSOFT ACCESS
- Orientation to Microsoft Access
- Create a Simple Access Database
- Get Help in Microsoft Access
WORKING WITH TABLE DATA
- Modify Table Data
- Sort and Filter Records
- Create Lookups
QUERYING A DATABASE
- Join Data from Different Tables in a Query
- Sort and Filter Data in a Query
- Perform Calculations in a Query
CREATING ADVANCED QUERIES
- Create Parameter Queries
- Create Action Queries
- Create Unmatched and Duplicate Queries
- Summarize Data
GENERATING REPORTS
- Create a Report
- Add Controls to a Report
- Enhance the Appearance of a Report
- Prepare a Report for Print
CUSTOMIZING THE ACCESS ENVIRONMENT
- The Access Options Dialog Box
DESIGNING A RELATIONAL DATABASE
- Relational Database Design
- Create a Table
- Create Table Relationships
JOINING TABLES
- Create Query Joins
- Join Tables That Have No Common Fields
- Relate Data within a Table
- Work with Subdatasheets
- Create Subqueries
ORGANIZING A DATABASE FOR EFFICIENCY
- Data Normalization
- Create a Junction Table
- Improve Table Structure
Workshop Wrap-Up
At the end of the course, students will have an opportunity to ask questions.
