Exam 3: Access : Databases and Database Objects : an Introduction

In the accompanying figure, the key symbol that appears in the row selector for the Business Analyst Number field indicates that Business Analyst Number is the ____ for the table.

The maximum number of characters allowed in a field whose data type is Text is 255 characters.

In the accompanying figure, the words Datasheet View at the lower left of the screen appear on the ____________________.

One way to undo changes to a field is to click the Undo button on the Quick Access Toolbar.

As shown in the accompanying figure, you can use the End record button to move to the last record in the table.

Phil has been asked to create a database for his company.The database is to track employees and the projects on which the employees work.A project can have between 3 and 7 employees assigned to it.He has determined that he needs the following tables: Employee (Social Security Number, Employee Name, Street Address, City, State, Postal                   Code, Date Hired, Hourly Pay Rate, Project Code)Project (Project Code, Project Name, Completion Date)Which field in the Employee table should be the primary key and why?

Standard properties are associated with all Microsoft Office documents and include author, title, and subject.

____________________ is the storing of a piece of data in more than one place.

To open a table in Design view, right-click the table in the Navigation Pane and then click ____ on the shortcut menu

To compact and repair a database, click the ___ button in the Information gallery in the Backstage view.

The rows in the tables are called ____________________.

In Access, table names cannot contain digits.

When you create a database, you should follow some general guidelines for database design.What are these nine guidelines?

Green computing involves reducing the environmental waste generated when using a computer.

To insert a field between existing fields, right-click the column heading for the field that will follow the new field, and then click Insert Column on the shortcut menu.

To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.

To change the design of a query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.