Introduction: Creating An Access Database

I am a program used to organize and manipulate data. I consist of fields, records, tables, queries and reports. What am I?

• A.

  I am an Spreadsheet program

• B.

  I am a word processing program

• C.

  I am a database program

• D.

  I am a Web Page Designing program

• E.

  I am a Desktop Publishing program

With database management systems, you need to create your tables before you can enter data. What are the options when creating a new database table? i.File , new database, table ii Create table in design view iii Create table by using wizard iv Create table by entering data

• A.

  I and ii only

• B.

  Iii and iv only

• C.

  I only

• D.

  Ii, iii and iv

• E.

  Iii only

The table structure of a database refers to which of the following?i Field name ii Data Type iii Description

• A.

  I and ii only

• B.

  Ii and iii only

• C.

  I, ii, and iii

• D.

  I and iii only

• E.

  None of the above

A ______________________ is the foundation for all queries, forms, and reports. The container for all these objects is the database.

True or False: When entering information into your database records, you can leave data out of a field if it is not available

When you create a table, you specify the data type for each field in the Table Design View. Text, Number, Date/Time, Currency, and Yes/No data types are self-explanatory. AutoNumber, increments each record by one. While Text fields can only contain up to 255 characters, Memo can include over 65,000 characters. OLE Objects enable you to insert graphics, sounds, and other data types. The Lookup data type will enable you to choose from a list of options. The Hyperlink data type enables you to launch an Access object (a table, form, query, and so on), another file in another application, or go to a Web site. Knowing all this Natavia is creating a database to store data on her friends, a sort of personal address book. She wants to include a field to specify which district in Belize is her friends favorite of all the lovely districts in Belize. Her best data type option would be ___________.

True or False:You can change a field's data type but, depending on the particular conversion, this process can lead to data loss.

True or False: When you first create a field in Table Design View, the field is automatically set to text and the default text field size is 50.

A ______________________ is a database file that contains no objects or data. It is an empty shell that you will use to add new tables, queries, forms, and reports.

True or False: You can create a new database that is blank or let the Database Wizard create one for you that contains the objects you specify for it.

True or False: When you use a wizard, Access enables you to choose from sample fields and then create the tables, queries, forms, reports, and switchboards for you.

Decimal places are basically the numbers after the decimal point (for example, 44 becomes 44.00 when you add two decimal places). When you work with numbers, having all related numbers with the same number of decimal places adds to the professional appearance of your output. Changing the number of decimal places only adds to the visual appearance of a number, not to its _________________.

Fredrick created a field called fullname in a table. This field was created to hold the persons full name. Fredrick later decided that this was not practical and decided to change the table design to add fields for first name and last name. This would be an example to show that if you no longer needed a field, you can ____________ it.

The ______________________________ property provides information or notes about fields in tables, and queries. ___________________ can be up to 255 characters in length.

You can set the field properties in Table ______________ View. Properties include name, data type, description, field length, validation rules, default values, and whatever you see on the General or Lookup tabs in table design.

Field size for text data type fields determines the ______________ number of characters you can enter for a field. You can set the field size for text up to 255 characters and the default is 50 characters unless you change the default.

A convenient place to create the structure of your database tables is Table ________________. This is where you add and remove fields, and it serves as a convenient place for getting an overview of the properties associated with your fields and table.

To modify a table, you must select that table in the Database window and open the table in the Table ____________________. In this view you can add or remove fields; change field names; change a field's data type; and add, modify, or delete descriptions, field properties, and table rules.

___________________ can be used to answer questions themselves, but can also be used as the foundation for forms and reports.

In datasheet view a row represents a _________________.