RelationalDBDesign
SiteMap
Data Manipulation
Access Features
Building Access DB
Tables Queries
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Creating Tables
«Prev
Next»
Access Database
Database Features
Open Access Database
MS Access Window
Access Help System
Access Database Window
Access Interface Conclusion
MS Access Database
What is Database
What is Relational Database
Design Relational Database
How Data is stored
Access Database Objects
Database Analysis
Create Access Database
Steps For Creating Database
Design Tables Conclusion
Creating Access Table
Creating Access Tables
Access Datasheet
Edit Access Datasheet
MS Access Functions
Importing Data
Import Access Table
Building Modifying Forms
Table Manipulation
Table Design View
Field Data Types
Changing DataType
Use InputMask To Limit Data
Selecting Table Fields
Adding Deleting Fields
Creating Hyperlinks In Access Table
Edit Table Design By Moving Field
Understanding Primary Key
Access Table Manipulation Conclusion
MS Access Functions - Quiz
1.
How do you enter data into a database?
Please select all the correct answers.
A.
Import data from another database
B.
Display a table in datasheet view and enter the data there
C.
Import data from another file, such as an Excel file
D.
Display the Table Wizard and enter the data there
2.
The Table Wizard automates the process of creating a table by
Please select the best answer.
A.
Creating tables and relationships between tables
B.
Providing a way to customize and create commonly used tables
C.
Importing data into a table from an external source
D.
Creating a form to simplify data entry into an existing table.
3.
Which of the following are commonly done when creating a table in Datasheet view?
Please select all the correct answers.
A.
Double-click the Create Table in Design View icon in the database window
B.
Rename fields so that they describe the data in them
C.
Choose fields from those offered by the Table Wizard
D.
Double-click the Create Table By Entering Data icon in the database window
4.
Which of the following actions displays the Print dialog box?
Please select all the correct answers.
A.
Clicking the Print button
B.
Pressing Ctrl-P
C.
Choosing File>Page Setup from the menu
D.
Choosing File>Print from the menu