Database Design & ApplicationCategory: Production & Objective Test
Two (2) parts: a production test administered and proctored at a designated school-site prior to the NLC and a 60-minute objective test administered onsite at NLC.
Production Test Competencies: Multiple Table Database Design; Table Creation, Inserting Data into Tables; Table SQL Statements; Creation of Forms/Reports
Objective Test Competencies: Data Definitions/Terminologies; Query Development; Table Relationships; Form Development; Reports and Forms
- Documents produced for this event must be prepared by the competitor without help from the adviser or any other person.
- Administration of the production test is determined by the state chair/adviser.
- No calculators are allowed to be used on the production test.
- The production score will constitute 85% of the final event score.
- The production test score will be used to break a tie.
- Tests must be uploaded online by 11:59 p.m. Eastern Time on the third Friday in May.
- No materials may be brought to the testing site.
- No calculators may be brought into the testing site; calculators will be provided.
- Electronic devices must be turned off and out of sight.
- Bring a writing instrument.
The general event guidelines below are applicable to all national competitive events. Please review and follow these guidelines when competing at the national level. When competing at the state level, check the state guidelines since they may differ.
- Dues: Competitors must have paid FBLA national and state dues by 11:59 p.m. Eastern Time on March 1 of the current school year.
- NLC Registration: Participants must be registered for the NLC and pay the national conference registration fee in order to participate in competitive events.
- Deadlines: The state chair, or designee, must register each state competitor on the official online entry forms by 11:59 p.m. Eastern Time on the second Friday in May.
- Each state may submit four (4) entries in all events except LifeSmarts, Virtual Business Finance Challenge, and Virtual Business Management Challenge.
- Each competitor can only compete in one (1) individual/ team event and one (1) chapter event.
- Each competitor must compete in all parts of an event for award eligibility.
- A team shall consist of two or three members. Exceptions are Parliamentary Procedure which must be a team of four or five members, and LifeSmarts which must be a team of two members.
Competitors are not permitted to compete in an event more than once at the NLC unless one of the following circumstances applies:
- Modified Events: A competitor may compete in the same event when the event is modified. Note, if the only modification is a name change, competitors may not compete in the renamed event.
- Team Events: One (1) competitor of the team may have competed in the same event at one (1) previous NLC; however, they may not compete more than twice in the event at the national level.
- Chapter Events: Competitors may compete in a chapter event more than once (American Enterprise Project, Community Service Project, and Partnership with Business Project).
- Individual Entry: A competitor who competed as an individual entry in a team event at the national level may compete in the same event a second time as part of a team, but not a second time as an individual.
- Parliamentary Procedure: Two (2) competitors of the team may have competed in this event at a previous NLC; however, they may not compete more than twice at the national level.
- Pilot Event: Competition in a pilot event does not disqualify a competitor from competing in the same event if it becomes an official competitive event. The participant may compete in another event as well as a pilot event.
- Objective Tests: Ties are broken by comparing the correct number of answers to the last 10 questions on the exam. If a tie remains, the competitor who completed the test in a shorter amount of time will place higher. If this does not break the tie, answers to the last 20 questions will be reviewed and determine the winner.
- Objective and Production Tests: The production test scores will be used to break a tie.
- Objective Tests and Performances: The objective test score will be used to break a tie based on the tie-breaking criteria of objective tests.
- Reports/Projects and Performances: The report/project scores will be used to break a tie.
- Performances: Judges must break ties and all judges’ decisions are final.
- State chair/adviser must register all competitors for NLC competitive events online by 11:59 p.m. Eastern Time on the second Friday in May.
- All prejudged components (reports, websites, projects, statement of assurance) must be received by 11:59 p.m. Eastern Time on the second Friday in May.
- All prejudged projects and reports must be submitted electronically.
- All Statements of Assurance must be submitted online.
- All production tests must be received at FBLA-PBL by 11:59 p.m. Eastern Time on the third Friday in May.
- All production tests must be uploaded online.
- State chair/adviser may make name changes only (no additional entries) by 11:59 p.m. Eastern Time on the first Friday in June. Competitor drops are the only changes allowed after this date and onsite.
The number of competitors will determine the number of winners. The maximum number of winners for each competitive event is 10. Only one (1) award is given to the schools competing in chapter events (American Enterprise Project, Community Service Project, Local Chapter Annual Business Report, and Partnership with Business Project).
Certain events may allow the use of additional materials. Please refer to event guidelines.
Americans with Disabilities Act (ADA)
FBLA‑PBL meets the criteria specified in the Americans with Disabilities Act for all participants who submit a special needs form.
Recording of Presentations
No unauthorized audio or video recording devices will be allowed in any competitive event. Participants in the performance events should be aware the national association reserves the right to record any performance for use in study or training materials.
Sample Practice Materials
2. Evaluate and compare a variety of database programs for features and functions.
3. Determine when it is appropriate to use a database and identify the benefits derived.
4. Demonstrate correct use of database terminology.
5. Plan, design, and create a database file.
6. Construct database using appropriate inputting, formatting, and editing skills.
7. Set and modify field properties including limit field size, number formats, date/time formats, yes/no formats, validation rules, and input masks.
8. Distinguish between different field types.
9. Define and modify field names and data types.
10. Manipulate a database.
11. Import and export data into and from a database.
12. Save database objects as file types.
13. Use the Help feature of database software.
14. Compact and repair a database
15. Produce documents integrating word processing, database, spreadsheet, and presentation files
2. Create a query in design view
3. Search, sort, index, merge, and manipulate database for specific information.
4. Filter data (sort, find specific records, and replace)
5. Create multi-table queries.
6. Design and create action queries (make-table, update, append, and delete).
7. Design and create advanced queries (setting top values, creating calculated field, creating function query, and creating parameter query).
8. Verify accuracy of output
2. Use table wizard and design view to create a table.
3. Add records to tables.
4. Apply the default values, input masks, validation rules, validation text, required fields, and lookup fields to field properties in a table in design view.
5. Understand the difference between a one-to-one, one-to-many, and many-to-many relationships.
6. Enforce referential integrity.
7. Create and modify a multi-table select inquiry.
8. Save a table, query, and forms as a Web page.
9. Import/export linked tables
2. Create a form with the form wizard.
3. Create a form based on a query.
4. Modify Format Properties.
5. Enter and delete records using a datasheet or form.
6. Use the control Toolbox to add controls, move a control, and resize a control.
7. View and print records in a form.
8. Use design view to disable the snap to grid feature, display the field list, move, move part of a paired control, align and space controls, add a label or image, and to edit an unbound control.
9. Create and modify a subform.
2. Design, create, save, and modify reports for data output.
3. Enhance reports using formatting features and graphics.
4. Preview and print a report.
5. Modify and format report properties (font, style font size, color, and caption).
6. Use report sections.
7. Perform grouping and sorting to a report.
8. Create reports using all types of controls including Active X and calculated totals.
9. Use advanced report design to create a running summary, insert a date/time control, and use label wizard.
- Information Technology
- Business Management & Administration
- Information Techology