Font size
WorksheetsMs Access Databases
Total questions: 20
Worksheet time: 20mins
The Primary Key is a unique value for that column and hence, it cannot be the same for two ________________.
Fields
records
Data
None of these
To create a table, click on Create and then
Forms
reports
queries
Table
The Primary Key is a __________ identifier for a record
Distinct
unique
None of these
Which field has primary key in the given table
Address 1
CustomerName
Customer ID
_______ is used to store alphanumeric data
Text
Number
Date time
Curency
Tick the Functions of a Database
Updating
Sorting
Editing
Playing
Fields in database are similar to _________ in tables.
Rows
Columns
Cells
Values
Which view of table is used to insert a field name in table.
Date sheet
Design
Database
all of the above
Which datatype will be used to generate numbers automatically while inserting data?
Number
Auto number
Automatic Number
Integer
Table Rows are called...
fields
records
table
entry
This can offer a way to view, format, and summarize the information in your Microsoft Access database.
query
table
form
report
record
Which of these is not an example of a field type?
Picture
Short Text
Date and Time
Yes/No
1. Data _____________ refers to ensuring accuracy and consistency of data.
Integrity
Collation
Assessment
System
How would you define a Query?
Created to see tables better
Allow you to retrieve data from tables
The wizard allows you to go step by step
What is ascending order?
Moving down the alphabet from Z to A.
To find a specific item in the table.
Moving up the alphabet from A to Z
sorting
