Database Lesson 3 & 4 Study/Vocab

Front

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

Back

Inserting Records

Front

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

Back

Manually in Datasheet View or Form

Front

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

Back

Using a spreadsheet, another database, or a text file

Front

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

Back

Map corresponding fields

Front

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

Back

To ensure compatibility with different software

Front

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

Back

To create a table with the appropriate information

Front

File formats mentioned for exporting functions: .doc, .pdf, .jpg; .html, .xml, .json; .txt, .csv, .xlsx; .mp3, .wav, .flac.

Back

.txt, .csv, .xlsx

Front

What is the purpose of updating records in a database?

Back

To update or modify information in an existing set of fields

Front

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

Back

Datasheet View

Front

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

Back

SQL routine