Week 4 Access Basic

The word "query" fits the given sentence structure and meaning. It means to ask questions or inquire about something. "Quarter" refers to a period of time or a section, and "quiter" is not a valid word. Therefore, "query" is the correct answer.

A primary key is a unique identifier that is used to uniquely identify each record in a database table. It ensures that each record in the table has a unique value for the primary key column, which helps in maintaining data integrity and enables efficient retrieval of data.

Access is a database management system that stores and organizes data. It allows users to create and manage databases, tables, forms, queries, and reports. With Access, users can input, store, retrieve, and manipulate data efficiently. It provides a user-friendly interface and powerful tools for data management, making it a popular choice for individuals and businesses to organize and analyze their data effectively.

The statement is false because Access is a database management system specifically designed for storing and managing large amounts of data, including customer data. Excel, on the other hand, is primarily a spreadsheet program that is better suited for calculations, data analysis, and creating visualizations. While Excel can also be used to store customer data, Access provides more advanced features and functionalities for organizing and querying large datasets, making it a more suitable choice for storing customer information.

The correct answer is "Record" because in the context of a table, a row represents a single record or entry. Each row contains a set of related data that corresponds to a specific entity or item being represented in the table. Therefore, "Record" is the most appropriate term to describe a row in a table.

In Access, a field refers to a single piece of data within a record, while a row in Excel refers to a complete set of data across all fields. Therefore, a field in Access is not the same as a row in Excel.

The correct answer is "Maintains Order And Structure." This answer suggests that a database is responsible for organizing and arranging information in a systematic manner. It ensures that data is stored in a structured format, making it easier to retrieve and analyze. By maintaining order and structure, a database helps in efficiently managing and accessing information, improving overall data management and decision-making processes.

The given correct answer for this question is "Redundant". Redundant means something that is unnecessary or repetitive. In the context of the question, putting data in over and over again is unnecessary and repetitive, as it implies that the data is being duplicated or repeated unnecessarily. Therefore, the term "redundant" accurately describes this action.

In addition to storing data, Access allows you to sort the data, extract specific information from the database, and summarize the data by performing calculations such as finding the sum or average of a set of values. These features are useful for organizing and analyzing large amounts of data in a database.

The given answer options are variations of the phrase "pre-built databases". They all refer to databases that are already created or constructed before being used. The options include different capitalization styles, but they all convey the same meaning.