Database Lesson 3 & 4 Study/Vocab

What is the process of adding information to a set of database fields called?

• Deleting Records

• Inserting Records

• Modifying Records

• Exporting Records

How can small amounts of data be entered into a database?

• Automatically through scripts

• Manually in Datasheet View or Form

• By using a barcode scanner

• Through a mobile app

What is a common method for importing a large number of records into a database?

• Typing each record manually

• Using a spreadsheet, another database, or a text file

• Scanning paper documents

• Taking photographs of records

What must be done when importing data to ensure it is correctly added to the database?

• Delete existing records

• Map corresponding fields

• Change the database format

• Print the data

What is the purpose of preparing data to be used in another application?

• To delete unnecessary files

• To enhance data security

• To ensure compatibility with different software

• To improve data accuracy

What is the function of running a query in the context of exporting records?

• To delete data

• To create a table with the appropriate information

• To encrypt data

• To compress files

Which file formats are mentioned for exporting functions?

• .doc, .pdf, .jpg

• .html, .xml, .json

• .txt, .csv, .xlsx

• .mp3, .wav, .flac

What is the purpose of updating records in a database?

• To delete all data

• To create a new database

• To update or modify information in an existing set of fields

• To print the data

Which view is used for limited amounts of data when updating records?

• Graph View

• Datasheet View

• Chart View

• Form View

What is used for larger sets of data when updating records?

• Excel routine

• SQL routine

• Word routine

• PowerPoint routine