CGS2100 Access Exam UPDATED ACTUAL
Exam Questions and CORRECT Answers
Primary Key - CORRECT ANSWER - Unique identifier of a record
Foreign Key - CORRECT ANSWER - a key that links one field in one table with a row of
another table
Referencial Integrity - CORRECT ANSWER - A set of rules saying table relationships
must be consistent when you update data in the database
SQL - CORRECT ANSWER - Structured query language
How to write in SQL - CORRECT ANSWER - Select Last_Name
From Contacts
Some things Access prevents you from doing while a table is open. Why? - CORRECT
ANSWER - Renaming them, deleting them
Database - CORRECT ANSWER - Structured set of data
Table - CORRECT ANSWER - A collection of fields describing things.
Record - CORRECT ANSWER - A complete set of field values for a specific person,
place, object, event, or idea.
Query - CORRECT ANSWER - A question about data stored in the database
How to create a database - CORRECT ANSWER - 1) Start Access
, 2) Click "Blank desktop database"
3)Type a field name for it
4)Choose a folder you want to store it in
5)Click "Create"
How to create a table - CORRECT ANSWER - 1)Click "Table design" in the create tab
2)Type the name of the first field into the field name column
3)Select its datatype
4)Type a description for the field into the description column
5)Select a primary key
6)Click "Save" and name the table then click "OK"
How to create a simple query - CORRECT ANSWER - 1)Click the create tab and click
"Query Design"
2)Select the table you want to run a query on
3)Click add then close
4)double-click the field names you want to include
5)Set a search criteria by clicking the criteria in each row
6)Click Run! and save and name the query
How to create a simple report - CORRECT ANSWER - 1)Click the table or query you
want to create a report on
2)Click "Report" on the Create tab
3)resize the fields
4)Save and name your report
Differential relationships: One-to-one - CORRECT ANSWER - for each record theres only
one matching record in a different table
Exam Questions and CORRECT Answers
Primary Key - CORRECT ANSWER - Unique identifier of a record
Foreign Key - CORRECT ANSWER - a key that links one field in one table with a row of
another table
Referencial Integrity - CORRECT ANSWER - A set of rules saying table relationships
must be consistent when you update data in the database
SQL - CORRECT ANSWER - Structured query language
How to write in SQL - CORRECT ANSWER - Select Last_Name
From Contacts
Some things Access prevents you from doing while a table is open. Why? - CORRECT
ANSWER - Renaming them, deleting them
Database - CORRECT ANSWER - Structured set of data
Table - CORRECT ANSWER - A collection of fields describing things.
Record - CORRECT ANSWER - A complete set of field values for a specific person,
place, object, event, or idea.
Query - CORRECT ANSWER - A question about data stored in the database
How to create a database - CORRECT ANSWER - 1) Start Access
, 2) Click "Blank desktop database"
3)Type a field name for it
4)Choose a folder you want to store it in
5)Click "Create"
How to create a table - CORRECT ANSWER - 1)Click "Table design" in the create tab
2)Type the name of the first field into the field name column
3)Select its datatype
4)Type a description for the field into the description column
5)Select a primary key
6)Click "Save" and name the table then click "OK"
How to create a simple query - CORRECT ANSWER - 1)Click the create tab and click
"Query Design"
2)Select the table you want to run a query on
3)Click add then close
4)double-click the field names you want to include
5)Set a search criteria by clicking the criteria in each row
6)Click Run! and save and name the query
How to create a simple report - CORRECT ANSWER - 1)Click the table or query you
want to create a report on
2)Click "Report" on the Create tab
3)resize the fields
4)Save and name your report
Differential relationships: One-to-one - CORRECT ANSWER - for each record theres only
one matching record in a different table
