Feinf Flashcards
(20 cards)
What is a hybrid topology?
A mix of two or more topologies. Connected at a node.
What is a record?
A row in a table (one complete set of data for one person or item).
What is DBMS?
Software used to create and manage databases (e.g., MS Access).
What are the two views under the ‘View’ icon in Access?
Design View and Datasheet View.
Which tab is used to import files into a database?
External Data tab.
What is a table?
A collection of related data (like student records).
What is a primary key?
A unique value that identifies each record (like Student ID).
What is a ring topology?
Devices form a loop. No central device. If ring breaks, network fails.
Which view shows the contents (data) of a table?
Datasheet View.
What are the common data types used in Access tables?
Autonumber, Number, Short Text.
Which tab do you click to create a relationship between tables?
Database Tools tab.
What is a field?
A column in a table (like ‘Name’ or ‘Age’).
What is a flat file database?
A single-table database (like a spreadsheet).
What is a foreign key?
A field that connects to a primary key in another table.
What is a star topology?
Devices connect to a central hub. If hub fails, entire network fails.
Which view shows the structure of a table?
Design View.
What is a bus topology?
Devices connect to a single cable (backbone). Cheap, but cable failure breaks the whole network.
Which tab do you use to access the Query Wizard?
Create tab.
Which tab do you click to create a table in a database?
Create tab.
What is a relationship in a database?
A connection between two or more tables.
