Business Info Man - 1st 6 - Part 1

You want to store events, members, and inventories for the New Horizon Candle Company and you need to collect the information into a single database.  What is the EASIEST function available in MS Access to begin collecting data quickly?

• Create a Blank Database.

• Use a pre-designed Template.

• Design a Query for each category.

• Add new records to their spreadsheet.

Suppose you started a new job recently. While you were completing your employee information forms online, you noticed that you must enter the same information several times.  What function in MS Access might help your company eliminate the need to enter duplicate data?

• Use multiple tables

• Use repeating records

• Use different fields

• Use related tables

Suppose you are going to store medical records for your patients and you need to be consistent in logging the important pieces of data or information for each patient. Your database structure needs to include which basic element?

• Marking Key

• Fields

• Text Elements

• Blocks

You've been assigned to build a database containing information on every student in your school. Suppose that you want an easy way to find the names of students in the Spanish Club and what date they joined the club.

What is the best function in MS Access for you to use to produce the information quickly?

• A table

• A search

• a record

• a filter

What is the EASIEST way to designate a primary key in its field?

• Double-click on the record and select "Primary Key."

• Right-click on the record and select "Primary Key."

• Right-click on the "Primary Key and select the record.

• Select "Primary Key" and then Right-click on the record.

Which of these describes the best way to know when it is time to move your data from other software (like Word or Excel) to a database?

• The amount of fields you have stored on lists  becomes too difficult to manage.

• The amount of tables you have stored on lists  becomes too difficult to manage.

• The amount of folders you have stored on lists  becomes too difficult to manage.

• The amount of data you have stored on lists  becomes too difficult to manage.

In MS Access, which of the following statements is the MOST correct?

• Design view is where you create and maintain fields that contain the data.

• Design view is the screen on which you actually enter the data into those fields.

• Datasheet view is the screen on which you actually enter the fields into those data.

• Datasheet view is where you create and maintain fields that contain the data.

Suppose you are creating a new Contact List database. When adding the Birthday field, you are defining the field as a date field. Which of these methods will the records be sorted by?

• The dates will sort by birth day.

• The dates will sort by birth month.

• The dates will sort by month, day and year.

• The dates will sort by birth year, month, and day.

Tables contain data (bits or pieces of information) about one subject. How are these tables arranged? 

• In forms (records) and queries (fields).

• In forms (columns) and queries (rows)

• In rows (records) and columns (fields).

• In rows (fields) and columns (records).

Which answer MOST ACCURATELY describes how the Design View functions?

• The Design view is where you create and maintain fields that contain the data.

• The Design view is where you create and maintain records that contain the data.

• The Design view is where you enter and maintain records that contain the data.

• The Design view is where you create and maintain data that are contained the fields.