About this course
Course-kan waxaad ku baran doontaa qaybaha kala duwan ee MS Access-ka - Tables,Queries,Forms,Reports.
Course-kan waxaan ugu tala galnay dhammaan heerarka waxaan kasoo bilaabi doonaa aasaaska inaka oo gaadhsiin doona meel sare (Advanced), Ugu dambayn waxaan samayn doonaa Project ama System Dhammaystiran oo dhammaan objects-ka accessku ka dhex muuqdaan.
Comments (0)
Introduction
3 Parts
Introduction to Microsoft Access
-
Getting Started to Microsoft Access
-
Different Ways to Create a Table
-
User and Login Forms
6 Parts
Creating User Table and Dashboard
-
Making Users Form and Login Form
-
Coding Login Button
-
Connecting Login Form to Dashboard
-
Designing Login Form
-
Designing User Form
-
Reports
4 Parts
Designing
-
Customizing Report
-
Adding Total Amount Using SUM
-
Adding Print Button
-
Forms
13 Parts
Creating Form
-
Different ways for Form Creation
-
Explaining Form, Layout, Design, Views and Property Sheet
-
Designing and Arranging
-
Adding buttons and designing
-
Copying Form from Another
-
Adding Auto ID to a form
-
Generating specific customer sales
-
Combining Customer and Order Forms
-
Customizing Customer Sales
-
Using Refresh Record
-
Designing Add New Button
-
Search Box
-
Relationships
7 Parts
Making Tables
-
Relationship Creation
-
Enforce Referential Integrity
-
Cascade Update and Cascade Delete
-
Creating Invoice
-
Adding Total Column
-
Relationship Creation with smooth way
-
How to use SQL View?
8 Parts
Create and Insert
-
Update , Delete , Drop
-
How to use SELECT Command
-
SELECT Command with IN Operator
-
SELECT Command With NOT IN, Greater than , Less than , Between Operators
-
Filtering with LIKE
-
Parameters
-
Parameters with LIKE operator
-
Action Queries
5 Parts
Make Table
-
Append Query
-
Update Query
-
Delete Query
-
How to use Totals
-
Query
11 Parts
Query Wizard
-
Query Design
-
Using Criteria , Sort , Show
-
Using Or
-
Combination with AND and OR
-
String Concatenation
-
Filtering Using Like
-
Parameter Query
-
Parameter Query with Comparison Operators
-
Parameter Query Using BETWEEN
-
Parameter Query with Using LIKE
-
Working with Table
5 Parts
Inserting Data into Table From ChatGPT
-
Sort & Filter
-
Record Section - New, Save , Totals & More
-
Find , Replace Go To, Select
-
Text Formatting
-
Access Data Types
3 Parts
AutoNumber , Short Text, Long Text
-
Number, DateTime, Currency
-
YesNo, Lookup WIzard , Calculated , Hyperlink
-
Adjusting The Project
5 Parts
Adjusting Project
-
Adjusting Buttons Using Hover and More Styles
-
More Adjusting
-
Increasing Decimal Places
-
Logout Button and Hiding User to Customize Project
-

0
0 Reviews