COURSE OVERVIEW
MICROSOFT ACCESS
COURSE INSIGHT
Microsoft Access is a software for relational databases. This is the ideal tool when you start to expand your Excel server. By designing user-friendly forms with rules to protect your data integrity, you can achieve good collection results with Access. You can create queries and reports that can be regenerated whenever you require to evaluate and filter your data. The workshop themes will be database definitions, database preparation and a practical guide to tables, inquiries, forms and documents.
Microsoft Access is a database program that is “relational.” Relational means that we can tie data sets together, we can connect the data together. Consumers can keep track of patients, nurses, and the last time patients saw their physicians, what happened at each visit, and so on. Connection helps us to connect our information without the duplication that can take place elsewhere.
We deliver one of the best SAP professional training programs in the industry. Specialists with extensive experience in the field conduct the lessons on this subject. The curriculum fits perfectly with professional standards with the latest industry changes.
SAP MICROSOFT ACCESS COURSE OUTLINE
MODULE
- Basic Window Elements
- Exploring Office Backstage
- Working with the Ribbon
- Customizing the Quick Access Toolbar
- Working with KeyTips
- Using the Status Bar
- Getting Help
- What is an Access Database?
- Opening a Database File
- Exploring Database Objects
- Creating a Database
- Changing Views
- Printing Database Objects
- Saving and Closing a Database File
- What is a Table
- Working with Datasheets
- Moving Among Records
- Updating Records
- Adding Records to a Table
- Selecting Rows and Columns
- Finding Records
- Sorting Records
- Filtering Records
- Adding a Table to a Database
- Adding Fields to a Table
- Adding a Lookup Field
- Setting a Primary Key
- Using the Input Mask Wizard
- Saving Design Changes
- Importing Data
- Exporting Data
- Performing Database Maintenance
- What is a Query?
- Creating a Query
- Working with Queries
- Saving and Running a Query
- Creating Calculated Fields
- Using Agregate Functions
- Understanding Query Properties
- Creating Multi-Table Select Queries
- Joining Tables
- Enforcing Referential Integrity
- What is a Form?
- Using the Form Tool
- Creating a Form with the Form Wizard
- Working in Design View
- Changing the Form Layout
- Using Calculated Controls
- Working with Records on a Form
- What is a Report?
- What is a Report Tool?
- Previewing and Printing a Report
- Saving a Report
- Designing a Report
- Changing a Report Layout
- Understanding Controls
- Using a Calculated Control
- Analyzing Dependencies
- Creating Mailing Labels
- What is the Cloud?
- What is Office 365?
- Choosing the Right Plan
- Signing in with Microsoft Accounts
- Exploring the Interface
- Understanding OneDrive
- Office Online Overview
- Opening Files
- Saving Files
LOOKING FOR A
2-12 MONTHS
TRAINING?
CHOOSE
SAP MICROSOFT ACCESS
SKILLS GAINED
- Entering Record
- Rearrange and Add Fields
- Customizing a Query
- Create and Modify Grouped Report
- Create Schedule Query with Multiple Tables
Dates And Prices
Start Date | Timing | Days | Duration | Mode Of Training | Request Price/Future Dates |
---|---|---|---|---|---|
01.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
08.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
10.07.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
15.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
22.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
24.07.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
29.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
05.08.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
07.08.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
12.08.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
19.08.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
21.08.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
26.08.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
02.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
04.09.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
09.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
16.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
18.09.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
23.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
30.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online |