Microsoft Access
Each ____ Represents a “Record.”
Row
What is a database?
A structured set of data
What does SQL stand for?
Structured Query Language
What does GPS stand for?
Global Positioning System
What view should we use when editing fields of a table?
Design View
All data in a database is stored within a...?
Table
What is the purpose of the SELECT statement in SQL?
To retrieve data from a database
Information about your body can be stored in a database to identify you. This information is referred to as…?
Biometrics
When editing a table, how many close/exit buttons would you expect to see on Microsoft Access?
Two
What is the main purpose of a database management system?
To manage and organise data efficiently
What does * indicate in an SQL statement?
All/Everything
What is an example of a non-computerised database?
A dictionary, a phone book, a collection of recipes, TV guide, etc....
What Dungeons & Dragons Class will you find in Microsoft Access?
Wizard
Other than entering data manually into a table, how can you populate a database?
Using forms
How would I select a column named "FirstName" from a table named "Persons"?
SELECT FirstName FROM Persons
What is the database used by the information commons called?
A library catalogue system
What AI tool does Microsoft Access use?
None
When would you use a Database instead of a Spreadsheet?
When you are working with large or complex datasets
Which SQL statement is used to insert new data in a database?
INSERT INTO
List three things that an online store would hold in a database.
Product details, Customer information, Order details, Transaction history, User account information, Reviews and ratings for products, Shipping and tracking information, Promotions and discounts, Website analytics data