Data Processing Practice Test – Data Modeling

Hello and Welcome to Data Processing Practice Test - Data Modeling

  1. You are to attempt 5 random objectives questions ONLY.
  2. Supply Your Full Name and Location in the text box below and begin immediately.
  3. You can attempt as many times as possible.
1. 


Arrange the following steps in the correct order for editing data type in data sheet view of a Microsoft Access database

I. Choose the type of data that will be entered into the fields
II. Click the data sheet tab on the ribbon
III. Click the field you wish to define
IV. Click the ‘down’ arrow next to the data type (WASSCE 2022)

A. I, III IV and II
B. IV, III, II and I
C. II, III, I and IV
D. III, II, IV and I

2. 


Why is it a mistake to use a text data type to store money values? (NECO 2015)

A. Calculation cannot be performed
B. Decimal place cannot be displayed
C. Currency sign cannot be displayed
D. Data cannot be sorted

3. 


Which of the following is not a database object? (NECO 2016)

A. Forms  B. Formulae  C. Queries  D. Reports

4. 


In Microsoft Access, how much storage capacity can date and time hold in data types? (NECO 2014)

A. 1 byte      B. 2 bytes     C. 4 bytes     D. 8 bytes

5. 


Which of the following is used to retrieve specific information from database tables? (WASSCE 2017)

A. Index   B. Query   C. Report   D. Tables

 

 

error: Content is protected !!