NEW
Font size
WorksheetsAccess and Networking Basics
Total questions: 12
Worksheet time: 9mins
What is the first step in creating a table in Access?
Run a query to create a table.
Import data from an Excel spreadsheet.
Select a table design template.
Open Microsoft Access and create a new database or open an existing one.
Which data type in Access is used for whole numbers?
Float
DateTime
String
Integer
Name a common networking device that connects multiple computers.
Router
Switch
Modem
Access Point
What is the purpose of a primary key in a database table?
To group related records together in a table.
The purpose of a primary key is to uniquely identify each record in a database table.
To store large amounts of data efficiently.
To define the data type of each column in the table.
Which data type in Access is used for text?
Number
Currency
Short Text
Long Text
How do you save a table after creating it in Access?
Click 'Save' or press 'Ctrl + S'.
Press 'Alt + F4' to close Access.
Select 'Delete' to remove the table.
Click 'Close' to exit the table.
Which data type in Access can store dates and times?
Currency
Number
Date/Time
Text
How can you add a new field to an existing table in Access?
Open the table in Design View, add a new field in the next empty row, select data type, and save.
Change the table's name to add a field.
Export the table to a new format.
Delete an existing field from the table.
What is the role of a modem in a network?
To provide wireless connectivity to devices.
To store data for backup and recovery purposes.
The role of a modem in a network is to convert digital data from a computer into analog for transmission over phone lines and vice versa.
To amplify the signal strength of a network connection.
What is the function of a foreign key in a database?
To store images and multimedia files.
To define the maximum size of a table.
The function of a foreign key is to link two tables together.
To uniquely identify each record in a table.
How can you delete a table in Access?
Select the table and press 'Delete'.
Right-click the table and choose 'Delete'.
Click 'Close' to exit the table.
Export the table to a different format.
What is the purpose of a query in Access?
To format the layout of a report.
To back up the database.
The purpose of a query is to retrieve specific data from one or more tables.
To create a new database.
