IT

• Which of the following data types enables you to insert or embed the objects created in the applications into an Access Database?


  OLE Object
• The association that is created between tables when they are joined is called a

  Relationship
• One of the functions of a wizard


  To guide you through the steps required to perform a task
• DBMS is comprised of tables that are made up of rows called ... and columns called ...

  records, fields
• Are the personal name, last name, or the person's address the primary source?

  No
• The functions of a form of database


  To control access to data, automate frequently performed actions, and make the database more user-friendly
• Is " Enter data in a table" a function of a form of database?

  No
• A column in a database is called a

  Field
• Which data type includes the alphabet and numbers?

  Text
• What is used to uniquely identify each record in a table?

  Primary key
• What is a collection of data is stored electronically as a series of records in a table?

  Database
• The common data elements in order from smallest to largest

  Field, Record, File, Database
• Definition of a database

  A file that stores and organises large amount of related data
• What purpose of Wizard view of a table?

  To modify the design of a table, like modifying the name of a field or changing the data type of a field
• Describe the datasheet view of a table

  To display online data arranged in rows (ngang) and columns (dọc) in a web broswer.
• Show two properties of a field enables you to simplify the task of data entry and control the values that users enter for a field


  Validation Rule and Input Mask
• What is called a script used to automate certain functionality inside MS Access?Describe its usefulness.


  Macro which automates repetitive tasks, reduces the risks, high effection
• What is the purpose of forms?

  It provides a user-friendly interface for entering data into tables
• What database objects allow to search for information and then display the result?

  Query
• Is a database a file of related records stored in tables?

  Yes
• In a database, what type of database contains tables linked by common fields?


  Relational databse
• A single set of related data values is referred to as

  Record
• The background of the design view

  To give more detailed view of the structure of a form
• There is a form view of a database. What does it show?

  A record
• Which is a valid data type in Access?

  Text, Currency, Number
• Which objects are used to create a form?

  Tables and Queries
• There are more ... than ...

  Records / Tables
• What is the file type extension for an MS Access Database?

  ACCDB
• What DBMS has been used for this Database Design unit?

  SQL
• What data type would generally occupy the most space?

  Attachment
• __________ refers to raw facts, including text and graphics.These are the items we store in the tables of the database. However, ________ has some meaning to itand is used by people for a specific purpose.

  Data / Information
• The most common view database is form and list.
• List three examples of databases in which data is edited frequently. 

  E-commerce, Social Media, Streaming Service
• What criteria could be used to search a library catalog? 

  title, author, language, publication date, ISBN (the unique identifier), topic
• Difference between a query and a filter in a database.

  A query is used to find matching documents and calculate how relevant, which influences the results. A filter is a faster operation that checks the document's criteria and doesn't influence the scores.
• Give three examples of calculations that can be carried out by databases. 

  Aggregation, Data selection and filtering, Complex computations
• What is the difference between validation and verification? 

  Validation is to check the punctuation and the high level of quality. Otherwise, Verification is to check the achievements, results without any bugs.
• Definition of redundant data. How to eliminate it?

  the duplication (same) of data within a database Elimination: using primary keys, and avoiding storing the same information in multiple places.
• What are some of the most common methods of storing database files? 

  Non/ Relational, Cloud storage