Introduction: Creating An Access Database

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Acooper
A
Acooper
Community Contributor
Quizzes Created: 6 | Total Attempts: 4,296
Questions: 20 | Attempts: 304

SettingsSettingsSettings
Database Quizzes & Trivia

This quiz reviews the terminologies and procedures used in creating an Access Database.


Questions and Answers
  • 1. 

    I am a program used to organize and manipulate data. I consist of fields, records, tables, queries and reports. What am I?

    • A.

      I am an Spreadsheet program

    • B.

      I am a word processing program

    • C.

      I am a database program

    • D.

      I am a Web Page Designing program

    • E.

      I am a Desktop Publishing program

    Correct Answer
    C. I am a database program
    Explanation
    The given correct answer, "I am a database program," aligns with the description provided in the question. A database program is used to organize and manipulate data, consisting of fields, records, tables, queries, and reports. This type of program is specifically designed for managing and storing large amounts of data efficiently.

    Rate this question:

  • 2. 

    With database management systems, you need to create your tables before you can enter data. What are the options when creating a new database table? i.File , new database, table ii Create table in design view iii Create table by using wizard iv Create table by entering data

    • A.

      I and ii only

    • B.

      Iii and iv only

    • C.

      I only

    • D.

      Ii, iii and iv

    • E.

      Iii only

    Correct Answer
    D. Ii, iii and iv
    Explanation
    The options when creating a new database table are ii) Create table in design view, iii) Create table by using wizard, and iv) Create table by entering data. These options allow the user to design the structure of the table using design view, utilize a wizard to guide them through the table creation process, or directly enter the data into the table. Option i) File, new database, table is not a valid option for creating a new database table.

    Rate this question:

  • 3. 

    The table structure of a database refers to which of the following?i Field name ii Data Type iii Description

    • A.

      I and ii only

    • B.

      Ii and iii only

    • C.

      I, ii, and iii

    • D.

      I and iii only

    • E.

      None of the above

    Correct Answer
    C. I, ii, and iii
    Explanation
    The table structure of a database refers to the combination of field name, data type, and description. The field name represents the name of each column in the table, the data type specifies the type of data that can be stored in each column, and the description provides additional information about each column. Therefore, all three options i, ii, and iii are correct as they collectively define the table structure of a database.

    Rate this question:

  • 4. 

    A ______________________ is the foundation for all queries, forms, and reports. The container for all these objects is the database.

    Correct Answer
    table
    Explanation
    A table is the foundation for all queries, forms, and reports in a database. It serves as the container for all these objects, providing a structured way to store and organize data. Tables consist of rows and columns, allowing for the storage of various types of information. Queries, forms, and reports rely on the data stored in tables to perform operations, retrieve information, and present it in a meaningful way. Without a table, the database would lack the necessary structure and organization required for effective data management.

    Rate this question:

  • 5. 

    True or False: When entering information into your database records, you can leave data out of a field if it is not available

    Correct Answer
    True
    Explanation
    When entering information into a database record, it is possible to leave a field blank if the data for that field is not available. This is because not all fields in a database may be mandatory, allowing for flexibility in data entry. Leaving a field blank can indicate that the information is missing or unknown, and it does not necessarily invalidate the rest of the data in the record.

    Rate this question:

  • 6. 

    When you create a table, you specify the data type for each field in the Table Design View. Text, Number, Date/Time, Currency, and Yes/No data types are self-explanatory. AutoNumber, increments each record by one. While Text fields can only contain up to 255 characters, Memo can include over 65,000 characters. OLE Objects enable you to insert graphics, sounds, and other data types. The Lookup data type will enable you to choose from a list of options. The Hyperlink data type enables you to launch an Access object (a table, form, query, and so on), another file in another application, or go to a Web site. Knowing all this Natavia is creating a database to store data on her friends, a sort of personal address book. She wants to include a field to specify which district in Belize is her friends favorite of all the lovely districts in Belize. Her best data type option would be ___________.

    Correct Answer
    lookup
    Lookup
    Explanation
    Natavia's best data type option for including a field to specify her friend's favorite district in Belize would be the "Lookup" data type. This data type would enable her to choose from a list of options, allowing her to easily select the specific district that her friend prefers.

    Rate this question:

  • 7. 

    True or False:You can change a field's data type but, depending on the particular conversion, this process can lead to data loss.

    Correct Answer
    True
    Explanation
    Changing a field's data type can indeed lead to data loss depending on the particular conversion. This is because different data types can store different ranges of values and have different levels of precision. When converting a field to a data type that has a smaller range or less precision, some of the original data may not be able to be accurately represented in the new data type, resulting in data loss. It is important to carefully consider the potential implications and limitations before changing a field's data type.

    Rate this question:

  • 8. 

    True or False: When you first create a field in Table Design View, the field is automatically set to text and the default text field size is 50.

    Correct Answer
    True
    Explanation
    When creating a field in Table Design View, the field is automatically set to text. The default text field size is 50 characters. This means that if no specific data type or size is specified for the field, it will default to a text field with a size of 50 characters.

    Rate this question:

  • 9. 

    A ______________________ is a database file that contains no objects or data. It is an empty shell that you will use to add new tables, queries, forms, and reports.

    Correct Answer
    blank database
    Explanation
    A blank database is a file that serves as a starting point for creating a new database. It does not contain any pre-existing tables, queries, forms, or reports. Instead, it acts as an empty shell where users can add and customize these elements according to their specific needs and requirements. This allows for a flexible and tailored approach to database creation, as users can design and structure the database from scratch.

    Rate this question:

  • 10. 

    True or False: You can create a new database that is blank or let the Database Wizard create one for you that contains the objects you specify for it.

    Correct Answer
    True
    Explanation
    You can create a new database that is blank or let the Database Wizard create one for you that contains the objects you specify for it. This means that you have the flexibility to either start with a completely empty database or use the Database Wizard to automatically generate a database with pre-defined objects based on your specifications.

    Rate this question:

  • 11. 

    True or False: When you use a wizard, Access enables you to choose from sample fields and then create the tables, queries, forms, reports, and switchboards for you.

    Correct Answer
    True
    Explanation
    When using a wizard in Access, it provides the option to select from pre-defined sample fields and automatically generates tables, queries, forms, reports, and switchboards based on the chosen fields. This feature helps users quickly create a functional database without having to manually design and build each component individually.

    Rate this question:

  • 12. 

    Decimal places are basically the numbers after the decimal point (for example, 44 becomes 44.00 when you add two decimal places). When you work with numbers, having all related numbers with the same number of decimal places adds to the professional appearance of your output. Changing the number of decimal places only adds to the visual appearance of a number, not to its _________________.

    Correct Answer
    value
    Explanation
    Changing the number of decimal places only adds to the visual appearance of a number, not to its value. This means that increasing or decreasing the number of decimal places does not change the actual numerical value of the number. It only affects how the number is displayed or represented. The value of a number remains the same regardless of the number of decimal places it has.

    Rate this question:

  • 13. 

    Fredrick created a field called fullname in a table. This field was created to hold the persons full name. Fredrick later decided that this was not practical and decided to change the table design to add fields for first name and last name. This would be an example to show that if you no longer needed a field, you can ____________ it.

    Correct Answer
    delete
    remove
    erase
    edit
    alter
    Explanation
    If you no longer need a field in a table, you can delete, remove, erase, edit, or alter it.

    Rate this question:

  • 14. 

    The ______________________________ property provides information or notes about fields in tables, and queries. ___________________ can be up to 255 characters in length.

    Correct Answer
    description
    descriptions
    Explanation
    The description property is used to provide information or notes about fields in tables and queries. These descriptions can be up to 255 characters in length.

    Rate this question:

  • 15. 

    You can set the field properties in Table ______________ View. Properties include name, data type, description, field length, validation rules, default values, and whatever you see on the General or Lookup tabs in table design.

    Correct Answer
    design
    Explanation
    In order to set the field properties in a table, you need to access the "design" view. This view allows you to customize various properties such as the name, data type, description, field length, validation rules, default values, and other options that are visible on the General or Lookup tabs in table design.

    Rate this question:

  • 16. 

    Field size for text data type fields determines the ______________ number of characters you can enter for a field. You can set the field size for text up to 255 characters and the default is 50 characters unless you change the default.

    Correct Answer
    maximum
    Explanation
    The field size for text data type fields determines the maximum number of characters that can be entered for a field. The maximum field size for text is 255 characters, but the default field size is 50 characters unless it is changed.

    Rate this question:

  • 17. 

    A convenient place to create the structure of your database tables is Table ________________. This is where you add and remove fields, and it serves as a convenient place for getting an overview of the properties associated with your fields and table.

    Correct Answer
    design view
    Explanation
    The design view is a convenient place to create the structure of your database tables. In this view, you can easily add and remove fields, and it provides an overview of the properties associated with your fields and table. It allows you to visually design and organize your database tables, making it easier to manage and understand the structure of your database.

    Rate this question:

  • 18. 

    To modify a table, you must select that table in the Database window and open the table in the Table ____________________. In this view you can add or remove fields; change field names; change a field's data type; and add, modify, or delete descriptions, field properties, and table rules.

    Correct Answer
    design view
    Explanation
    To modify a table, you must select that table in the Database window and open the table in the Table design view. In this view, you can make various changes to the table such as adding or removing fields, changing field names, modifying the data type of a field, and managing descriptions, field properties, and table rules. The design view provides a graphical interface that allows users to easily make structural changes to the table.

    Rate this question:

  • 19. 

    ___________________ can be used to answer questions themselves, but can also be used as the foundation for forms and reports.

    Correct Answer
    Queries
    Explanation
    Queries can be used to answer questions themselves by retrieving specific information from a database. They can also be used as the foundation for forms and reports, as they provide a way to organize and present data in a structured manner. Queries allow users to filter, sort, and perform calculations on data, making them a versatile tool for data analysis and presentation.

    Rate this question:

  • 20. 

    In datasheet view a row represents a _________________.

    Correct Answer
    field
    Explanation
    In datasheet view, a row represents a field. Each row in the datasheet view corresponds to a specific field in the database. The fields are organized in columns, and each row represents a separate record or entry in the database. This allows for easy viewing and manipulation of data in a tabular format, with each row representing a distinct field value.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 18, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 26, 2009
    Quiz Created by
    Acooper

Related Topics

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.