Search In This Website

Jumat, 29 Agustus 2025

Certain Content In The Database Has Been Disabled In Microsoft Access

  1. After you open the Microsoft Office Access Database.
  2. Then you see the Message Bar consist of "Certain content in the database has been disabled" is displayed on Microsoft Office Access.


  3. On the Message Bar, click Options.

  4. Choose Enable this content.
  5. Then click OK button.


Selasa, 26 Agustus 2025

Microsoft Office Excel Lesson Topics List

Excel Basics:

Understanding The User Interface

Navigating The Workbooks

to Understanding The User Interface, click :


Cell and Data Management:

Entering different types of data (text, numbers, dates).

Inserting And Deleting cells, rows, and columns.

Using Cut, Copy, and Paste functions.

Using the Fill Handle.

Formatting:

Adjusting column width and row height.

Applying font styles, borders, and cell shading.

Using Number Formats (currency, percentage, date).

Saving and Sharing:

Saving Workbooks

Printing Workbooks

Sharing Workbooks with others.

Introduction to Formulas - Formulas and Functions:

Understanding the formula syntax (starting with =).

Performing basic calculations (addition, subtraction, multiplication, division).

to learn Understanding the formula syntax (starting with =), click:

Cell References - Formulas and Functions:

Understanding Relative vs. Absolute cell references ($).

Using Mixed cell references.

Essential Functions - Formulas and Functions:

SUM(), AVERAGE(), COUNT(), COUNTA(), MAX(), MIN().

IF() statements for logical tests.

VLOOKUP() and HLOOKUP() for finding data.

to learn SUM(), AVERAGE(), COUNT(), COUNTA(), MAX(), MIN(), click Fungsi MIN Pada Excel

More Advanced Functions - Formulas and Functions:

INDEX() and MATCH() as a powerful alternative to VLOOKUP.

TEXT(), CONCATENATE(), and other text functions.

Date and Time functions.

Sorting and Filtering - Data Management and Analysis:

Sorting data by one or multiple columns.

Applying filters to show only specific data.

Creating Tables

Charts and Graphs:

Creating various chart types (bar, line, pie).

Customizing chart elements like titles, labels, and axes.

Conditional Formatting: Highlighting cells based on specific rules (e.g., values greater than 100).

PivotTables: Creating a PivotTable to summarize and analyze large datasets.

Advanced Topics

Data Validation: Setting rules for data entry in a cell to prevent errors.

What-If Analysis: Using tools like Goal Seek and Data Tables.

Macros and VBA:

Introduction to the Visual Basic for Applications (VBA) editor.


<< back to Study About Microsoft Office 1


Travel Through Microsoft Word Objects

Microsoft Office Word Objects Structure

Here is a breakdown of the key objects in Microsoft Office Word:
  • Application Object
    • Documents Collection and Document Object
    • Sections Collection & Section Object 
    • Paragraphs Collection & Paragraph Object
    • Tables Collection & Table Object
      • Rows Collection, Row Object, Columns Collection, Column Object, & Cell Object
    • Range Object
    • Selection Object
    • Find Object & Replacement Object
    • Shapes, InlineShapes, and TextBoxes


Bibliography

https://learn.microsoft.com/ ( manual ebook )

Senin, 25 Agustus 2025

Add Image In Markdown

This article is to add an image in Markdown file.

Block Image In Markdown

A block image is displayed as a discrete element (on its own line), in a document. A block image is start by an exclamation mark (!), followed by alt text in brackets, and the path or URL to the image asset in parentheses. You can optionally add a title in quotation marks after the path or URL, entered on a line by itself, and then followed by an empty line.

![Alt text for screen readers](path/to/image.png "Optional title text")

Type this following Markdown code sample in Markdown editor:
Content in document.

![logo](logo.jpeg "logo")

Content in document

Result ( similar like this following ) :

Content in document.
Content in document

Notes

  • To insert a block image, type the image target name directly followed by two parentheses ().
  • Enter the image file alternative text. Type a pair of square brackets ([]) directly after the exclamation mark (!).



next click Markdown Link 1 >

markdown, lightweight markup syntax, lightweight markup document, lightweight markup language, image, picture, figure, illustration, photo, graphic

Related Post


How To Start MySql From Command Line

How To Start MySQL Server From Microsoft Command Line In Microsoft Windows 8.1

  1. Open your Microsoft Windows Command Line As Administrator.
    To learn how to open Microsoft Windows Command Prompt, click
    How To Launch Command Prompt
    or
    How To Launch Command Prompt In Windows 8
  2. Go To MySQL Server directory
    Type D: and press Enter.
  3. Type CD \softRun\xampp-win32-1.6.7\mysql\bin\


  4. Type this following command:
    mysqld --console
  5. Press Enter
  6. This will display mysqld status, mysql version and mysql port.


Notes
  • In the Step 2 and 3, adjust the path based on your MySQL installation. To learn how to Go to MySQL directory, click Top Command Prompt (CD / CHDIR)
  • In the Step 6, it maybe display different with your MySQL.

How To Find Out Is Mysql Running?

  1. Open your Microsoft Windows Command Line As Administrator.
    To learn how to open Microsoft Windows Command Prompt, click
    How To Launch Command Prompt
    or
    How To Launch Command Prompt In Windows 8
  2. Go To MySql Server directory
    Type D: and press Enter.
  3. Type CD \softRun\xampp-win32-1.6.7\mysql\bin\

  4. Type this following command:
    mysqladmin --user=root ping
  5. Press Enter
  6. This will display mysqld status is alive.

Notes
  • In the Step 2 and 3, adjust the path based on your MySQL installation. To learn how to Go to MySQL directory, click Top Command Prompt (CD / CHDIR)
  • In the Step 4, adjust root to your username.

How To Find Out Is MySQL Running In The Right Port According To Our Preferences?

  1. Open your Microsoft Windows Command Line As Administrator.
    To learn how to open Microsoft Windows Command Prompt, click
    How To Launch Command Prompt
    or
    How To Launch Command Prompt In Windows 8
  2. Type this following command:
    netstat -ano | findstr 3306
  3. Press Enter
  4. This will display ip address and port status is LISTENING.


Notes
  • In the Step 2 and 3, adjust the 3306 with your port.
< to check MySql version, click How To Check MySQL Version

Rabu, 20 Agustus 2025

Daily English Sentences

Learning Direction: 

  • Read each the sentences clearly!
  • Mark the matching question and answer!

Are you ... (feeling, e.g. happy)?

Can I help you with anything?

Can you help me with this?

Do you have any plans for tomorrow?

Do you have any siblings?

Do you like ... (favourite, e.g. food, season, travel)?

Do you speak ... (language, e.g. English)?

Do you understand?

Good ... (daylight, e.g. morning, afternoon)!

How are you today?

How are you?

How old are you?

How was your weekend?

I am a/an ... (job/profession, e.g. doctor, shopkeeper)

I am good, thank you.

I am sorry for the delay.

I feel sick.

Is It [day: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday]?

It is [day: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday].

It is [time].

I want to ... (plans e.g. fix our plumber, cleaning the second floor tile etc.) tomorrow.

My name is ...

My hobby is ... (e.g. sport, art, etc.).

No, I am not ... (feeling e.g. happy).

No, I don't understand.

No, You cannot help me.

Sorry, I cannot help you.

Sorry, I cannot speak ... (language, e.g. English).

Sorry, I don't know.

Sorry, I do not understand.

What are your hobbies?

What day is it today?

What do you do?

What is your favourite ... (e.g. food, season, travel)?

What is your name?

What time is it?

Where are you from?

Would you like some ... (beverage, e.g. tea)?

Yes, I can speak ... (language, e.g. English).

Yes, I am ... (feeling e.g. happy).

Yes, I am understand.

Yes, I have [brother/sister].

Yes, of course. I want ... (quantifier of measurement e.g. a cup of) ... (beverage, e.g. tea).

Yes, You can help me to ... (activity, e.g. bring this book).


<< back to Learn English


Bibliography

https://ilmish.com/

https://mrmrsenglish.com/

https://pinterest.com/


Related Post

Common Date Format

People At School