MS Access Flashcard Set

Front

What is Microsoft Access?

Back

A relational database management system (RDBMS) developed by Microsoft, part of the Microsoft Office suite.

Front

What are the main objects in MS Access?

Back

Table, Query, Reports, Forms.

Front

What is a Table in MS Access?

Back

A set of related information used to store, organize, and manage data.

Front

How do you open Microsoft Access?

Back

Click in the search bar, type 'Access', and press ENTER.

Front

What is a Record in MS Access?

Back

A complete set of information, found in rows.

Front

What is the maximum number of characters for a field name in Access?

Back

64 characters.

Front

What is a primary key in Access?

Back

A field or set of fields with unique values throughout a table.

Front

What is a Data Type in Access?

Back

It determines what kind of data a field can store.

Front

What are the two views in Access?

Back

Datasheet View and Design View.

Front

What is Datasheet View?

Back

Allows viewing and editing data in a table, similar to a spreadsheet.