Microsoft Access Overview

Front

Microsoft Access là gì?

Back

Microsoft Access là một hệ thống quản lý cơ sở dữ liệu phù hợp cho các tổ chức nhỏ, doanh nghiệp hoặc người dùng cá nhân.

Front

What does the navigation pane display in Access?

Back

The navigation pane displays the objects within a database.

Front

How do you create a new database in Access?

Back

To create a new database, launch Access, select 'New', choose 'Blank desktop database', rename the file, and click 'Create'.

Front

What is the default data type for the first field in Access?

Back

The default data type for the first field is 'ID' with the data type 'AutoNumber'.

Front

What are the two views available for tables in Access?

Back

The two views are Design View and Datasheet View.

Front

What is a primary key in Access?

Back

A primary key is a field that uniquely identifies each record in a table.

Front

What is the purpose of a lookup field in Access?

Back

A lookup field allows users to select a value from a list instead of typing it in.

Front

What is a form in Access?

Back

A form is a database object that allows users to enter, modify, and view records.

Front

What is the purpose of a query in Access?

Back

A query is used to retrieve specific data from one or more tables.

Front

What is a report in Access?

Back

A report is a formatted presentation of data from the database, typically used for printing.