MS Access - Tables And ForMS | Attempts: 2027

Reviewed by Editorial Team

The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.

Learn about Our Editorial Process

| By Mr_smcguire

Mr_smcguire

Community Contributor

Quizzes Created: 1 | Total Attempts: 2,026

| Attempts: 2,027

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

1/14 Questions

A database is
- A piece of computer software
- Microsoft Access
- Data kept in a logical structure of records and fields
- A place to keep information

About This Quiz

This is a quick quiz to test your basic knowledge of MS Access forms, tables and data types.

2.

A piece of data is kept in
- A paddock
- The hard drive
- A field
- A cell
Correct Answer

A. A field

Explanation

In the context of data storage, a "field" refers to a specific location or container where a piece of data is stored. It is a logical concept used in databases or spreadsheets to represent a single value or attribute. Unlike a paddock, which is a large enclosed area for livestock, or a hard drive, which is a physical device used for data storage, a field is a virtual space within a database or file structure. Similarly, a cell is a term commonly used in spreadsheets to refer to a single intersection point within a table, containing a specific value.

Rate this question:

2
3.

A record is
- An old-school way of listening to music but it's coming back
- Information about a person
- A row of data that relates to a single object
- Found online
Correct Answer

A. A row of data that relates to a single object

Explanation

The correct answer is "A row of data that relates to a single object." In the context of databases and data management, a record refers to a collection of related data fields or attributes that pertain to a specific entity or object. It can be seen as a row in a database table, where each column represents a different attribute or characteristic of the object being described. This definition aligns with the given answer choice.

Rate this question:

1
4.

Every record must have a primary key number / identifier
- True
- False
Correct Answer

A. True

Explanation

Every record in a database must have a primary key number or identifier. This primary key uniquely identifies each record in the database and ensures that there are no duplicates. It is essential for maintaining data integrity and for efficient retrieval and manipulation of data. Without a primary key, it would be challenging to manage and organize the records effectively. Therefore, the statement is true.

Rate this question:

2
5.

Design view
- Lets us enter data into our table
- Helps to create the table's structure
- Is only for forms
- Is for searching our data
Correct Answer

A. Helps to create the table's structure

Explanation

The design view in a database allows us to create the structure of a table. It provides a visual interface where we can define the columns, data types, and other properties of the table. By using the design view, we can easily set up the layout and organization of our table, ensuring that it meets our specific requirements.

Rate this question:

1
6.

To enter data into a table we need to be
- Connected to the internet
- Using every field
- Creating a primary key
- In datasheet view
Correct Answer

A. In datasheet view

Explanation

To enter data into a table, it is necessary to be in datasheet view. Datasheet view is a tabular view that allows users to input and manipulate data directly into the table. It provides a grid-like interface where each row represents a record and each column represents a field. In datasheet view, users can easily navigate between fields and records, add new records, edit existing data, and perform other data entry tasks. Therefore, being in datasheet view is the correct answer as it is the specific view designed for entering data into a table.

Rate this question:

2
7.

What is a data type in databases?
- Types of data including: date, currency, autonumber & text
- A yes or no option
- The unique identifier for a record
- A special font
Correct Answer

A. Types of data including: date, currency, autonumber & text

Explanation

A data type in databases refers to the classification or category of data that determines the kind of values that can be stored in a particular field or column. It specifies the format and size of the data, allowing the database to understand how to handle and manipulate it. The given answer correctly identifies the various types of data that can be stored in a database, including date, currency, autonumber, and text. These data types are commonly used to represent different kinds of information and facilitate efficient data storage and retrieval.

Rate this question:

1
8.

This is an example of
- A table
- A form
- A database
- Book Information
Correct Answer

A. A form

Explanation

This question is asking for the correct classification of the given information. Based on the provided options, "a form" is the most suitable classification for the given information. This is because the term "Book Information" suggests that the information is being collected or displayed in a structured format, which is typically done through a form. A table could also be a possibility, but since the question specifies a single correct answer, "a form" is the most appropriate choice.

Rate this question:
9.

To make sure people enter only clean data we
- Lock the database
- Create validation rules
- Make forms
- Make sure that we only use text as our data type
Correct Answer

A. Create validation rules

Explanation

Creating validation rules is a method used to ensure that the data entered into a database meets certain criteria or constraints. By implementing validation rules, we can enforce data integrity and accuracy by specifying what type of data is allowed, setting minimum and maximum values, or defining specific formats. This helps to prevent the entry of incorrect or invalid data, ensuring that only clean and valid data is stored in the database.

Rate this question:

1
10.

Which one of these is not an example of a form design view?
- Layout View
- Design View
- Form View
Correct Answer

A. Form View

Explanation

Form View is not an example of a form design view because it is the view that allows users to interact with and enter data into the form, rather than designing or modifying the form layout or design. In Form View, the form is displayed as it would appear to the end user, with all the controls and fields ready for data input. It is the view that is used to fill out and submit the form, rather than designing or editing its structure or appearance.

Rate this question:

3
11.

This is an example of
- A table
- A form
- A database
- Book Information
Correct Answer

A. A form

Explanation

This question is asking for the type of information that is being presented. The given answer, "a form," suggests that the information is being presented in a structured format that allows users to input or retrieve data. A form is commonly used to collect or display information in a user-friendly manner, making it a suitable explanation for the given answer.

Rate this question:
12.

Which of these is not a sufficient reason for creating forms?
- Forms help with accurate data input
- Forms display record by record
- Forms can have pictures on them
- Forms provide a user-friendly way to manage Databases.
Correct Answer

A. Forms can have pictures on them

Explanation

Forms can have pictures on them is not a sufficient reason for creating forms because the purpose of creating forms is to facilitate accurate data input, display records in a user-friendly manner, and provide a user-friendly way to manage databases. While forms can indeed have pictures on them, this feature alone does not justify the need for creating forms.

Rate this question:
13.

In order to shift my fields and boxes around I need to be in
- Form view
- Layout view
- Design view
Correct Answer

A. Layout view

Explanation

The correct answer is "layout view" because in layout view, you can easily move and rearrange fields and boxes in your form. It allows you to see the overall layout of your form and make adjustments to the positioning and alignment of the elements. This view is specifically designed for editing the visual layout of the form without making any changes to the underlying structure or properties.

Rate this question:

2
14.

Which option is the best option for creating a form from the data you already have?
- Form
- Form Design
- Blank Form
- Form Wizard
Correct Answer

A. Form

Explanation

The best option for creating a form from the data you already have is the "Form" option. This option allows you to create a form using the existing data, without any predefined design or layout. It provides flexibility in customizing the form according to your specific requirements, making it the most suitable choice for creating a form from the available data.

Rate this question:

1