MTA : Materi Sertifikasi Internasional Database Administration Fundamentals(Exam 98-364)

Candidates for this exam are in the process of expanding their knowledge and skills in the following areas:

• core database concepts
• relational database concepts
• security requirements for databases and the data stored in them
• database objects, such as tables and views
• graphical tools and T-SQL scripts
• database queries
• stored procedures

 Objective domain :
A.  Understanding Core Database Concepts

1. Understand how data is stored in tables.
This objective may include but is not limited to: understanding what a table is and how it relates to the data that will be stored in the database; columns/fields, rows/records
2. Understand relational database concepts.
This objective may include but is not limited to: understanding what a relational database is,the need for relational database management systems (RDBMS), and how relations are established
3. Understand data manipulation language (DML).
This objective may include but is not limited to understanding what DML is and its role in databases
4. Understand data definition language (DDL).
This objective may include but is not limited to understanding how T-SQL can be used to create database objects such as tables and views

Microsoft Access : How to add, rename and delete a field in Datasheet view

How to add a field in Datasheet view :

1. On the Table Tools Fields tool tab, in the Add & Delete group, click the data type for the field you want to insert. Click More Fields to display an extended list of data types.
2. In the column heading row, enter a name for the field.

How to  rename a field in Datasheet  view :

1. Right-click the column heading for the field, and then click Rename Field.
2. In the highlighted area, enter the new name for the field .

How to delete a field in Datasheet view :

1. Right-click the column heading for the field, and then click Delete Field.
2. Click Yes in the prompt that Access displays to confirm that you want to delete the field.