Microsoft Access Basics

What is Microsoft Access used for?

• Microsoft Access is used for creating and managing databases.

• Microsoft Access is used for word processing.

• Microsoft Access is used for creating and editing images.

• Microsoft Access is used for playing video games.

What is the first step in creating a database in Microsoft Access?

• Install Microsoft Access

• Open Microsoft Access

• Import data from Excel

• Create a new table

What is a table in Microsoft Access?

• A table in Microsoft Access is a graphical representation of data.

• A table in Microsoft Access is a tool for creating queries.

• A table in Microsoft Access is a feature for importing data from external sources.

• A table in Microsoft Access is a database object that stores data in rows and columns.

How can you create a new table in Microsoft Access?

• Go to the 'Create' tab, click on 'Table Templates', choose a template, and save the table.

• Go to the 'Create' tab, click on 'Blank Database', enter the table name, and save the table.

• Go to the 'Create' tab, click on 'Table Wizard', select the table type, and save the table.

• Go to the 'Create' tab, click on 'Table Design', define the table structure, and save the table.

What is a primary key in a table?

• A primary key in a table is a column that contains only unique values.

• A primary key in a table is a column or a set of columns that uniquely identifies each row in the table.

• A primary key in a table is a column that is used for sorting the data.

• A primary key in a table is a column that is optional and can be left empty.

How can you define a primary key in Microsoft Access?

• Right-click on the field and select Set as Primary Key.

• Open the table in Design View, select the field, and click on the Primary Key button.

• Use the SQL command ALTER TABLE to set the primary key.

• Go to the Table Tools Design tab and click on the Primary Key button.

What is a relationship in Microsoft Access?

• A relationship in Microsoft Access is a connection between two tables based on a common field.

• A relationship in Microsoft Access is a connection between two reports based on a common field.

• A relationship in Microsoft Access is a connection between two forms based on a common field.

• A relationship in Microsoft Access is a connection between two queries based on a common field.

How can you create a relationship between two tables in Microsoft Access?

• Create a new table and manually enter the relationship details, including the table names, field names, and relationship type.

• Open the database in Access, go to File, click on Relationships, drag and drop the tables, define the relationship by selecting related fields and specifying the type of relationship.

• Open the database in Access, go to Database Tools, click on Relationships, drag and drop the tables, define the relationship by selecting related fields and specifying the type of relationship.

• Use the SQL query language to write a query that establishes the relationship between the two tables.

What is a form in Microsoft Access?

• A form in Microsoft Access is a type of data table.

• A form in Microsoft Access is a graphical user interface (GUI) object that allows users to interact with the database.

• A form in Microsoft Access is a programming language.

• A form in Microsoft Access is a file format.

How can you create a form in Microsoft Access?

• Go to the 'Insert' tab and click on the 'Form' option.

• Right-click on the table and select 'Create Form'.

• Open a new blank form and manually design it using form controls.

• Go to the 'Create' tab and click on the 'Form Design' option.